Hi All,

I'm using LLBL v2.6, Adapter mode, LINQ and .NET 3.5.

We are going to implement a group of database independent applications in our company. We are planing to use three main DBMSes for our applications: SQL Server 2000 or higher Oracle 9i or higher MySQL 5 or higher

As far as I know, developing DB independent applications enforces some constraints on DB design and usage of DBMS features. Since you have the experience of working with various DBMSes, could you please tell me what is your recommendations on this topic?

TIA Farzad Badili

My 2 cents:

1- Use the database only for storing data, no logic or code inside the database. (i.e. better not to use SPs or triggers), to avoid the maintenance nightmare. Centralize your logic in the application.

2- Make sure the chema is identical accross all databases.

3- Avoid using any database specific feature which you can't find in the other databases.

Thanks for your answer

Number 1 and 2 are already in my list but my problem is about number 3!

Do you have a list of these constraints? for example: table/column/PK/FK/index name max length, Unsupported data types for column and etc.

Unfortunatly I don't have such list.

You may create the schema on the most probably used database, then you can create an LLBLGen project.

Then you may use DDL SQL templates (available in the download section, Tasks and templates) which in combination with the project converter (available in the download section, Extras) to quickly create a new target database.

Thanks for your support