dapper使用

c# 数据库orm

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Dapper;
using System.Data;

namespace DapperLearning
{
    /// 

    /// Dapper异步运用
    /// 

    public class AsnycDapperMapper
    {
        private readonly string mysqlConn = @“server=192.168.0.100;database=lc_opensdk;uid=zzw;pwd=zzw@123;charset=‘gbk‘“;
        private readonly string sqlConn = @“user id=zzw;password=zzw@123;initial catalog=FPT_URGER;data source=192.168.0.1001433“;
        /// 

        /// 获取Mysql的连接数据库对象
        /// 

        /// 
        public MySqlConnection OpenMyConnection（）
        {
            MySqlConne

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        583  2017-09-14 09:47  DBLearning\DapperLearning\App.config

     文件       2792  2017-09-14 18:07  DBLearning\DapperLearning\AsnycDapperMapper.cs

     文件     120320  2017-09-14 14:34  DBLearning\DapperLearning\bin\Debug\Dapper.dll

     文件     212480  2017-09-14 14:34  DBLearning\DapperLearning\bin\Debug\Dapper.pdb

     文件      36864  2017-09-14 14:34  DBLearning\DapperLearning\bin\Debug\Dapper.SimpleCRUD.dll

     文件      60928  2017-09-14 14:34  DBLearning\DapperLearning\bin\Debug\Dapper.SimpleCRUD.pdb

     文件      37362  2017-09-14 14:34  DBLearning\DapperLearning\bin\Debug\Dapper.SimpleCRUD.xml

     文件      70918  2017-09-14 14:34  DBLearning\DapperLearning\bin\Debug\Dapper.xml

     文件     128000  2017-09-14 18:07  DBLearning\DapperLearning\bin\Debug\DapperLearning.exe

     文件        583  2017-09-14 09:47  DBLearning\DapperLearning\bin\Debug\DapperLearning.exe.config

     文件     251392  2017-09-14 18:07  DBLearning\DapperLearning\bin\Debug\DapperLearning.pdb

     文件      24224  2017-11-09 15:52  DBLearning\DapperLearning\bin\Debug\DapperLearning.vshost.exe

     文件        583  2017-09-14 09:47  DBLearning\DapperLearning\bin\Debug\DapperLearning.vshost.exe.config

     文件        490  2015-11-13 10:24  DBLearning\DapperLearning\bin\Debug\DapperLearning.vshost.exe.manifest

     文件     424448  2017-09-14 09:47  DBLearning\DapperLearning\bin\Debug\MySql.Data.dll

     文件     660992  2017-09-14 16:46  DBLearning\DapperLearning\bin\Debug\Npgsql.dll

     文件     406875  2017-09-14 16:46  DBLearning\DapperLearning\bin\Debug\Npgsql.xml

     文件     320000  2017-09-14 16:43  DBLearning\DapperLearning\bin\Debug\System.Data.SQLite.dll

     文件     888901  2017-09-14 16:43  DBLearning\DapperLearning\bin\Debug\System.Data.SQLite.xml

     文件      25864  2017-09-14 16:46  DBLearning\DapperLearning\bin\Debug\System.Threading.Tasks.Extensions.dll

     文件      19242  2017-09-14 16:46  DBLearning\DapperLearning\bin\Debug\System.Threading.Tasks.Extensions.xml

     文件    1474048  2017-09-14 16:43  DBLearning\DapperLearning\bin\Debug\x64\SQLite.Interop.dll

     文件    1255936  2017-09-15 13:28  DBLearning\DapperLearning\bin\Debug\x86\SQLite.Interop.dll

     文件       5433  2017-09-14 16:48  DBLearning\DapperLearning\DapperLearning.csproj

     文件       4794  2017-09-14 18:07  DBLearning\DapperLearning\DefaultDapperMapper.cs

     文件       5687  2017-09-14 18:06  DBLearning\DapperLearning\HignerDapperMapper.cs

     文件       1584  2017-11-09 15:52  DBLearning\DapperLearning\obj\Debug\DapperLearning.csproj.FileListAbsolute.txt

     文件     128000  2017-09-14 18:07  DBLearning\DapperLearning\obj\Debug\DapperLearning.exe

     文件     251392  2017-09-14 18:07  DBLearning\DapperLearning\obj\Debug\DapperLearning.pdb

     文件       7370  2017-09-14 16:46  DBLearning\DapperLearning\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

............此处省略149个文件信息