DevForce Community Forum : Two Entities and Two DataBase problem

Two Entities and Two DataBase problem : Hi Molinari;Please see code example...

Thu, 03 Feb 2011 11:52:22 -700

Author: DenisK
Subject: 2482
Posted: 03-Feb-2011 at 11:52am

Hi Molinari;

Please see code example below.

[TestMethod]

public void UsingDefaultManager() {

var mgr1 = new NorthwindIBEntityManager();

var mgr2 = new FantasyFootballEntityManager();

var a = mgr1.Employees.FirstOrNullEntity();

var b = mgr2.Clubs.Take(9).ToList();

var default1 = NorthwindIBEntityManager.DefaultManager;

EntityManager.DefaultManager = mgr2;

var default2 = FantasyFootballEntityManager.DefaultManager;

var clubInCache = default2.FindEntities(EntityState.AllButDetached).ToList();

}

The last query finds all entities of type Club in cache. The results are 9 clubs which is correct because the previous query

mgr2.Clubs.Take(9).ToList();

takes 9 Club entities and put them in cache.

Two Entities and Two DataBase problem : Hi Denisk, Ok.. but I need using...

Thu, 03 Feb 2011 11:40:46 -700

Author: Molinari
Subject: 2482
Posted: 03-Feb-2011 at 11:40am

Hi Denisk,

Ok.. but I need using two database..and project has only one EntityManager so when i need to run the query EntitiesFirst() I set in EntityManager after I need execute the query EntitiesSecond() then set new again...

I create one Test .... every time change EntityManader.DefaultManager.... cache is Empty...

if you can post the code...for example..I thank

Two Entities and Two DataBase problem : Hi Molinari;No, you don't...

Thu, 03 Feb 2011 11:11:12 -700

Author: DenisK
Subject: 2482
Posted: 03-Feb-2011 at 11:11am

Hi Molinari;

No, you don't need to set it to new EntitiesSecond() every time. You can set it to any existing EntityManager of type EntitiesSecond and use its cache.

Two Entities and Two DataBase problem : Hi Denisk, Then mean that I can...

Thu, 03 Feb 2011 04:28:04 -700

Author: Molinari
Subject: 2482
Posted: 03-Feb-2011 at 4:28am

Hi Denisk,

Then mean that I can never use the cache on EntitiesSecond. because I need set NEW EntityManager.DefaultManager = new EntitiesSecond();
every time before executing a query ? Or has some way to use this cache?

thanks..

Two Entities and Two DataBase problem : Hi Mollinary;The DefaultManager...

Wed, 02 Feb 2011 15:31:28 -700

Author: DenisK
Subject: 2482
Posted: 02-Feb-2011 at 3:31pm

Hi Mollinary;

The DefaultManager is a static shared property across all EntityManager(s). This means that the following are the same instance.

EntityManager.DefaultManager

EntitiesFirst.DefaultManager

EntitiesSecond.DefaultManager

Which means that before you get the DefaultManager and assign it to a different type, you need to set it to the proper type first as follows:

EntityManager.DefaultManager = new EntitiesSecond();

EntitiesSecond _em2 = EntitiesSecond.DefaultManager;

Hope this helps.

Two Entities and Two DataBase problem : I have two entities and two database......

Wed, 02 Feb 2011 07:38:11 -700

Author: Molinari
Subject: 2482
Posted: 02-Feb-2011 at 7:38am

I have two entities and two database... Consequently.. two EM..

EntitiesFirst _em = new EntitiesFirst();
_em.DefaultQueryStrategy = QueryStrategy.DataSourceOnly;

EntitiesSecond _em2 = new EntitiesSecond();
_em2.DefaultQueryStrategy = QueryStrategy.Normal;

When I use EntitiesFirst.. sucess but when i use EntitiesSecond..

public static void Test()
{
EntitiesSecond _em2 = EntitiesSecond.DefaultManager;

_em2.Employer.Where(c=>c.id == 1)....
}

Show Error...
Type conflict: the DefaultManager is currently of type EntitiesFirst

how to use it properly.

Thanks