Wednesday, 10 April 2013

function with parameter of sql execute in datacontext

public IList<TrialBalance> GetGroupBalances(Guid? companyId, Guid? financialYearId, DateTime fromDate, DateTime toDate)
        {
           return _DatabaseContext.Database.SqlQuery<TrialBalance>(@"Select * from Accounts.udf_Account_Group_Details('" + companyId + "', '" + financialYearId + "','" + fromDate + "','" + toDate + "')").AsQueryable().ToList();
        }

No comments:

Post a Comment