Hello, Is it possible to use LLBLGenPro with Local Database Cache mechanism introduced in .NET 3.5. If not, is there some other way that we could use to enable offline work with LLBLGen pro.
Regards, Dalibor
"Local Database Cache"
I'm not familier with the term, would you please elaborate in more details.
Hello,
Here are some links: http://msdn.microsoft.com/en-us/library/bb726002.aspx http://msdn.microsoft.com/en-us/library/bb882690.aspx http://blogs.microsoft.co.il/blogs/bursteg/archive/2008/05/12/sync-services-for-ado-net-with-sql-server-2008-change-tracking.aspx
In short its a SQL CE which acts as a cache for the real database.
That's not supported by LLBLGen pro out of the box.
But LLBLgen pro supports SQLCe desktop. Please check:SqlServer specific: SqlServer CE Desktop support
You ill have to switch the connection string at runtime to retrieve data from the local database rather than the main one.
Also you'll have to manage data synchronization.