Two database in one model

Two database in one model

Postby imre.dudas » Mon 16 Jun 2014 05:58

Hi Everybody,

I have a large project in which i separate the developing and runtime databases from each other. I solved this by creating Linq model to the developing database and when programming, I set the Connection string as follows:

#if DEBUG
ConnectionString = GetConnectionString("DeveloperConnectionString");
#else
ConnectionString = GetConnectionString("ReleaseConnectionString");
#endif


Of course, both ConnectionString is included in my app.config file.

By this, the connection string is set whether I interprete my projects in Debug mode, or in something else.

At time of interpretation, Connection string gets its proper value.

But the program always gets the value from the developing database, and never from the runtime database.

Finally, I got to the point why it is so: The connection determines only the fact, by which database I sign in to the SQL server, but if I modify or query another database from there, that is valid, and most likely it is determined in the model this way.

How could I change things so that I couldn't make separate models for runtime and for developing versions?

Best regards,

Imre
imre.dudas
 
Posts: 18
Joined: Thu 11 Mar 2010 20:36

Re: Two database in one model

Postby MariiaI » Tue 17 Jun 2014 05:25

Probably, the DataContext constructors (that are generated in the *.Designer.cs file) use the name of the initial connection string. For example, the code should be like this:
Code: Select all
public partial class TestMDataContext : Devart.Data.Linq.DataContext
    {
        ...
        #if DEBUG
                static string ConnectionString = "DeveloperConnectionString";
        #else
                static string ConnectionString = "ReleaseConnectionString";
        #endif

        public TestMDataContext() :
            base(GetConnectionString(ConnectionString), mappingSource)
        {
            OnCreated();
        }

        public TestMDataContext(MappingSource mappingSource) :
            base(GetConnectionString(ConnectionString), mappingSource)
        {
            OnCreated();
        }
...}

We are sending you two sample projects with the necessary DDL/DML scripts to the e-mail address you have provided in your forum profile. Please check that the letter is not blocked by your mail filter. Please test it. If this doesn't help, please modify it so that the issue could be reproduced and send it back to us, or send us your sample project.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to LinqConnect (LINQ to SQL support)