string connectionString = "Data Source=.;Initial Catalog=testdb;User ID=sa;Password=bouyei;";

IAdoProvider adoProvider = AdoProvider.CreateProvider(connectionString);

var rt = adoProvider.Query(new Parameter()
{
	CommandText = "select * from MemUser"
});

//删除
var del= adoProvider.Delete<user>(x => x.name == "hello");

//插入
  var insert = adoProvider.Insert<user>(new user() {
             name="bouyei",
             age=30
        });

//查询
var users = adoProvider.Query<user>(x => 1 == 1);

foreach (DataRow dr in rt.Result.Rows)
{
	Console.WriteLine(string.Join(",", dr.ItemArray));
}

IOrmProvider ormProvider = OrmProvider.CreateProvider(ProviderType.SqlServer, connectionString);

var items= ormProvider.Query<DbEntity.User>("select * from MemUser").ToList();

foreach(var item in items)
{
	Console.WriteLine(item.uName);
}
Console.ReadKey();

        //查询
       var sql= sqlProvider.Select<User>()
            .From<User>().Where<User>(x => x.Id == 1).SqlString;

        //修改
        sql = sqlProvider.Update<User>()
            .Set<User>(new User() { Name = "bouyei", UserName = "hkj" })
            .Where<User>(x => x.Id == 1).SqlString;

        //删除
        sql = sqlProvider.Delete()
            .From<User>().Where<User>(x => x.Name == "bouyei").SqlString;

        //插入
        sql = sqlProvider.Insert<User>()
            .Values<User>(new User[] {
            new User() { Name ="hello", UserName="aileenyin.com" }
            ,new User() { Name="bouyei",UserName="jiang"} }).SqlString;