Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Designer> SQL Server Compact Edition RC1 AKA SQL Everywhere
 

Pages: 1
Designer
SQL Server Compact Edition RC1 AKA SQL Everywhere
Page:1/1 

  Print all messages in this thread  
Poster Message
Angus
User



Location:
Rockford, IL
Joined on:
08-Jul-2005 21:59:38
Posted:
44 posts
# 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!!
Laugh
  Top
PilotBob
User



Location:

Joined on:
29-Jul-2005 19:00:38
Posted:
105 posts
# 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



  Top
Angus
User



Location:
Rockford, IL
Joined on:
08-Jul-2005 21:59:38
Posted:
44 posts
# 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.
  Top
Chester
Support Team



Location:
Chicago, IL USA
Joined on:
15-Jul-2005 22:38:41
Posted:
223 posts
# 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. Regular Smiley


  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
# 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
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
rboarman
User



Location:
United States
Joined on:
01-Feb-2005 18:27:43
Posted:
83 posts
# 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


  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
# 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
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
WilhelmSvenselius
User



Location:

Joined on:
26-Oct-2006 13:01:12
Posted:
10 posts
# 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.

  Top
bclubb
User



Location:
Norman, Oklahoma
Joined on:
12-Feb-2004 22:18:04
Posted:
934 posts
# 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.
  Top
WilhelmSvenselius
User



Location:

Joined on:
26-Oct-2006 13:01:12
Posted:
10 posts
# Posted on: 16-Jan-2007 08:55:28.  
SQL Server 2005 Compact Edition went RTM in december 2006! Cool

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


  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
# Posted on: 16-Jan-2007 11:06:51.  
Yes I saw that Regular Smiley. I'll add support for that in v2.1 (scheduled for beta in late Q1 2007 (end of march, early april)
Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Rushmore
User



Location:
Germany
Joined on:
27-Jan-2005 15:22:06
Posted:
125 posts
# Posted on: 24-Feb-2007 13:24:07.  
I am looking forward to it Cool

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


LLBLGen Pro v4.0 Final (April 6th, 2013)
SQL Server 2005/2008/2012
Visual Foxpro 9 DBC
SQL Server Compact Edition
Sybase 12.01.3867
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
# 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
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Rushmore
User



Location:
Germany
Joined on:
27-Jan-2005 15:22:06
Posted:
125 posts
# 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




LLBLGen Pro v4.0 Final (April 6th, 2013)
SQL Server 2005/2008/2012
Visual Foxpro 9 DBC
SQL Server Compact Edition
Sybase 12.01.3867
 
Top
cjarman66
User



Location:
Australia
Joined on:
19-Nov-2006 12:45:01
Posted:
22 posts
# 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?
Yarm  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
# 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
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
cako
User



Location:

Joined on:
11-Jan-2007 23:18:52
Posted:
16 posts
# 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.
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
# 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
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
rboarman
User



Location:
United States
Joined on:
01-Feb-2005 18:27:43
Posted:
83 posts
# 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
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37803 posts
# 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
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.