public void CheckPersonWithIdGreaterThan2AndLessThan4() { List<IPerson> mockPersons = table.GetTable().Where(p => p.Id > 2 && p.Id < 4).ToList(); using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString)) { conn.Open(); IList<Person> persons = conn.GetList<Person>("Select Id,Name From PERSON Where Id > @from and Id < @to", new { from = 2, to = 4 }); } }
public ICollection<Rule> GetRules() { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var list = connection.GetList<Rule>(); connection.Close(); return list.ToList(); } }
public IList<Model.Entities.UserModule> GetAllUserModuleByLdapUser(Model.Entities.UserModule userModule) { IEnumerable<UserModule> result = new List<UserModule>(); using (SqlConnection cn = new SqlConnection(ApplicationConfiguration.ConnectionString)) { cn.Open(); var predicateGroup = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List<IPredicate>() }; predicateGroup.Predicates.Add(Predicates.Field<UserModule>(f => f.LdapName, Operator.Eq, userModule.LdapName)); result = cn.GetList<UserModule>(predicateGroup); cn.Close(); } return result.ToList(); }
public void CheckPersonWithNameLikeM() { List<IPerson> mockPersons = table.GetTable().Where(p => p.Name.StartsWith("M")).ToList(); using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString)) { conn.Open(); var persons = conn.GetList<Person>("Select Id,Name From PERSON Where Name like 'M%'"); Assert.AreEqual(mockPersons.Count, persons.Count); for (int i = 0; mockPersons.Count > i; i++) { Assert.AreEqual(mockPersons[i].Id, persons[i].Id); Assert.AreEqual(mockPersons[i].Name, persons[i].Name); } } }
public void NullDOB() { using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString)) { conn.Open(); Assert.DoesNotThrow(() => { conn.GetList<Person>("Select NULL as DateOfBirth From PERSON"); }); } }