DapperExTest/UnitTest1.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Dapper;
using System.Collections.Generic;
using DapperEx;
using System.Configuration;
using System.Data.Common;

namespace DapperExTest
{
    [TestClass]
    public class UnitTest1
    {
        public string connectionName = "strSql";
        public DbBase CreateDbBase()
        {
            return new DbBase(connectionName);
        }
        [TestMethod]
        public void Connection()
        {
            var providerName = "System.Data.SqlClient";
            var connStr = ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;
            if (!string.IsNullOrEmpty(ConfigurationManager.ConnectionStrings[connectionName].ProviderName))
                providerName = ConfigurationManager.ConnectionStrings[connectionName].ProviderName;

            var dbProvider = DbProviderFactories.GetFactory(providerName);
            var conn = dbProvider.CreateConnection();
            conn.ConnectionString = connStr;
            conn.Open();
            Console.WriteLine("状态：" + conn.State.ToString());
        }
        [TestMethod]
        public void Insert()//插入一条数据
        {
            var model = new Account()
            {
                Id = "1",
                Name = "张三1",
                Password = "123456",
                Email = "123@qq.com",
                CreateTime = DateTime.Now,
                Age = 15
            };
            using (var db = CreateDbBase())
            {
                var result = db.Insert<Account>(model);
                if (result)
                    Console.WriteLine("添加成功");
                else
                    Console.WriteLine("添加失败");
            }
        }
        [TestMethod]
        public void Insert2()//插入一条数据
        {
            for (int i = 2; i < 10; i++)
            {
                var model = new Account()
                {