SQL Server 2005 and ADO.Net has released the dependancy class for data concurrency verification. How do we achieve this in LLBLGenPro?

And what class might that be? It would be nice if you would be a tiny bit more specific .

The new class called SqlDependency is available in ADO.Net 2 and it is supported only in SQL server 2005.

MRamesh wrote:

The new class called SqlDependency is available in ADO.Net 2 and it is supported only in SQL server 2005.

Aha. Ok, you can use this today. At least in adapter you can. In for example the OnFetchEntityCollection() method (there are others for other actions as well) of the DataAccessAdapter class you can obtain the actual query and the IDbCommand object. Create a subclass of DataAccessadapter and override OnFetchEntityCollection() and obtain the command by consulting the passed in query object which contains the command, then create your SqlDependency object of it.

Thanks for your update. How can I do it in selfservicing Sql server component?

MRamesh wrote:

Thanks for your update. How can I do it in selfservicing Sql server component?

That's a little tricky, though it's possible. (not tested, but it should work). Derive a class from the entitycollection class you need dependency for, like CustomerCollection. Derive a class from the DAO class of the entity of the entitycollection class, here CustomerDAO. Override CreateDAOInstance in CustomerCollection to create an instance of your derived customerdao instance. in CustomerDAO override ExecuteMultiRowRetrievalQuery and create your SqlDependency there from the Command in the passed in IRetrievalQuery. Then pass everything on to the base method.