public void GetEntitysTest() { string _sql = "SELECT [CustomerID],[CompanyName],[ContactName],[ContactTitle],[Address],[City],[Region],[PostalCode],[Country],[Phone],[Fax] FROM [Customers]"; //IDataReader _reader = sqlHelper.ExecuteReader(_sql, null); //IEnumerable<Customers> _customers = _reader.GetEntitys<Customers>(); IEnumerable <Customers> _customers = sqlHelper.ExecuteReader <Customers>(_sql, null); Assert.IsNotNull(_customers); }
public void ExecuteReaderTest() { ExecuteNonQueryTest(); string _sql = "select * from dbo.Person where PName=@pname"; IDataReader _reader = SqlHelper.ExecuteReader(_sql, new DbParameter[1] { new SqlParameter("@pname", "YanZhiwei") }); Assert.IsTrue(_reader.Read()); }
public void ToDataTableTest() { SqlServerDataOperator _sqlHelper = new SqlServerDataOperator(@"server=YANZHIWEI-PC\SQLEXPRESS;database=AdventureWorks2014;uid=sa;pwd=sasa;"); string _sql = @"SELECT [AddressID] ,[AddressLine1] ,[AddressLine2] ,[City] ,[StateProvinceID] ,[PostalCode] ,[rowguid] ,[ModifiedDate] FROM [Person].[Address]"; List <Address> _result = _sqlHelper.ExecuteReader <Address>(_sql, null); DataTable _actual = GeneralMapper.ToDataTable <Address>(_result); Assert.IsTrue(_actual.Rows.Count > 0); }
/// <summary> /// 根据角色名称模糊查询 /// </summary> /// <typeparam name="T">泛型</typeparam> /// <param name="name">角色名称</param> /// <returns></returns> /// 时间:2015-11-26 11:37 /// 备注: public List <T> FuzzySearchRolesByName <T>(string name) where T : Role, new() { string _sql = "select [R_Code],[R_Name],[R_Sort],[R_Visible] from Roles where r_visible=1 and R_Name like @name"; SqlParameter[] _paramter = new SqlParameter[1]; _paramter[0] = new SqlParameter("@name", "%" + name + "%"); using (IDataReader reader = sqlHelper.ExecuteReader(_sql, _paramter)) { List <T> _roles = new List <T>(); while (reader.Read()) { T _singleRole = new T(); _singleRole.Code = reader.GetValue <string>("R_Code", string.Empty); _singleRole.Name = reader.GetValue <string>("R_Name", string.Empty); _singleRole.Sort = reader.GetValue <int>("R_Sort", 0); _singleRole.Visible = reader.GetValue <bool>("R_Visible", false); _roles.Add(_singleRole); } return(_roles); }; }