Hi, we want that our web based product supports multiple databases so can we use LLBGEN in .net for this purposes ? If yes then what architecture we need to implement so we can switch any database as per our customer need and how much effort it will require?

You mean that you need to sell your product to run on any of these databases, right?

This is perfectly supported by LBLGen Pro. You will need to have one LLBLGen Project per database type, all generating code according to the Adapter template. Then if the schemas are identical, then you can use any of the generated DBGeneric project for the entity classes/objects. And then you can use the different DBSpecific projects to target each of the databases.

Anyway this has been discussed before thoroughly in the forums. And if you have the schemas ready, this won't take no more than 20 minutes to implement.

(Edit) More details here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=5579 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14176