How to use MySQL entityframework component to process MySQL PaaS DB

Source: Internet
Author: User

MySQL database on azure is the MySQL cloud databases service launched on the Azure platform, providing users with a fully-managed, fast-deployable, highly available, high-security database service with full MySQL protocol compatibility. Customers can use common MySQL-enabled platforms and technologies for development and integration. This article demonstrates how to use the MySQL EntityFramework component to operate MySQL PaaS DB.

System Environment/Application information

ASP. 2005 Core/mysql EntityFramework Core

Detailed code

In the VS. Net core Environment, the EntityFramework core components are installed, and the code and test results are as follows:

Where the Data1Context.cs file is:

usingMicrosoft.entityframeworkcore;usingMySQL.Data.EntityFrameworkCore.Extensions;namespaceconsoleapp1{/// <summary>    ///The Entity Framework context with a data1 DbSet/// </summary>     Public classData1context:dbcontext { PublicData1context (dbcontextoptions<data1context>options):Base(options) {} PublicDbset<data1> Data1 {Get;Set; } }    /// <summary>    ///Factory class for Employeescontext/// </summary>     Public Static classData1contextfactory { Public StaticData1context Create (stringconnectionString) {            varOptionsbuilder =NewDbcontextoptionsbuilder<data1context>();            Optionsbuilder.usemysql (connectionString); //Ensure database Creation            varContext =NewData1context (optionsbuilder.options); Context.            Database.ensurecreated (); returncontext; }    }    /// <summary>    ///A Basic class for A Employee/// </summary>     Public classData1 { Public intId {Get;Set; }  Public stringName1 {Get;Set; } }}

The Program.cs file is:

usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Threading.Tasks;usingMicrosoft.Extensions.Configuration;namespaceconsoleapp1{ Public classProgram { Public Static voidMain (string[] args) {            varBuilder =NewConfigurationbuilder (). Addjsonfile ("Appsettings.json", Optional:false, Reloadonchange:true); varConfiguration =Builder.            Build (); stringconnectionString = Configuration. GetConnectionString ("sampleconnection"); //Create an employee instance and save the entity to the database            varEntry =NewData1 () {Id =3, Name1 ="xingbing" }; using(varContext =data1contextfactory.create (connectionString)) {context.                ADD (entry); Context.            SaveChanges (); } Console.WriteLine ($"Data1 is saved in the database with ID: {entry. ID}");        Console.readkey (); }    }}

The appsettings.json file is:

{    "ConnectionStrings": {         "  Sampleconnection""server=xxxxxx.mysqldb.chinacloudapi.cn;userid=xxxxxx%yyyyyy ;p Wd=xxxxxxxxx;port=3306;database=xyudb;sslmode=none; "     }}

The project.json file is:

{    "version":"1.0.0-*",    "buildoptions": {        "Debugtype":"Portable",        "Emitentrypoint":true,        "Copytooutput": {        "include":"Appsettings.json"        }    },    "Dependencies": {        "Microsoft.Extensions.Configuration":"1.0.0",        "Microsoft.Extensions.Configuration.Json":"1.0.0",        "Microsoft.entityframeworkcore":"1.0.0",        "MySql.Data.Core":"7.0.4-ir-191",        "MySql.Data.EntityFrameworkCore":"7.0.4-ir-191"    },    "Frameworks": {        "netcoreapp1.0": {            "Dependencies": {                "Microsoft.NETCore.App": {                "type":"Platform",                "version":"1.0.0"                }            },            "Imports": [                "Dnxcore50",                "portable-net452+win81"            ]        }    }}

Project composition

Operation and test results

Component Address

MySql.Data.EntityFrameworkCore 7.0.7-m61

Reference method

MySQL EF Core provider and connector/net 7.0.4 Getting Started tutorial

More wonderful work please click to view

Interested friends are welcome to communicate

A research institute graduate student [email protected]

How to use MySQL entityframework component to process MySQL PaaS DB

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.