Jango.Dapper 1.0.1

how to use Jango.Dapper?

1. using Jango.Dapper;

2.  startUp.cs

     a.for Mysql
       
       services.AddJangoDapper(DbType.MySql);

     b.for Sqlserver
        
        services.AddJangoDapper(DbType.Sqlserver)

3. for insert /multiInsert,update/MultiUpdate,query for list/query for paged list/query with fields,delete
    a. insert
        using (var conn = new MySql.Data.MySqlClient.MySqlConnection(""))
                {
                    //insert
                    conn.Insert<T>(t, "", "");
                    conn.Insert<T>(t, "", "tableName");
                    conn.Insert<T>(t, "schemaName", "tableName");

                    //multiInsert
                    conn.MultiInsert<T>(new List<T>() { t }, "", "");
                    conn.MultiInsert<T>(new List<T>() { t }, "", "tableName");
                    conn.MultiInsert<T>(new List<T>() { t }, "schemaName", "tableName");

                }
    b.update 
        using (var conn = new MySql.Data.MySqlClient.MySqlConnection(""))
                {
                    //update
                    conn.Update<T>(t,x.Id==1&&x.Name="demo" ,"", "");
                    conn.Update<T>(t, x.Id == 1 && x.Name = "demo", "", "tableName");
                    conn.Update<T>(t, x.Id == 1 && x.Name = "demo", "schemaName", "tableName");

                    //update with fields
                    conn.UpdateWithFields<T>(t, new { Id = 1, Name = "demo1" }, x.Id == 1 && x.Name = "demo", "schemaName", "tableName");
                    //mutiUpdate

                    conn.MultiUpdate<T>(new List<T>() { t }, x.Id == 1 && x.Name = "demo", "schemaName", "tableName");


                    //mutiUpdate with fields
                    conn.MultiUpdateWithFields<T>(new List<T>() { t },, new { Id = 1, Name = "demo1" }, x.Id == 1 && x.Name = "demo", "schemaName", "tableName");
                    
                }
    c. query
        using (var conn = new MySql.Data.MySqlClient.MySqlConnection(""))
                {
                    //query list
                    conn.Query<T>(x.Id == 1 && x.Name = "demo", "schemaName", "tableName");

                    // query paged list
                    conn.QueryPaged<T>(x.Id == 1 && x.Name = "demo", new Pager() { PageIndex = 1, PageSize = 15 }, "schemaName", "tableName");

                    // query list with fields
                    conn.QueryFields<T>(x => new { Id, Name }, x.Id == 1 && x.Name = "demo", "schemaName", "tableName");

                }
    d.delete 
        using (var conn = new MySql.Data.MySqlClient.MySqlConnection(""))
                {
                    conn.Delete<T>(x => x.Id == 1 && x.Name = "demo", "schemaName", "tableName");
                }