hello, i am rewriting a system using .NET 2005 & MySql. the old system needed to handle concurrency, and we did it by executing "LOCK TABLES ..." and "UNLOCK TABLES" statements directly onto the data adapters. this time we chose to use llbl gen for persistance, but i need to execute LOCK tables and unlock tables statements for some operations, but i don't know how to do this. thanks for your cooperation.

As long as you are using MySQL 4.x or later then you can use transactions which will do exactly what you need. There is documentation for how to use transactions with LLBLGen in the included manual.