public void CheckPersonWithIdGreaterThan2AndLessThan4() { List<IPerson> persons = table.GetTable().Where(p => p.Id > 2 && p.Id < 4).ToList(); using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString)) { conn.Open(); using (IDataReader dr = conn.GetDataReader("Select Id,Name From PERSON Where Id > @from and Id < @to", new { from = 2, to = 4 })) { int i = 0; while (dr.Read()) { Assert.AreEqual(dr.ConvertToInt32("Id"), persons[i].Id); Assert.AreEqual(dr.ConvertToString("Name"), persons[i].Name); ++i; } Assert.AreEqual(persons.Count, i); } } }
public void CheckPersonWithIdOne() { IPerson person = table.GetTable().First(p => p.Id == 1); using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString)) { conn.Open(); using (IDataReader dr = conn.GetDataReader("Select Id,Name From PERSON Where Id = @Id", new { Id = 1 })) { if (dr.Read()) { Assert.AreEqual(dr.ConvertToInt32("Id"), person.Id); Assert.AreEqual(dr.ConvertToString("Name"), person.Name); } } } }
public void CheckPersonWithNameLikeM() { List<IPerson> persons = table.GetTable().Where(p => p.Name.StartsWith("M", StringComparison.InvariantCultureIgnoreCase)).ToList(); using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString)) { conn.Open(); using (IDataReader dr = conn.GetDataReader("Select Id,Name From PERSON Where Name like 'M%'")) { int i = 0; while (dr.Read()) { Assert.AreEqual(dr.ConvertToInt32("Id"), persons[i].Id); Assert.AreEqual(dr.ConvertToString("Name"), persons[i].Name); ++i; } Assert.AreEqual(persons.Count, i); } } }