.NET Core Entity Framework

.net core entity framework (EF Core) table naming convention

Faraj's ...answer... not works on ...ThreeCapitalWords..., result is ...three_capitalwords.......Here is my solution, based on ...this answer...:... /// <summary> /// /// </summary> /// <param name="preserveAcronyms">If true, 'PrepareXXRecord' converted to 'prepare_xx_record', /// otherwise to 'prepare_xxrecord'</param> publi...

.Net Core Entity Framework MySQL - string fields store 255 symbols only

I'm creating an application using .Net Core, Entity Framework and MySQL 5.7, on Windows, using Visual Studio 2015. I've created new simple .net-core project in VS2015 for console application using EF. My data model consists of single type, Article, that has ID (int) and Body(string) fields. When I create database doing:...> dotnet ef migrations add...

.NET Core Entity Framework - Migration path --output-dir

I have successfully created a migration file using .NET Core class library by using command: ...dotnet ef --startup-project ../Project.Web migrations add Init...Because I register my db context in a different layer, (web layer), and have class library, I have to set my startup project to Project.Web....After creating my initial migration it looks s...

.NET Core Entity Framework throws Invalid object name when accessed as entity, but works with SQL

I'm working with Entity Framework Core, v6.2. I'm getting an error...SqlException: Invalid object name 'Cdef.CellDefinition' ...when I try to access the ...DbSet... directly, but using the same ...DbContext... object, I can query the object directly using the ...FromSql... command. ...I've seen other answers saying to modify the conventions to rem...

.NET Core Entity Framework InvalidOperationException

Where is it getting InterfaceID from?...First, it should be clear that it's not coming from the shown "simple" (but apparently incomplete) model....The EF generated SQL clearly indicates that you didn't rename the PK property generated column, also there is no ...Discriminator... column, so it cannot be coming from inheritance. And the chance that ...

How to call stored procedure with table valued parameter from .net core Entity Framework

I have a stored procedure with table valued parameter. I have to call it from Entity framework in .net core....I couldn't find any API on context object....I have tried with ADO.net API's and it worked but now I have to call it from EF in .net core. Stored procedure which I have to call returning result which I have to catch....My sample SP as belo...

How to fix Odata with C# WebAPI .NET Core Entity Framework

I can retrieve all of the data but looks like OData is not working I'm using EFCore Entity Framework Web API. This is my reference for OData ...https://www.youtube.com/watch?v=ZCDWUBOJ5FU...Updated Model below...Return should be ...[ { "name":"FakeHelmet" }, { "name":"OriginalHelmet" }, { "name":"ClassAH...

How to update tables (not recreate them) using .net core entity framework migration

I have connected to an existing SQL database that didn't have any identity, eg no aspNetUser table etc. I have since added these using a custom login class like this...public class UserLogin : IdentityUser { public int LanguageId { get; set; } public string HQ_PRM_Id { get; set; } } ...I then generated a migration to create th...

.NET Core Entity Framework Fluent api error, DateTime properties have text as column type

In my model namespace, I have different model classes. I have ...DateTime... fields in my different classes. When I run ...dotnet ef migrations add InitialCreate ...without problem, it adds a migration and I am able to update the database too....When I looked up my ...initialCommit.Designer.cs..., I saw that all of my ...DateTime... properties hav...

Create nested data from JSON using .net core Entity Framework

I wan't to create a "Group" using http POST request. The User isn't existing, so it should also be created. But the "item" in received by Post is alway null. When I don't post a user or an empty users array, it works....Here is my Model:...public class User { public Guid Id { get; set; } public string Name { get; set; } public virtual G...