Here is a revised version of the response: ...Reusing instances using the Unity framework...Use of a ContainerControlledLifetimeManager, sometimes known as a Singleton, is the answer.
I'm aware it's too late....For Unit-Of-Work: It's crucial to keep track of the changes you make when bringing data into and out of a database. You must also replace any deleted objects with new ones that you create....With every modification to your object model, you can alter the database, but this could result in several, extremely brief database...
What you need, in my opinion, is a per-request lifetime manager that limits the number of UnitOfWork instances and DbContext instances you can have active at any given time. You may achieve this using the ...ASP.NET MVC bootstrapper for Unity... in Unity 3 that has a ...PerRequestLifetimeManager.......You could potentially use a PerResolveLifetimeM...
I've finally figured it out: ...here....IQueryable required the following addition:...public class TestDbAsyncEnumerable<T>
: EnumerableQuery<T>, IDbAsyncEnumerable<T>, IQueryable
You should be able to use a LINQ join to query both generic repositories if they expose an IQueryable method:...var items = from c in customerRepository.AsQueryable()
join l in libraryRepository.AsQueryable() on c.SomeProperty equals l.SomeOtherProperty
select new { CustomerName = c.FirstName, LibraryName = l.Name };
...The ...
I don't mind having inquiries like this on SO because I exclusively use SO and have no plans to use any other services....I would strongly advise using your service as...IRepository...
your repository requests, and...IUoW...
. I even enjoy contemplating...IRepository...
EF is more than just a hindrance. Typically, I only utilize a repository when
....
I had to give the key for my KeyValuePair dataset, which was an issue....protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<KeyValuePair>().HasKey(x => x.Key);
base.OnModelCreating(modelBuilder, null);
}
...I appreciate you, ...The author is Robert J. Engdahl.....
