Crud.Entity 3.0.0.6

CrudEntityCSharp

Nuget Crud.Entity

Db config

public class XDataDb : CrudDB

{

    public XDataDb()
    
        :base(
        
             connectionstring:"...",
             
             dbCommand:typeof(DbCommand),     //NpgsqlCommand,MySqlDbCommand  ... IDbCommand
             
             dbConnection:typeof(DBConnection), //NpgsqlConnection,MySqlConnection ...  IDbConnection
             
             DbType:Util.DatabaseName.Postgresql  //  Postgresql,Mssql,Mysql,Oracle (Not test only Postgresql)
             
             ){}
             
    public TModel TModel => new TModel();
    
    public TModel1 TModel1 => new TModel1();
    
    public TModel2 TModel2 => new TModel2();
    
    public TModel3 TModel3=> new TModel3();
    
    public TModel4 TModel4 => new TModel4();
    
    ...
    
}

Model

public class TModel :CrudModel

{ .... }

Facade

public class TModel : ICrudFacade

{ .... }

AddParam

Where query parameter

Condittion  AND, OR, AND NOT

Param  Equal, Great,   Small,  GreatEqual,   SmallEqual,    NotEqual

Use

XDataDb db= new XDataDb();

db.TModel

.Join<TModel, TModel2>(true)  in both cases true or false TModel inner join ?TModel2:TModel on TModel2.TModelID=TModel.id 

.Join<TModel1, TModel2>()

.Join<TModel2, TModel3>()

...

.AddParam("TModel2.TModelID", TModel.Id,true) //add param last parameter of (true) for start 

.AddParam("TModel2.TModel1ID", TModel1.Id)

.AddSelect("field")

.AddSelect("TModel1.field1","newName")  //field1 as newName

.AddSelect("TModel1.field2","newName2")  //field1 as newName

..

.ListFacade<TModelFacade>(typeof(TModel).Name);

// .ListObsFacade<TModelFacade>(typeof(TModel).Name);  //observableCollection

db.TModel

 .Add(TModel); 
 // AddFacade(TModelFacade);

#db.TModel

 .InsertParam("name", TModel.name)
 
 .InsertParam("sur", TModel.sur)
 
 .Add()

db.TModel

.Edit(TModel); 

// EditFacade(TModelFacade);

db.TModel

 .AddParam("id", TModel.Id,true)

.UpdateParam("name", TModel.name)

.UpdateParam("sur", TModel.sur)

.Update()

db.TModel

.AddParam("name", TModel.name,true)

.AddParam("sur", TModel.sur)

.Remove();

db.TModel

 .ListWithSql<T>(query,param1,param2...) ;
   

Transaction

db.TModel

.Add(TModel,true)

.Add(TModel2,true)

.EndTrans();

//.EndTransAsync

db.TModel

.Add(TModels,true) // TModels-> List<TModel>

.Add(TModel2,true)

.EndTrans();

 //.EndTransAsync
    
 
    
    

db.TModel

   .AddSql(TModel,query, true, param1,param2...)
   

param1,param2...

    insert delete ..
    
    select * from tmodel where id=@id and name=@name

V3.0.0.5

Fix Limit
Fix AddSelect


 db.TModel
 
   .AddSelect(true, params params string[] columnames)
   
   .AddSelect(columname, asColumn)
   ...
   
 db.TModel
   
   .Add(true, TModel,TModel1...)  //only Transaction
   .EndTrans()
   
   

V3.0.0.6

Fix Join Randomize

Fix List

Fix Param Randomize

Note

Don't Accept Null value for Add,Update..

maybe I may be wrong in my description.

Test purpose and development