SQL Server Compact Edition RC1 AKA SQL Everywhere

Posts   
 
    
Angus
User
Posts: 44
Joined: 08-Jul-2005
# Posted on: 17-Nov-2006 17:50:16   

I know that there have been several posts about SQL Server Everywhere, now officially named SQL Server Compact Edition, and that LLBLGen's official stand is to use the CF for existing as the new database has not been released yet. Now with the official RC1 being out, the RTM should be out by the end of the year.

I would like to cast my vote to have full support for this via LLBL Gen. As SQL Compact Edition will not support SPs or Views (or any code whatsoever) that just makes the use of a tool like LLBLGEN even that much more necessary. I can't image writing a bunch of select statements in code to query this new engine. I have several projects in mind that I was planning on using "Access" as the database but really did not want to because general users can open up in "Access" and mess with things. Sql Compact Edition is a great fit in this situation.

Franz you have done such a great job in supporting all of us, I really look forward to native support for the Compact Edition.

For those of you who may not know what Sql Compact Edition is.... here is the blog on it http://blogs.msdn.com/SQLServerEverywhere/

I would like to know how many others have a use for Sql Compact Edition or would like to have native LLBLGEN Support for it.
Thanks!

Again Keep up the Awesome work Franz!! smile

PilotBob
User
Posts: 105
Joined: 29-Jul-2005
# Posted on: 17-Nov-2006 23:42:40   

Angus wrote:

I have several projects in mind that I was planning on using "Access" as the database but really did not want to because general users can open up in "Access" and mess with things. Sql Compact Edition is a great fit in this situation.

These are going to be single user apps, right?

BOb

Angus
User
Posts: 44
Joined: 08-Jul-2005
# Posted on: 17-Nov-2006 23:52:05   

PilotBob wrote:

Angus wrote:

I have several projects in mind that I was planning on using "Access" as the database but really did not want to because general users can open up in "Access" and mess with things. Sql Compact Edition is a great fit in this situation.

These are going to be single user apps, right?

BOb

Yes. Single User!

Sql Compact Edition is an embedded file based database that will be 100% upgradable / synchronizeable with SQL Server. The great part about it is it can be Click Once deployable, can run side by side with older / newer versions of SQL CE. The entire database is 7 dlls (plus database file) that can be xcopied, takes up only 1.4 megs of space and does not require that a user create a Service on their desktop (as Sql Express does) which some people don't like as it is a _**possible **_security risk.

Chester
Support Team
Posts: 223
Joined: 15-Jul-2005
# Posted on: 18-Nov-2006 20:52:42   

Interesting that it will run as in-process DLL's. They've finally replaced the old "JET" engine of Microsoft Access (which is still a great DB engine for desktop apps IMHO). At least if you're going to use it in a desktop app.

As for the support for SQL Compact Edition I'll have to let Otis comment on if/when that might be supported. simple_smile

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 20-Nov-2006 10:48:06   

I don't know if sql ce will support meta-data retrieval, probably not, so a project has to be created on a normal sqlserver instance, then copied to the sqlserver ce db either by ddl sql or through replication.

What's a bit of a problem is the way MS uses namespaces in this. It would be best if it would be possible to access the desktop variant with the sqlclient namespace, so the normal sqlserver DQE could be used. If not, it would be a bit of a pain as I then have to build yet another DQE for sqlserver...

Frans Bouma | Lead developer LLBLGen Pro
rboarman
User
Posts: 83
Joined: 01-Feb-2005
# Posted on: 27-Nov-2006 21:14:12   

I second this request. Using LLBL in this scenario will prove to be of imense value.

Having to keep a mirror copy of the schema in SQL Server to use as a template for code generation seems fine to me. I tend to do that anyways.

Rick

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 28-Nov-2006 11:04:14   

I'm pretty sure that recompiling the SqlCE DQE for normal .NET will do the trick, but we'll look into having project creation on sql compact edition as well, but only after it's been released. We have a lot of new features planned for v2.1 and these have a higher priority mostly as there are alternatives. But as it's likely that the support doesn't require a lot of extra/new code it's likely to be straight forward. Though as I said, there are other features we also would like to add and frankly I prefer adding those above adding support for yet another sqlserver variant considering the 'fun' it was/still is supporting SqlCE on the CF.NET

