public void TestSimpleSelectList() { MockSimpleObject obj = new MockSimpleObject(); //obj.DBOrderBy = new Dictionary<string, bool>(); //obj.DBOrderBy.Add("Status", true); obj.Status = 1; //obj.CommonName = "cn10%"; OleDbConnection con = new OleDbConnection(connectString); con.Open(); SimpleDAO.SimpleDAO <MockSimpleObject> dao = new SimpleDAO.SimpleDAO <MockSimpleObject>(); dao.NullStringValue = null; dao.NullIntValue = 0; List <MockSimpleObject> list = dao.SimpleSelectList(con, obj); con.Close(); Assert.IsTrue(list.Count == 3); }
public void TestSimpleSelectList() { MockSimpleObject obj = new MockSimpleObject(); //obj.DBOrderBy = new Dictionary<string, bool>(); //obj.DBOrderBy.Add("Status", true); obj.Status = 1; //obj.CommonName = "cn10%"; //SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=JPAS;User ID=jpas_user;Password=jpas2007"); OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dev\SimpleDAO\SimpleDAOTest\SimpleDAO.mdb"); con.Open(); SimpleDAO.SimpleDAO <MockSimpleObject> dao = new SimpleDAO.SimpleDAO <MockSimpleObject>(); dao.NullStringValue = null; dao.NullIntValue = 0; List <MockSimpleObject> list = dao.SimpleSelectList(con, obj); con.Close(); Assert.IsTrue(list.Count == 3); }
public void TestSimpleSelectList() { MockSimpleObject obj = new MockSimpleObject(); //obj.DBOrderBy = new Dictionary<string, bool>(); //obj.DBOrderBy.Add("Status", true); obj.Status = 1; //obj.CommonName = "cn10%"; OleDbConnection con = new OleDbConnection(connectString); con.Open(); SimpleDAO.SimpleDAO<MockSimpleObject> dao = new SimpleDAO.SimpleDAO<MockSimpleObject>(); dao.NullStringValue = null; dao.NullIntValue = 0; List<MockSimpleObject> list = dao.SimpleSelectList(con, obj); con.Close(); Assert.IsTrue(list.Count == 3); }
public void TestSimpleSelectList() { MockSimpleObject obj = new MockSimpleObject(); //obj.DBOrderBy = new Dictionary<string, bool>(); //obj.DBOrderBy.Add("Status", true); obj.Status = 1; //obj.CommonName = "cn10%"; //SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=JPAS;User ID=jpas_user;Password=jpas2007"); OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dev\SimpleDAO\SimpleDAOTest\SimpleDAO.mdb"); con.Open(); SimpleDAO.SimpleDAO<MockSimpleObject> dao = new SimpleDAO.SimpleDAO<MockSimpleObject>(); dao.NullStringValue = null; dao.NullIntValue = 0; List<MockSimpleObject> list = dao.SimpleSelectList(con, obj); con.Close(); Assert.IsTrue(list.Count == 3); }