Entity Framework Core Tutorial - Knowledge Base (KB)
60 results for: in tag: mysql
ASP.NET 5 / MVC 6 with MySQL database
I have plans to build an MVC 6 website which will be hosted on Linux, and I am currently in the initial testing phase to see how the new ASP.NET 5 (vNext) and MVC 6 work and whether I can deploy everything on Linux. ...My website must make use of a databa...
asked by Nick Thissen
What happened to System.Data.Entity.DbConfiguration class in EF7
I am trying to add the MySQL Connector/Net provider for EF7: using one of the following. But ...System.Data.Entity... does not have a class ...DbConfiguration... in EF7. Has this class been moved or am I expected to do something different to add the MyS...
asked by grldsndrs
ASP.NET Core Identity with ClearDB MySql
I am trying to establish User Identity in my ASP.NET Core 1 Application, which hosted in Azure. Also, I have got an ClearDB MySQL DataBase....And I cannot find a right way to connect my application to the MySQL db. There are some pages (...one..., ...two....
asked by Alex
dotnet core on Ubuntu Linux using asp.net MVC and EF MySQL error NU1001: cannot restore MySql.Data.EntityFrameworkCore
I've built a simple, flat dotnet core MVC app that I'd like to see running on Linux. It uses EF to pull a few records from a mysql table and display them in a view. It all builds and runs on my host (Win10) but will not in the Ubuntu VM I've spun up to te...
asked by Tsar Bomba
How to include related entities in an Entity Framework Core 1.0.1 raw query?
Setup:...ASP .NET Core 1 Web API...MySQL Server Community Edition 5.7...Entity Framework Core 1.0.1 with Pomelo MySQL driver (3 separate contexts, 3 separate databases)....Contexts: MainContext (maindb), Module1Context (module1db), Module2Context (module2...
asked by Alin Florin
All data is not inserted in MySql instance using Entity Framework Core
Using a MariaDb instance database (fork of MySql) and using Entity Framework Core, give me a problem I've never experienced before, hence this post as I have no idea what is going on, and hoping that some of you guys might've experienced this before....Pr...
asked by Detilium
Issue with Many-To-Many relationships in MySql
I am using EF Core with MySQL using ...SapientGuardian's EFCore library... and I am trying to create a table with many-to-many relationship using the following code; ... public class Personnel { public int Id { get; set; } ...
asked by Platypus Maximus
EF Core MySQL Contains(variable) like operator
I am using ASP.NET Web API Core with EF Core to create a method, which returns JSON format records.... When I use ...contains... for ...like operator (%varible%)..., an error occured with message below:...An exception of type 'MySql.Data.MySqlClient.MySql...
asked by Code Man
Using MySQL provider for .net core application generates MissingMethodException
I'm new to .net core, so problem may be simple, but I don't know, how to solve it......Trying to use MySQL database with my code gives me an ...MissingMethodException... on select....public List<Message> GetMessages(String chatHash, Int32 count = 0) { ...
asked by Nick
Better way to implement a row version with EF Core and MySQL?
If I use the following field in my model:...[DatabaseGenerated(DatabaseGeneratedOption.Computed)] [Timestamp] public DateTime RowVersion { get; set; } ...and then define the column as...`RowVersion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CU...
asked by Jeff
EF Core - Table '*.__EFMigrationsHistory' doesn't exist
I want to stress out that this is .NET Core and the threads about EF 6.0 does not apply to this problem...I created my DbContext and added it in DI, however when I do ...dotnet ef database update -v... it does not want to create the migrations table ...__...
asked by stan
Entity Framework Core Linq Where NULL does not work
I am using Entity Framework Core and Linq to write a query to get all entries where the EndDate property on my object is NULL. However, EF does not convert the query to the proper SQL to filter out the objects with an EndDate that is not NULL. I am usin...
asked by big_water
NotImplemented Exceptions using MySQL Provider in ASP.NET Core With EF Core
I am building an ASP.NET Core 1.1.0 application that needs to access an existing MySQL database using Entity Framework Core, which I'm building in Visual Studio 2015 with all the latest updates. I started using the "official" MySQL provider (MySql.Data.En...
asked by RiverRunner
How to store 'blob' type in MySQL with Entity Framework Core using byte[]?
I have code first model that looks like this: ...public class Document { [Key] public int DocumentId {get;set;} [Required] public byte[] Blob {get; set;} } ...I want that to map to blob data type in MySQL but I keep getting varbinary(2...
asked by Hristo Kolev
The entity type 'IdentityUser' is part of a hierarchy, but does not have a discriminator value configured
I'm trying to migrate a .NET Core 1.1 MVC-application using EntityFrameworkCore (1.0.1) from SQLite (..."Microsoft.EntityFrameworkCore.Sqlite": "1.0.1"...) to MySQL (..."MySql.Data.EntityFrameworkCore": "7.0.6-IR31"...)....My context is extending ...Ident...
asked by Jeppe
missing stored procs when scaffolding mysql using EF Core on .net core and pomelo drivers
I'm trying to use Scaffolding in EFCore against a mysql database where the generated code will be run on Linux CentOS (NetCoreApp framework). I'm developing on Windows with VS2015 Update3. ...Tables are successfully reverse engineered, but stored proced...
asked by LarryJ
Skip and Take not working with MySQL EntityFrameworkCore
I am trying to paginate ...Products... from MySQL db, but if I use ...Skip()... or ...Take()... it returns an empty Json array as my web api response like this...[] ...But extension methods such as ...FirstOrDefault()..., ...Where()... ... works fine. Her...
asked by abdul
Can't cast Int to Decimal with EF Core?
I am trying to solve an issue I have with pulling large ints (22+ digits) into ASP.Net with Entity Framework Core from a MySQL database....EF Core does not support ...BigInteger... and the suggestions I received where to use ...decimal... instead. However...
asked by Douglas Gaskell
EntityFramework Core Database.EnsureCreated doesn't create database
I create a project with dotnetcore and entity framework core. I use MySql database and I added dependency to ...SapientGuardian.EntityFrameworkCore.MySql... version ...7.1.19.......I created a ...SeedData... class where initialize my database:...public cl...
asked by erikscandola
Connection error on UserManager CreateAsync
I am getting the following error when trying to create a new user using the UserManager CreateAsync method. I am using an unmodified IdentityUser and IdentityRole. I have a few DBSets which populate with data from the database, so reading is not an issue,...
asked by Devin Rawlek
Page 1 of 3