Esempio n. 1
0
 public Task <IEnumerable <IndexModel> > GetDescendantsFromSP(int id, string connectionString) =>
 _dp.LoadData <IndexModel, dynamic>("dbo.spGetDescendants", new { id = id }, connectionString);
Esempio n. 2
0
 public Task <IEnumerable <RuleModel> > GetRulesFromSP(string connectionString) =>
 _dp.LoadData <RuleModel, dynamic>("dbo.spGetRules", new { }, connectionString);
Esempio n. 3
0
        public async Task <RuleFunctions> GetFunctionFromSP(int id, string connectionString)
        {
            var results = await _dp.LoadData <RuleFunctions, dynamic>("dbo.spGetWithIdFunctions", new { Id = id }, connectionString);

            return(results.FirstOrDefault());
        }