Hello,

I got a question about multiple database types.

I have Currently MySQL and SQL Server as active database.

Now what i would like to do is combine those 2 databases in 1 LLBLgen projectfile.

The thing is ... i created 1 projectfile from MySQL database.

All 35 tables are there.

Now in the relational Model data there you can add a second database.

Currently there are no tables in that database.

What i would like is that i create a different table in SQL Server that does not exist in MySQL as table.

Is this supported ?

And when i build the llblgen it gives me error about :

Auto-map 'MySql.Tabelname' onto a new or matching existing target in relational modeldata for database SQL Server.

When you hit the perform button it wil create this table for SQL server.

Now is there a option that it can be turned off ?

Or do i need to create a second llblgen project as solution?

The model is the center of the universe, so the model has to be mapped to all databases in the project. If you add a table to a db which has no mappings, then that's supported, but if you map an entity to table X in SQLServer but not to a table in MySql, this isn't supported. In that case, you indeed have to create two projects. The idea behind this is that if you have 1 entity model and 2 databases, the code resulting from that entity model is used with both databases, so not having a mapping to 1 of the databases makes things break at runtime.