Telerik ORM Reverse Mapping with SQL CE 4.0 error

Thread is closed for posting
3 posts, 0 answers
  1. Anurag
    Anurag avatar
    2 posts
    Member since:
    Nov 2010

    Posted 08 Sep 2012 Link to this post

    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=, 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=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies.
  2. Anurag
    Anurag avatar
    2 posts
    Member since:
    Nov 2010

    Posted 08 Sep 2012 Link to this post

    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?
  3. Ady
    Ady avatar
    589 posts

    Posted 13 Sep 2012 Link to this post

    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.

    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!
Back to Top