I am planning to use llblgen for a mobile application based on .NET CF 2.0. I am facing some design challenges due to the performance of the mobile device. It seems to me that llblgen will make a huge impact on the performance. So I am looking for some sort of combination of llblgen and the lightweight sqlceresultset. Does anyone have expierience with using llblgen with the compact framework? what would you people recommend for designing the datalayer in a mobile project? resultsets or llblgen? and how can I keep llbgen as lightweight as possible? thanks!

Anything is slow on windows mobile, especially .NET apps. You can gain some performance if you use the sqlce interface directly with live cursors, which aren't supported by llblgen pro. So llblgen pro generates SQL which is interpreted by the sqlce engine, and it's not the fastest to do so...

So yes, it's possible to use our code on a handheld, but it's not hte fastest code out there. If you want that, you need to write code which uses the low-level sqlce interface directly.

Thanks for your reply. how about datasets vs llblgen? (performance-wise that is) And for low level database cursors, do you mean the sql ce resultset by that? Or do you mean through a native API with unmanaged code or P/Invoke?

MarkB wrote:

Thanks for your reply. how about datasets vs llblgen? (performance-wise that is)

As datasets are untyped buckets of object[] array containing datatables, the fetch speed of llblgen pro is a little behind fetching plain datasets. However, you then can't work with entities, you don't have hierarchical saves and auto-sql generation nor prefetch paths for efficient fetching of graphs.

And for low level database cursors, do you mean the sql ce resultset by that? Or do you mean through a native API with unmanaged code or P/Invoke?

The sql ce resultset indeed (or what's it called... ) which allows you to browse through the records of a table without overhead. The .net version is a tiny wrapper around the native code one, so it's pretty fast.

I have created a wireless application that runs nicely on Windows Mobile 5.0 and relies on SQL Server 2008 merge replication for synchronization to the remote server. It works pretty well, but I am thinking of enabling parts of the application to interact real time against the remote database. I'd like to think that simply changing my database connection string to connect to the remote database server would be all that's required to obtain the same CRUD functionality against the remote server. I tried a quick test by changing the connection string, and I tried to log into the application. If it worked correctly, a query would have been made against the remote server. Unfortunately, it did not let me log in and furthermore, using SQL Profiler, it did not seem to even make a request. Any feedback would be appreciated. Thanks.

Same question has been asked here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14216