Haven't tested it yet, is SQL Server 2005 Everywhere Edition going to be supported by LLBL 2.0 version? I don't know if it's completely compatible with the SQL Server driver.

Everywhere is IMHO SqlMobile with an execution engine running on win32 desktop, so you've to use the CF.NET to target it, if I have understood it correctly.

You don't need the compact framework.

I have created a few sample apps that use Sql Server Everywhere - the CF is nowhere in sight.

I think then, it is quite feasbile to create a template that targets Sql Server Everywhere on the full framework. The version I have been playing with is in the System.Data.SqlServerCe namespace, which I believe is the same as Sql Server Mobile (aka Sql Server CE).

Looking at CSharpCFCETemplateSet.config, it might just be a case of swapping over the CF specific stuff to the full framework? Is this right Frans?

andrewrevell wrote:

You don't need the compact framework.

I have created a few sample apps that use Sql Server Everywhere - the CF is nowhere in sight.

That's also not what I wanted to suggest, sorry if it looked that way. What I wanted to illustrate was that SqlServer everywhere is based on sqlmobile and llblgen pro only supports sqlmobile on the handheld not on the desktop.

I think then, it is quite feasbile to create a template that targets Sql Server Everywhere on the full framework. The version I have been playing with is in the System.Data.SqlServerCe namespace, which I believe is the same as Sql Server Mobile (aka Sql Server CE).

Looking at CSharpCFCETemplateSet.config, it might just be a case of swapping over the CF specific stuff to the full framework? Is this right Frans?

That's not the problem, you should be able to compile CF generated code on normal .NET (you use the same compiler anyway). The thing is the DQE. That one is compiled against the CF.NET corlib and .net libs, and you should recompile that sourcecode against the normal .NET libs.

OK, got it. Thanks.

Can I request you build in support for Sql Server Everywhere when RTM arrives, or even before... ? From what you have said it sounds like a simple reshuffle and recompile on your part.

I believe Sql Server Everywhere is going to be pick up with vigour. So I think it makes business sense to make "full" support a semi-high priority. Give you have already done all the hard work supporting Sql Server Mobile! This is especially true since Sql/e has no stored procs - so ORM is almost mandatory to keep applications maintainable.

In the mean time, I will give a recomplation of the DQE a go myself.

It was my impression that SqlEverywhere isn't released as a final product yet ?

We're currently working to get v2 out the door this weekend, so no things are altered/added, only bugs are fixed. After release we'll add updated drivers/DQE's for mysql 5 and when oracle releases their odp.net 2 stuff, also for oracle. As you said, it's pretty simple for us to support sqleverywhere I think, except one thing: the schema reading logic still needs a full db. But first things first

Andre, I am trying to use SQL/Mobile/Ev for desktop app on win32. Did you have any luck with that or not? Any details will be appreciated?

andrewrevell wrote:

You don't need the compact framework.

I have created a few sample apps that use Sql Server Everywhere - the CF is nowhere in sight.

I think then, it is quite feasbile to create a template that targets Sql Server Everywhere on the full framework. The version I have been playing with is in the System.Data.SqlServerCe namespace, which I believe is the same as Sql Server Mobile (aka Sql Server CE).

Looking at CSharpCFCETemplateSet.config, it might just be a case of swapping over the CF specific stuff to the full framework? Is this right Frans?

+1 for SQL Everywhere support!

Thanks-

-EAB