Frans Bouma | Lead developer LLBLGen Pro
Posts: 10
Joined: 26-Oct-2006
# Posted on: 15-Jan-2007 10:37:46   

Thirded. SQL Compact Edition support would be of high value to us. I tried using a CF-built project from a full-framework application on a computer with SQL Server CE installed, and simple operations (save, fetch) appear to work (didn't try anything advanced). So hopefully, as you say, this can be fixed by a simple recompile.

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# Posted on: 16-Jan-2007 04:00:55   

Thanks for the feedback. I believe it's still in CTP, but once the RTM is released a decision can be made on its support.

Posts: 10
Joined: 26-Oct-2006
# Posted on: 16-Jan-2007 08:55:28   

SQL Server 2005 Compact Edition went RTM in december 2006! sunglasses

See http://www.microsoft.com/sql/editions/compact/default.mspx

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 16-Jan-2007 11:06:51   

Yes I saw that simple_smile . I'll add support for that in v2.1 (scheduled for beta in late Q1 2007 (end of march, early april)

Frans Bouma | Lead developer LLBLGen Pro
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 24-Feb-2007 13:24:07   

I am looking forward to it sunglasses

Please let me know if you have something to evaluate. I have already build an application that use the Sql Server Compact Edition.

Regards, Carlo

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 25-Feb-2007 14:12:29   

v2.1 should have support for it. We'll slip a bit with the date of the first beta I think so it will be in april when something is available.

Frans Bouma | Lead developer LLBLGen Pro
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 14-Mar-2007 09:48:49   

My blood preasure increases wink I must get it under control.

Please hurry up with the beta.

Regards, Carlo

cjarman66
User
Posts: 22
Joined: 19-Nov-2006
# Posted on: 17-Apr-2007 19:33:25   

Would the ORM API targeting SQL Sever 2005 also work for SQL Server CE? I have a project where the one system needs to work both online and offline. I have the option of using SQL Server Express, but that may be overkill. Would there be a way to use to same ORM code base for both online and offline mode?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 18-Apr-2007 22:59:26   

You'll use a sqlserver 2005/2000 project to target CE, so you will create the project first on 2005, then generate code for CE as CE doesn't have meta-data exposed in itself.

Frans Bouma | Lead developer LLBLGen Pro
cako
User
Posts: 18
Joined: 11-Jan-2007
# Posted on: 28-Apr-2007 06:20:04   

I was wondering whether you are going to support some of the standard LLBLGEN features you could not support because of the Compact Framework since the Compact Edition will be running now on the standard .NET framework.

Here are some examples from the documentation: Remoting, serialization to/from SOAP/Binary formatter COM+, enterprise services functionality. Design time databinding App.Config reading. Users should supply the connection string to either the Adapter constructor or to DbUtils.ActualConnectionString.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 29-Apr-2007 11:36:59   

cako wrote:

I was wondering whether you are going to support some of the standard LLBLGEN features you could not support because of the Compact Framework since the Compact Edition will be running now on the standard .NET framework.

SqlserverCE is planned for the upgrade for v2.0 currently in development. It will mainly be the same CE DQE but now build on the normal .NET framework and you can use it with the normal SqlServer templates, perhaps with here and there a conditional compile for the DQE reference but that's it.

Frans Bouma | Lead developer LLBLGen Pro
rboarman
User
Posts: 83
Joined: 01-Feb-2005
# Posted on: 13-Jun-2007 00:43:25   

Hello,

I was wondering what the status is on this functionality? I'm about ready to start working on an application that could use support for CE.

Thanks,

Rick

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 13-Jun-2007 21:12:37   

rboarman wrote:

Hello,

I was wondering what the status is on this functionality? I'm about ready to start working on an application that could use support for CE.

Thanks,

Rick

Sqlserver compact edition for the desktop will be added to v2.5 in the coming month, during the beta period of v2.5 (which will go into beta tomorrow (thursday))

Frans Bouma | Lead developer LLBLGen Pro