Code Generation Template - Active Columns

[Sambathraj]

Hi,

Within my database scheme all of the tables are having active columns. I want to modify the code the generation template such that always the Get calls returns me active rows.



I have to do it today like <Entity>.Where(n=>n.Active == true). I would like to avoid repeating such code in the middle tier / UI. Please let me know if there is a way to do this.



Sambath

[Jan Blessenohl]

Hi Sambath,

My proposal is that you add a partial class to your generated context class and add Active* entry points:



public partial class MyContext

{

    public IQueryable<Entity> ActiveEntities { get { return this.GetAll<Entity>().Where(x=>x.Active == true);}}

}



In your code you can now use context.ActiveEntities.Where().OrderBy()...



Regards,

Jan Blessenohl
Telerik