Login Skip Navigation LinksWilsonORMapper > Forums Search
Demo Version Demo Version
Download and try for yourself a fully working demo version, including sample apps and documentation.  The only limitation is that the demo version only works inside the debugger.

PayPal Subscribe
Get It All for $50 USD:
WebPortal, ORMapper,
Source Code, All Updates
PayPal

User Login User Login
Log In
 
 
Reset Password

Wilson ORMapper Forums Wilson ORMapper Forums : Feature Requests : SQL Server Compact Edition

Date Post
3/25/2007 2:41:44 PM

Is there any plans to make and/or test WORM against the SQL Server Compact Edition. I'm currently using the Compact Edition for a desktop application, and would benefit greatly from being able to use the ORM therein.

Many thanks,

Sean
3/25/2007 10:20:21 PM

The ORMapper works with Sql Express, which I would have thought would be sufficient for desktop applications since it is free.  There's probably something obvious I've missed, but what does Sql CE bring to the desktop that causes you to choose it?  I'm curious for my own interest, but regardless of your answer, I would still like to think that I could support Sql CE possibly too.  I haven't worked with Sql CE in a long time though, and never much, so anything you can tell me about what doesn't work with the ORMapper would be helpful.

Thanks, Paul Wilson
3/26/2007 8:36:37 AM

Hi Paul,

I've used SQLExpress for a good while now also. However, with SQLExpress, as with MSDE before that, there's a lengthy and often complicated installation process. SQL Server Compact Ed has practically no installation, as it's an inproc DB. In fact, the DLLs can be deployed with the application installation - no cumbersome database installation necessary!

I don't know why it would not be possible to use the generic ADO.NET classes SQLconnection, SQLCommand, etc. In fact, I think the latest version of the Enterprise Library (3.0) now encorporates SQLCE data classes.

Regards,

Sean
3/26/2007 12:38:03 PM

So have you tried using the mapper with Sql CE?  If not, I would recommend that you try.  If you have, what worked and what didn't work?

Thanks, Paul Wilson
3/26/2007 3:30:21 PM

hi Paul,

No, I haven't tried the SQL Server Compact Edition. There's no driver/provider provided (excuse the pun).

Regards,

Sean
3/26/2007 7:23:28 PM

Yea, I realize there's not a hard-coded provider, but there is a CustomProvider option that is used for MySql and many other databases.  So I'm wondering if you've tried that and had any luck or problems.  That should work for most cases pretty well, at least that would be my guess, and I guess I'm hoping to avoid another hard-coded provider if it isn't necessary.

Thanks, Paul Wilson
3/27/2007 6:44:33 PM

http://ormapper.net/Forums/Default.aspx?part=74&action=thread&id=830&key=M2gBbeyCOJ5Neo8TgUi9ug%3d%3d

Never tried it myself but you would think it would work.