EF 简单实验

1.概要

EF 简单实验

2.代码

2.1 config

<connectionStrings>
		<add name="DbConnStr" connectionString="Data Source=localhost;port=3306;Initial Catalog=dbmy;user id=root;password=123456;" providerName="MySql.Data.MySqlClient" />
	</connectionStrings>

2.2

using MySql.Data.EntityFramework;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace WindowsFormsApp1
{
    // [DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))]
    [DbConfigurationType(typeof(MySqlEFConfiguration))]
    class DBContentMy: DbContext
    {
        public DBContentMy():base("DbConnStr") {
            Database.SetInitializer<DBContentMy>(null);
        }
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);
        }


        public DbSet<Tb1> Tb1s { set; get; }
    }
}

2.3

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        // 插入对象
        private void button1_Click(object sender, EventArgs e)
        {
            using (DBContentMy db = new DBContentMy()) {
                Tb1 tb1 = new Tb1();
                tb1.v1 = 1;
                db.Tb1s.Add(tb1);
                db.SaveChanges();
            }
        }

        //用sql插入
        private void button2_Click(object sender, EventArgs e)
        {
            using (DBContentMy db = new DBContentMy())
            {
                db.Database.ExecuteSqlCommand("insert into tb1(v1) values(2)");
            }
        }

        // 用sql查询
        private void button3_Click(object sender, EventArgs e)
        {
            using (DBContentMy db = new DBContentMy())
            {
                var c = db.Database.SqlQuery<int>("select count(*) from tb1");
                foreach (int a in c) {
                    Console.WriteLine(a);
                }
            }
        }
    }
}

2.4

CREATE TABLE `tb1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `v1` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

3.运行结果

3.1

 3.2