I'm having a little problem with pulling info from two different databases. One is a mySql database, the other is SQL Server.

There is a job numbers table in the mySql database that I need to pull numbers from, but all the info will be added to a timesheet table in sql server. Can anyone give me any good ideas on how I should go about this. Should I build two different dals one for each database? Thanks for the help!!

Since it doesn't sound like the database mirror each other I would do that.

bclubb wrote:

Since it doesn't sound like the database mirror each other I would do that.

is there a way that i can build a relationship between tables that are in the seperate databases though? Lets say there is a job number table in the mysql database but I need to have a one to many relationship with it in my sql databaset table called like a timesheet table.

I'm not sure how i would go about doing this since i'll be using two different dll's , one for each database like suggested above. Thanks for the help!

I don't believe that you can do anything like this using the generated code from LLBLGen.