ASP.NET Core API: How to use MySQL

asp.net asp.net-core-2.0 asp.net-core-webapi asp.net-web-api entity-framework-core

Question

Here is my connection string: 

Server=sql145.main-hosting.eu:3306;Database=u230450666_aspt;User=u230450666_aspt;Password=111111;

That I use like this: 

services.AddDbContext<UsersContext>(options => options.UseSqlServer(Configuration.GetConnectionString("DatabaseUrl")));

And I can't connect to my database, I got this error:

System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

System.ComponentModel.Win32Exception (0x80004005): The parameter is incorrect

at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)

Thus I tried with HeidiSQL, as follows:

enter image description here

and it worked.

So I must miss some settings with UseSqlServer..

(I'm following this tutorial)

1
2
4/1/2018 9:12:45 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

System.Data.SqlClient.SqlException is for Microsoft SQL Server - but it will NOT work for MySQL - those are two completely different database systems!

You need to use the appropriate, MySQL-specific classes!

Check out this page: https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core.html

There is a MySQL connector for Entity Framework Core, and you can use this by specifying:

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
   .....         
   optionsBuilder.UseMySQL("Server=sql145.main-hosting.eu:3306;Database=u230450666_aspt;User=u230450666_aspt;Password=111111;");
}
3
3/31/2018 3:46:28 PM

Popular Answer

As @marc_s pointed out, you can override OnConfiguring to use MySQL.
Or if you wish a cleaner & more "pattern-friendly" way: check this out

Alexandre Daubricourt

Related Questions

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.EntityFrameworkCore), but have the same problem with the Pomelo prvider (Pomelo.EntityFrameworkCo...
asp.net-core c# entity-framework-core mysql
asked by RiverRunner

asp.net core/EF-Core mysql update database error

I am absolutely new to asp.net core development. I am trying to create a simple asp.net core web api with a single model and mysql to store the model data and then I would want to retrieve it as REST API perhaps using Swagger....My current set up looks like following: ...Books.cs:...using Microsoft.EntityFrameworkCore; using MySQL.Data.EntityFramew...
asp.net-core asp.net-core-mvc entity-framework-core
asked by Thinker

Reconfigure dependencies when Integration testing ASP.NET Core Web API and EF Core

I'm following this tutorial...Integration Testing with Entity Framework Core and SQL Server...My code looks like this...Integration Test Class...public class ControllerRequestsShould : IDisposable { private readonly TestServer _server; private readonly HttpClient _client; private readonly YourContext _context; public ControllerRequ...
asp.net-core c# entity-framework-core integration-testing xunit2
asked by GreenyMcDuff

Errors using Pomelo MySQL EF provider with ASP.NET Core 2.0 Preview

I am using Pomelo 1.1.2 on ASP.NET Core 2.0 Preview, along with EF 2.0 Preview. With their demo code, I get the following exception every time I call "UseMySql":...System.TypeLoadException occurred HResult=0x80131522 Message=Method 'Clone' in type 'Microsoft.EntityFrameworkCore.Internal.MySqlOptionsExtension' from assembly 'Pomelo.EntityFramewo...
asp.net-core asp.net-core-2.0 entity-framework-core mysql pomelo
asked by Ron Penton

Entity Framework Core with ASP.NET Core Web API and SQL Server (+ Xamarin.Forms)

I have a Xamarin.Forms project with a user registration page, which sends a serialized Customer object via HttpClient to an ASP.NET Core Web API Controller's [HttpPost] method. The body of this [HttpPost] method is supposed to add a row to a Customers table in an SQL Server database hosted in Azure, via Entity Framework Core....This is the Registra...
asp.net-core azure entity-framework-core sql-server xamarin.forms
asked by LeanManager

ASP.NET Core 2.0 web api Entity Framework Core - looking for a more elegant solution

I am working on a web api project on ASP.NET Core 2.0 with Entity Framework Core connecting to a postgres database....The following PUT method works without at problem but I feel I might be misunderstanding the use of the update method and I also feel like there should be a more elegant solution to update an existing object in a manner holding with...
asp.net-web-api c# entity-framework-core npgsql rest
asked by Matt Luccas Phaure Jensen

Force inherited classes in ASP.NET Core Entity Framework Core to dedicated MySQL table

Having a model ...Thread... that should countain all attributes of another model called ...Post... I use inheritance:...class Post { public int Id{get;set;} public string Title{get;set;} // ... } class Thread: Post { public int ForumId{get;set;} // ... } ...EF Core put both in a single table and adds the column ...Discriminator....
asp.net-core c# ef-code-first entity-framework-core mysql
asked by Lion

Call MySql stored procedure which take 2 parameters from asp.net core 2.2 web API controller

What is a proper way of calling a stored procedure with 2 parameters and getting result back which contain 10 columns and 403 records....Below is the code I have written....try { string startDate = procedureResource.StartDate.ToString("yyyy-MM-dd") + " 00:00:00"; string endDate = procedureResource.EndDate.ToString("yyyy-MM-dd") + " 23:59:5...
asp.net-core-webapi c# entity-framework-core mysql stored-procedures
asked by Awais Khan

Best Practice For Loading Related Data in Asp.net Core Web API And EF.Core

When to use Eager Loading or Explcit Loading in Asp.net Core Web API with EF Core? for example i wrote this query with Eager Loading.is this wrong? is should i Explicit Loading instead of Eager Loading?... var plants = await _context.Plant.Include(plant => plant.Areas) .ThenInclude(areas => areas.Un...
asp.net-core asp.net-core-webapi entity-framework-core
asked by Rohullah Rajaee Rad

How can I process a generic query through ASP.NET Core Web API using Entity Framework?

Ok, I realize this is a loaded question, so bear with me while I break it down....I have a local network with a database, and then I have multiple remote locations with their own databases with similar schemas. The only way to query the databases at the remote locations is to go through a (somewhat) isolated machine. So, I can't directly connect t...
asp.net-core-webapi c# entity-framework-core
asked by eerick

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow