I wonder if I am misunderstanding a core concept of LLBLGen....

I have three databases that I need to connect to. One of them is the primary target of all the work, while two other are used for read only lookup data. Depending on a config file setting I either need to connect to a MySQL db for lookups OR I may need to connect to a SQL Server DB for a couple of lookups.

I had configured my primary db for SQL Server. Everything worked fine. I added MySQL to the Catalogs in order to get the first lookups and thats where things went sideways.

So here are my questions:

1. When I try to validate this setup, the MySQL entities complain that is doesn't have a mapping to a target element with the SQL Server driver. What do I need to do there. As I said, I just want to connect conditionally and read data into an collection or TypedList for lookups.

2. While I was able to add the MySQL db to the catalogs, I have no clue how to add second SQL Server catalog. Are there instructions for that?

3. Is there a better way to accommodate this scenario

Thanks Thomas

etechpartner wrote:

I wonder if I am misunderstanding a core concept of LLBLGen....

Hi Thomas. What LLBLGen version and build nr are you using? (http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7721)

etechpartner wrote:

1. When I try to validate this setup, the MySQL entities complain that is doesn't have a mapping to a target element with the SQL Server driver. What do I need to do there. As I said, I just want to connect conditionally and read data into an collection or TypedList for lookups.

Click Project-> and then Automap unmmaped entities.

etechpartner wrote:

1. While I was able to add the MySQL db to the catalogs, I have no clue how to add second SQL Server catalog. Are there instructions for that?

When you refresh the SQLServer node, you can select additional catalogs in the refresh wizard.

etechpartner wrote:

1. Is there a better way to accommodate this scenario

If databases are not tightly dependent on each other, then I would create separate projects. Will you really benefit from the fact that all catalogs are in the same project? If the asnwer is no, then you could separate the LLBLGen projects.

Thank you ! With that in mind, I will create separate projects. For all I care they can have both entities and db access in sep projects. No problem for the app.