Home / Community & Support / Developer Productivity Tools Forums / OpenAccess ORM > OpenAccess ORM Free Edition > SQLCE Support

• Jeff Bowman

  Posted on Nov 29, 2008 (permalink)

  Hello
  
  Does the Express edition support SQLCE?
  
  Thanks,
  Jeff
  

  Reply

• Peter Brunner Peter Brunner

  Posted on Dec 1, 2008 (permalink)

  Hello Jeff ,
  
  the Express version always supports the same databases as the full version. So currently we do not support  CE. We will decide on more databases early next year and CE is on the current discussion list.
  
  Please check back again our Roadmap end of February 2009.
  
  Please do not hesitate to contact us for any further question.
  
  Best wishes,
  Peter Brunner
  the Telerik team

  
  Check out Telerik Trainer, the state of the art learning tool for Telerik products.

  Reply

• Jeff Bowman

  Posted on Dec 1, 2008 (permalink)

  OK, thanks  :)
  

  Reply

• Dusan

  Posted on Jan 9, 2009 (permalink)

  
  I have the same requirement myself. SQL CE 3.5 SP1 (and above) is an amazing little thing.  It is the MDB file of the future. But with the full TSQL inside.It is "invented" for mobile devices but I can not stop wondering how fully functional it is ?! It blows away a lot of DB's we today use for local storage, including XML files. It is free,  I better stop, before anyone suspects I work for M$FT ...
  
  The first thing I wanted to do after downloading Telerik ORM Express was to use it with SQL CE ... but ...
  
  It seems TORM bypasses MDAC mechanisms? I mean the ones behind a standard dialogue which pops up when executing an UDL file.
  I think this is to achieve connectivity with some non M$ databases. But stil, I dare to suggest, that if UDL's will be *also* used TORM will be able to connect to anything MDAC can connect to. ADO.NET does it like this :
  cnPubs.ConnectionString = "File Name=C:\Path\To\Pubs.udl;" 
  ( I am not sure if this limits the one to the ADO.NET only, though )
  
  BTW: On the first view, TORM looks pretty mature to me. Good work!
  
  Dusan
  

  Reply

• Peter Brunner Peter Brunner

  Posted on Jan 9, 2009 (permalink)

  Hi Dusan,
  
  thanks for the feedback. We have updated our roadmap in the meantime; it includes an outlook to the upcoming databases to be supported. SQL CE will be next, due in Spring.
  
  Thanks for your patience.
  
  Sincerely yours,
  Peter Brunner
  the Telerik team

  
  Check out Telerik Trainer, the state of the art learning tool for Telerik products.

  Reply

• abhay

  Posted on Mar 12, 2009 (permalink)

  Hi
  I just downloaded the new March release 2009 Q1, but it doesnt contain the support for SQL CE....Please add it or help us add the support.
  
  Thank you
  
  

  Reply

• Peter Brunner Peter Brunner

  Posted on Mar 12, 2009 (permalink)

  Hello abhay,
  
  Thanks again for your interest.
  
  We are sorry, but when we said Spring, we did not mean our Q1 release getting ready for download today, but "Spring" which means some time during April, May or June. So current plans are to have it in one of our Q1 Service Packs.
  
  We will update our Q2 Roadmap in the beginning of April.
  
  There is no way to do it on your own.
  
  Thank you for your understanding and patience.
  
  All the best,
  Peter Brunner
  the Telerik team

  
  Instantly find answers to your questions on the new Telerik Support Portal.
  Check out the tips for optimizing your support resource searches.

  Reply

• Henrique Duarte Intermediate

  Posted on Jun 23, 2009 (permalink)

  Hello guys,
  
  The support for CE will not be included on Q2 '09, right?
  When it will be available?
  Microsoft Sync Framework help us a lot to manage data, but it needs CE and to access the data, I need to use EF.
  I don't know about the others, but I really hate Entity Framework!
  
  Best regards,
  
  Henrique

  Reply

• Jeff Bowman

  Posted on Jun 23, 2009 (permalink)

  Hello Henrique
  
  What is it you dislike about EF? I'm about to try it for a project and you've got me curious.
  
  Let me know...
  
  Thanks,
  Jeff
  

  Reply

• Henrique Duarte Intermediate

  Posted on Jun 23, 2009 (permalink)

  Hello Jeff,
  
  To make it simple: EF don't have a lot of functionalities that other O/RM have.
  POCO is one of them.
  IMHO: if you can use OpenAccess, use it or Linq2SQL. But if you need to access SQL CE, use ADO.NET.
  
  I'm working on a project that uses Microsoft Sync Framework to synchronize the tables on users machines and it really helps a lot!
  To access the SQL CE I was trying the Entity Framework .... (terrible idea!)
  To add a record on a table that have relationship with other table is a pain.
  You need to find the related object first even if you already have the ID!
  Sometimes you can you the SelectedItem to do it, but it's almost normal get errors with objects in different contexts.
  
  They promised to solve these problems with EF4.0 (.Net 4.0) but it will be available only at the end of the year.
  
  Sorry about my english. I hope you can understand me.
  
  Best regards,
  
  Henrique

  Reply

• Jeff Bowman

  Posted on Jun 23, 2009 (permalink)

  Hm, that doesn't sound good.
  
  So, do I understand you correctly—are you saying that you're running into problems with EF using SQLCE that you wouldn't be if you were using SQL Server?
  
  Like yourself I was planning on using the Sync Framework, but not until way in the future when I introduce multi-user capabilities into my app. So I suppose I'll have to wait to experience the joys of SF  :-)
  
  Any further problems using SQLCE/EF other than the ones you've mentioned here?
  
  Thanks,
  Jeff
  

  Reply

• Henrique Duarte Intermediate

  Posted on Jun 23, 2009 (permalink)

  The problem is in EF, no matter which DB you use.
  I was telling you my experience with SQL CE, but the problems exists even if I use with SQL Server.
  An especific problem that I had with EF / SQL CE: you cannot use equals (==) operator with nchar column. I'm using a workaround for that:

  ctx.ContaContabil.Where("it.CdContaContabil == '" + iCdContaContabil.SelectedValue.ToString() + "'").First();

  
  Try to search on google some opinions about EF before you use it. You'll see that a lot of people don't like it (yet, maybe on next version).
  
  Best regards,
  
  Henrique

  Reply

• Jeff Bowman

  Posted on Jun 23, 2009 (permalink)

  Got it, thanks!

  Reply

• Peter

  Posted on Jun 24, 2009 (permalink)

  Hi Henrique,
  
  just to follow up on your question about SLQ CE support availability:
  
  It will be supported with or around our Q3 release later in the year, because it got postponed due to re-prioritization of our Roadmap.
  
  You can always check the current status on our Roadmap, which will be updated soon again.
  
  Best, Peter
  The Telerik team

  Reply

• Chris

  Posted on Dec 12, 2011 (permalink)

  The site now says that SQL CE 3.5 SP1 and 4.0 are supported. How do you tell Open Access to use one over the other?

  Reply

• Ivailo Ivailo

  Posted on Dec 13, 2011 (permalink)

  Hi Chris,
  
  The integration of this database in Visual Studio is not complete, so what you can do is select the one that appears in the connection selection screen and then manually replace the version in the connection string of your app.config or web.config files if it is not the one you prefer. 
  

  Do not hesitate to get back to us if you have further questions.
  
  

  Kind regards,
  Ivailo
  the Telerik team

  Want to use Telerik OpenAccess with SQL Azure? Download the trial version today. 

  Reply

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / OpenAccess ORM > OpenAccess ORM Free Edition > SQLCE Support