LiteDac and TDatasetProvider
Posted: Fri 02 Nov 2012 15:31
Hi,
I am developing a application which has to run online and offline. For online I use SQL Server on a remote server. For offline I use SQLite.
For SQL Server I use a TClientDataset with a TDatasetProvider linked to a TADODataset. ADO retrieves the data from the server. Note that I only use this mechanism to download datasets FROM the server. Inserting, Updating and Deleting is taken care of by code I wrote which generates the required SQL statements.
My question is if I can use the same mechanism with LiteDac's TLiteQuery ? This means the logic of my application would not change, and I can link my TDatasetProvider to a TLiteQuery component. Would this work ?
Thank you.
I am developing a application which has to run online and offline. For online I use SQL Server on a remote server. For offline I use SQLite.
For SQL Server I use a TClientDataset with a TDatasetProvider linked to a TADODataset. ADO retrieves the data from the server. Note that I only use this mechanism to download datasets FROM the server. Inserting, Updating and Deleting is taken care of by code I wrote which generates the required SQL statements.
My question is if I can use the same mechanism with LiteDac's TLiteQuery ? This means the logic of my application would not change, and I can link my TDatasetProvider to a TLiteQuery component. Would this work ?
Thank you.