SQLCE Support

16 posts, 0 answers
  1. Jeff Bowman
    Jeff Bowman avatar
    14 posts
    Member since:
    Aug 2003

    Posted 29 Nov 2008 Link to this post

    Hello

    Does the Express edition support SQLCE?

    Thanks,
    Jeff
  2. Peter Brunner
    Admin
    Peter Brunner avatar
    89 posts

    Posted 01 Dec 2008 Link to this post

    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.
  3. DevCraft banner
  4. Jeff Bowman
    Jeff Bowman avatar
    14 posts
    Member since:
    Aug 2003

    Posted 01 Dec 2008 Link to this post

    OK, thanks  :)
  5. Dusan
    Dusan avatar
    1 posts
    Member since:
    Jan 2009

    Posted 09 Jan 2009 Link to this post


    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
  6. Peter Brunner
    Admin
    Peter Brunner avatar
    89 posts

    Posted 09 Jan 2009 Link to this post

    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.
  7. abhay
    abhay avatar
    9 posts
    Member since:
    Jan 2009

    Posted 12 Mar 2009 Link to this post

    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

  8. Peter Brunner
    Admin
    Peter Brunner avatar
    89 posts

    Posted 12 Mar 2009 Link to this post

    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.
  9. Henrique Duarte
    Henrique Duarte avatar
    104 posts
    Member since:
    Oct 2003

    Posted 23 Jun 2009 Link to this post

    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
  10. Jeff Bowman
    Jeff Bowman avatar
    14 posts
    Member since:
    Aug 2003

    Posted 23 Jun 2009 Link to this post

    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
  11. Henrique Duarte
    Henrique Duarte avatar
    104 posts
    Member since:
    Oct 2003

    Posted 23 Jun 2009 Link to this post

    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
  12. Jeff Bowman
    Jeff Bowman avatar
    14 posts
    Member since:
    Aug 2003

    Posted 23 Jun 2009 Link to this post

    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
  13. Henrique Duarte
    Henrique Duarte avatar
    104 posts
    Member since:
    Oct 2003

    Posted 23 Jun 2009 Link to this post

    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
  14. Jeff Bowman
    Jeff Bowman avatar
    14 posts
    Member since:
    Aug 2003

    Posted 23 Jun 2009 Link to this post

    Got it, thanks!
  15. Peter
    Peter avatar
    10 posts
    Member since:
    Oct 2008

    Posted 24 Jun 2009 Link to this post

    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
  16. Chris
    Chris avatar
    40 posts
    Member since:
    Feb 2009

    Posted 12 Dec 2011 Link to this post

    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?
  17. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 13 Dec 2011 Link to this post

    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. 
Back to Top
DevCraft banner