Where is the EDMX

AspNet.Identity Custom User and Custom Role should be simple; what am I missing?

Using examples from ...http://www.asp.net/identity... I've gotten this far. The ...RoleManager... works flawlessly and I treat the ...UserManager... the same. I think everything is correct, but I can't seem to new up a ...UserManager... correctly in a controller. What is wrong? At one point, I was successfully getting the ...UserManager... to wo...

Add stored procedure to entity framework model (.edmx) without refreshing existing entities

I have a stored procedure in development environment that I want to add to EF data model (.edmx) and call it in my code through a method wrapper that EF creates. ...Our development environment is not 100% in sync with production one so when I try adding the stored procedure deployed to development environment using "Update Model From Database" menu...

MySQL 5.7: System.Data.StrongTypingException when adding or updating an EDMX model

I try to get the Entity Framework (5 or 6) working with MySQL 5.7 (database first), but adding an Entity Data Model for a (test) database results in the error "Unexpected exception occured when generating the model. StrongTypingException: The value for column 'IsPrimaryKey' in table TableDetails is DBNull.". The table has a primary key by the way:....

I am having trouble creating DB in SQL Server Express with Entity Framework Core 2.0

I am going through the MvcMusicStore tutorial on the www.asp.net website....I am able to use Entity Framework Core 2.0 and migrations to create a DB in localDb. Here is the connection string from that in appsettings.json:..."MvcMovieContext": "Server=(localdb)\\mssqllocaldb;Database=MvcMovieContext-19840e0a-5fb4-409c-9f38-7f2946cd3937;Trusted_Conne...

EntityFramework: how to modify edmx to change format of entity names and properties

I am using the Entity Framework to generate data access code from an old database....The database table names and properties are all named in capitals with ..._... to separate words ie. ...CLIENT..., ...CLIENT_NAME..., ...D_CLIENT_ID... etc....I have written a class to transform these into camel cased strings:...public static class Extensions...

Why am I getting duplicate ID columns when using Table Per Hierarchy in Entity Framework Core?

I am trying to use "table per hierarchy" to model a variety of account types in my database using EF Core (2.1) and I am having a problem where I am getting additional foreign key columns added for the derived types. I have seen ...this... question/answer but I don't think it is the same as my situation....Here are my account classes:...public abst...

DbUpdateException- Duplicate key error is unhanded while i am catching all exceptions

I have the following methods...public async Task Foo() { try { //Do stuff bool inserted = false; int tries=0; while (!inserted && tries<2) { try { inserted = await Bar(); } ...

How to update(by merging) edmx without override the model classes in asp.net mvc

Working from memory at the moment, but the EF classes are always partial so create another partial implementation of the same class, then add the Interface and Metadatatype binding to that....// Entity Framework Model public partial class User { public string Email { get; set; } public string Password { get; set; } } // Your Interface with...

ASP.NET Core Web API & Entity Framework Core; why am I getting this error?

I understand that the serializer in ASP.NET Core may not be able to handle certain responses, but why do I get this error when I don't try to return the object in question?...See the error here: ...https://imgur.com/a/2se9eWB...When I try to affiliated my ...ProjectResourceRequest... with my ...ProjectResourceAssignment..., it writes to the databas...

I am unable to store data into database using Entity Framework Core and Ajax

I have a problem with my code. The problem is I am not getting post data by parameter using ajax....Can anyone fix this? The code is shown below....This is Javascript Ajax code where I am sending data by post method to the controller:...$('#pending').click(function () { SaveTestResult("/Reception/PatientTests/SavePendingTest"); }); function Sa...