Dear All,
I am using LINQ with Entities
I am executing same query with different parameter in a for loop. So I decided to Prepare that query as compiled query and then call the compiled query. I did the same in the following manner but there is no difference in time when query
execute first or then after … Please suggest where I gone wrong.
As query was executing in DAL layer. So I create my own DAL class Called ABC.cs
in DAL.
In that First I create global variable for compiled as
public
static Func<datacontext ,
DateTime, string, IQueryable<tmpclass >> compiledQuery;
Then I assigned the compiled veriable in the constructor of DAL class
static ABC()
{
compiledQuery = System.Data.Objects.CompiledQuery.Compile<datacontext,
DateTime, string, IQueryable< tmpclass >>(
(ctx, orderDate, shemecode) => (from dsp1
in ctx.table1 where dsp1.NAVDATE <= orderDate && dsp1.SCHEMECODE == shemecode
orderby dsp1.NAVDATE
descending
select new Quartile_tmp_dt
{ newbasedt= dsp1.NAVDATE }));
}
Then I am invoking
it as
using (DataContext AWEntities =
new Datacontext())
{
AWEntities.Tables1.MergeOption =System.Data.Objects.MergeOption.NoTracking;
AWEntities.Tables1.MergeOption = System.Data.Objects.MergeOption.NoTracking;
foreach (var item
in result)
{
DateTime frdt =
Convert.ToDateTime(frmDate);
var res = compiledQuery.Invoke(AWEntities, frdt, item.SCHEMECODE);
}
}
