vJine.Core

void IDUQ(string db) {
    DataManager dm = new DataManager(db);
    dm.OnTrace += (int ID, string Action, string Table, string Cmd, DbParameterCollection Params) => {
        System.Console.WriteLine("ID:{0},ACTION:{1},TABLE:{2},CMD:{3}", ID, Action, Table, Cmd);

        return null;
    };

           
    dm.Create<BizEntity>(true);
    string sql_create = dm.ToString();
            
    dm.I<BizEntity>(
        new BizEntity() { Name = "Name_1", Number = 1, ENUM = Enum_Type.E01 });
    dm.I<BizEntity>(
        new BizEntity() { Name = "Name_2", Number = 2, ENUM = Enum_Type.E02 });
    string sql_insert = dm.ToString();
            
    CollectionBase<BizEntity> container = new CollectionBase<BizEntity>();
    dm.Q<BizEntity>(container,
        BizEntity._.Name == "Name_1" | BizEntity._.Name == "Name_2");
    string sql_select = dm.ToString();
            
    dm.U<BizEntity>(
        BizEntity._.Name.EQ("Name_11") 
        BizEntity._.Name == "Name_1" );
    string sql_update = dm.ToString();
            
    dm.D<BizEntity>(BizEntity._.Name == "Name_11" | BizEntity._.Name == "Name_2");
    string sql_delete = dm.ToString();
            
    dm.Drop<BizEntity>();
    string sql_drop = dm.ToString();
}