SqlSugar

    SqlServerHelper myDB = new SqlServerHelper();

            #region myDB.DB 基于实体对象操作

            var list = myDB.DB.Queryable<Demo>().ToList();//查询所有

            // 插入语句 
            Demo newDemo = new Demo { Name = "test" };
            int newId = myDB.DB.Insertable(newDemo).ExecuteReturnIdentity();//插入语句，返回ID

            //// 更新语句
            Demo data2 = new Demo { Id = 1, Name = "newname" };
            var rowMod = myDB.DB.Updateable(data2).ExecuteCommand(); //安装主键id更新数据

            //// 删除语句
            var rowDel = myDB.DB.Deleteable<Demo>(1).ExecuteCommand();

            #endregion

            #region myDB.Ado. 基于Ado，执行sql语句

            //
            var demo = myDB.Ado.GetDataTable("select * from demo");

            //执行 新增语句 返回 自增id
            var row_Id = myDB.Ado.GetLong("INSERT INTO dbo.Demo ( Name) VALUES ('test_sqlserver') ; SELECT SCOPE_IDENTITY();");

            //执行修改sql语句操作   返回影响行数
            var rowMod2 = myDB.Ado.ExecuteCommand("UPDATE Demo SET Name = @Name WHERE Id < @Id", new { Name = "[改]test", Id = row_Id });

            //执行删除sql语句操作   返回影响行数
            var rowDel2 = myDB.Ado.ExecuteCommand("DELETE Demo WHERE Id < @Id", new { Name = "[改]test", Id = row_Id });

            #endregion