Entity Framework 6 - Knowledge Base (KB)

Razor Syntax gives errors in View before compiling (No intellisense)

I was going through the list of NuGet Packages and I was updating everything things like bootstrap, jQuery, etc. but while I was doing that, I unthinkingly updated ...Microsoft.Owin... and another package (might have been EF or something else) and it was ...

Cannot insert the value NULL into column 'Discriminator', table '...AspNetUsers'; column does not allow nulls. INSERT fails

Entity Framework 6, MVC5, ASP Identity 2.0. ...I'm new to Entity framework and ASP Identity. I've created database with Code First approach, following these instructions: ...http://dotnetcodr.com/2014/07/10/introduction-to-entityframework-6-part-1-the-bas...

ASP.NET Identity + Entity Framework + SQLite to share

For our project needs, I created my own ASP.NET Identity 2.0 Provider with SQLite database, and Entity Framework used in MVC 5.2 application. It's methods are all async. All of the problems with the connection to SQLite DB are resolved (I saw many questio...

Web API using Entity Framework to query by multiple columns

Using EF6, I'm creating a Web API project. When I add a Controller, the EntityKey is the default column queried ("Id"), which works fine. I want to add additional columns to query within the same table via the API, which I'm unable to get to work....For e...

Autofac: How do you register a generic with multiple type arguments? Registering IGenRepo<T, TKey> with EFGenRepo<T, TKey>

I am trying to build a generic repo and use autofac for testing. I have the following interface:...public interface IGenRepo<T, TKey> where T : class { IQueryable<T> Items { get; } T find(TKey pk); RepoResult delete(TKey pk); RepoResult cr...

What is the right type to store geolocation data about the user? Can I store accuracy in DbGeography?

I got ...LoginViewModel... consisting of some double which define user location in the world:...public class LoginViewModel { [Required] [EmailAddress] [Display(Name = "Email")] public string Email { get; set; } [Required] [DataTy...

EF how to update entity containing the List of entities

I have a class Device as follows....public class Device { public string id { get; set; } public string name { get; set; } public List<Instructions> Instructions { get; set; } } ...Now I have a view which has sections related to device and prov...

Multiple login entities and Multiple level access permission in ASP.NET MVC-5

I'm building a system where have 4 level login, there is 4 Entities involved....System owner...Distributor...Agent...Subagent...System owner can create distributor login, distributor create agent login and agent create subagent login....I have created 4 p...

Why the postman is returning a "Non-static method requires a target."

I have a Save method in my SavesController (Web Api controller). When I tested it with postman it returned this.... { "message": "An error has occurred.", "exceptionMessage": "Non-static method requires a target.", "exceptionType": "System.Reflection.T...

Entity framework- EF Code First Select foreign key

Model:...public class Address { [Key] public long AddressId { get; set; } public string Street { get; set; } public string Town { get; set; } public string State { get; set; } public string Country { get; set; } } public class ...

Why is EF saying my model has changed when it has not?

I keep getting the following error:...System.InvalidOperationException: The model backing the 'McContext' context has changed since the database was created. Consider using Code First Migrations to update the database (...http://go.microsoft.com/fwl...