This question is locked. New answers and comments are not allowed.
I have been using Telerik ORM 2011 Q3 reverse mapping with SQL CE 3.5 and it was working fine. We wanted to upgrade to SQL CE 4.0 and it is not working. It keeps looking for SQL CE 3.5 files. We are using default northwind database that comes with SQL CE 4.0 and so the DB is 4.0 but when i try to test the connection, it keeps giving error. We have added SQL CE 4.0 reference in App.cofnig and even added 4.0 files in references. Still no luck. Any suggestions?
Here is the stack trace
Backend=sqlce;ConnectionString=Data Source="C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Samples\Northwind.sdf"; provider=System.Data.SqlServerCe.4.0;
The connection could not be established. The reason was:
Unknown failure
Exception: Telerik.OpenAccess.OpenAccessException
Cause: System.Configuration.ConfigurationErrorsException: Database provider System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 not installed properly (CLR=v4.0.30319 32bit). ---> System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies.
Here is the stack trace
Backend=sqlce;ConnectionString=Data Source="C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Samples\Northwind.sdf"; provider=System.Data.SqlServerCe.4.0;
The connection could not be established. The reason was:
Unknown failure
Exception: Telerik.OpenAccess.OpenAccessException
Cause: System.Configuration.ConfigurationErrorsException: Database provider System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 not installed properly (CLR=v4.0.30319 32bit). ---> System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies.
2 Answers, 1 is accepted
0
Anurag
Top achievements
Rank 1
Rank 1
answered on 08 Sep 2012, 09:34 PM
One more thing. i removed sql ce 3.5 to see if that makes it look for 4.0 assemblies and thats why you will notice the error "assembly not found" but the point i am making is why is it not looking for 4.0 assemblies?
0
Hi Anurag,
The 'classic' wizards ,which includes the Reverse mapping wizard, are in the maintenance mode. We have frozen all new development for these wizards for some time now. I did verify the error with Sql CE 4.0.
Can you try the 'Domain model' wizard to try and connect to a SQL CE 4.0 database? You can find more information on how to do this, here. With the new context approach you will benefit from all new features and also an easier API.
Nevertheless I will fix the problem for the Reverse mapping wizard and the fix should make it to the Q3 release.
Regards,
Ady
the Telerik team
The 'classic' wizards ,which includes the Reverse mapping wizard, are in the maintenance mode. We have frozen all new development for these wizards for some time now. I did verify the error with Sql CE 4.0.
Can you try the 'Domain model' wizard to try and connect to a SQL CE 4.0 database? You can find more information on how to do this, here. With the new context approach you will benefit from all new features and also an easier API.
Nevertheless I will fix the problem for the Reverse mapping wizard and the fix should make it to the Q3 release.
Regards,
Ady
the Telerik team
Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!