Ask yourself a single question: What are you going to test? You mentioned FakeContext and Mocking the context – why to use both? Those are just different ways to do the same – provide test only implementation of the context. There is one more bigger problem – faking or mocking context or set has only … Read more
IQueryable: Query isn’t executed until you really iterate over the items, maybe by doing a .ToList() or a foreach. Which means you still can add filters, like a Where(). Extends IEnumerable IEnumerable: Forward-only list of items. You can’t get at “item 4” without passing items 0-3. Read-only list, you can’t add to it or remove … Read more
From a point of view of clean creation of POCO entities, there is no difference between the two generators. Both generators produce the same entities, however, ADO.NET POCO Entity Generator is based on ObjectContext‘s API, whereas ADO.NET DbContext Generator is based on DbContext‘s API. DbContext’s API has a few very nice new features (Local, Query … Read more
The problem is that your application probably still holds some connection to the database (or another application holds connection as well). Database cannot be deleted where there is any other opened connection. The first problem can be probably solved by turning connection pooling off (add Pooling=false to your connection string) or clear the pool before … Read more
Unfortunately you can’t define it as unique key in code first because EF doesn’t support unique keys at all (it is hopefully planned for next major release). What you can do is to create custom database intializer and add unique index manually by calling SQL command: public class MyInitializer : CreateDatabaseIfNotExists<MyContext> { protected override void … Read more
It’s not thread safe. Simply create a new instance of DbContext in you thread.
Do you want generic way to check if entity was loaded by context or generic way to query database if entity exists? For the former case use: public bool Exists<T>(T entity) where T: class { return this.Set<T>().Local.Any(e => e == entity); } For the latter case use (it will check loaded entities as well): public … Read more
If you talk about dynamic proxies in EF there are two different types to distinguish: Proxies for lazy loading Proxies for change tracking Usually a change tracking proxy also can serve as a proxy for lazy loading. The reverse is not true. This is because the requirements for change tracking proxies are higher, especially all … Read more
Extension method: public static T GetAttributeFrom<T>(this object instance, string propertyName) where T : Attribute { var attrType = typeof(T); var property = instance.GetType().GetProperty(propertyName); return (T)property .GetCustomAttributes(attrType, false).First(); } Code: var name = player.GetAttributeFrom<DisplayAttribute>(nameof(player.PlayerDescription)).Name; var maxLength = player.GetAttributeFrom<MaxLengthAttribute>(nameof(player.PlayerName)).Length;
The following query will get the count and page results in one trip to the database, but if you check the SQL in LINQPad, you’ll see that it’s not very pretty. I can only imagine what it would look like for a more complex query. var query = ctx.People.Where (p => p.Name.StartsWith(“A”)); var page = … Read more