public void ExecuteNonQueryTestWithNullParameterList() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = null; int retVal = objDataAccess.ExecuteNonQuery(_validDmlCommandText, CommandType.Text, dal); Assert.IsTrue(retVal > 0); }
public void ExecuteDataTableTestWithEmptyParameterList() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); DataTable retVal = objDataAccess.ExecuteDataTable(_validCommandText, CommandType.Text, dal); Assert.IsTrue(retVal != null); }
public void ExecuteDataReaderTestWithNullParameterList() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = null; using (DbDataReader retVal = objDataAccess.ExecuteDataReader(_validCommandText, CommandType.Text, dal)) { Assert.IsTrue(retVal != null); } }
static void Main(string[] args) { try { string _connectionString = "Data Source=TEST-PC;Initial Catalog=kantarPractice;Integrated Security=False;User ID=sa;Password=pa$$word;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _connectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); dal.Add(new DalParameter() { ParameterName = "@cityid", ParameterDirection = ParameterDirection.Input, ParameterType = SqlDbType.Int, ParameterValue = 2 }); //string[] tableNames = new string[] { "", "", "", "", "", "" }; //DataSet obj = objDataAccess.ExecuteDataSet("[usp_GetCitiesWithParameter]", tableNames); //Console.WriteLine( ); using (DbDataReader reader = objDataAccess.ExecuteDataReader("[usp_GetCitiesWithParameter]", CommandType.StoredProcedure, dal)) { if (reader.HasRows) { while (reader.Read()) { Console.WriteLine("{0}", reader.GetString(0)); } } } using (DbDataReader reader = objDataAccess.ExecuteDataReader("[usp_GetCitiesWithParameter]", CommandType.StoredProcedure, dal)) { if (reader.HasRows) { while (reader.Read()) { Console.WriteLine("{0}", reader.GetString(0)); } } } } catch (Exception ex) { Console.WriteLine(ex.GetBaseException()); } Console.ReadKey(true); }
public void ExecuteDataTableExecuteDataReaderTestWithInvalidParameterList() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); dal.Add(new DalParameter() { ParameterName = "", ParameterDirection = ParameterDirection.Input }); DataTable retVal = objDataAccess.ExecuteDataTable(_validCommandTextWithParameter, CommandType.Text, dal); Assert.IsTrue(retVal != null); }
public void ExecuteDataTableTestWithValidTableName() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); //without Parameter value dal.Add(new DalParameter() { ParameterName = "@p1", ParameterValue = 2, ParameterDirection = ParameterDirection.Input }); string tableName = "CityData"; DataTable retVal = objDataAccess.ExecuteDataTable(_validCommandTextWithParameter, CommandType.StoredProcedure, dal, tableName); Assert.IsTrue(retVal.TableName == "CityData"); }
public void ExecuteNonQueryTestWithInvalidParameterDirection() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); //without Parameter value dal.Add(new DalParameter() { ParameterName = "@p1", ParameterValue = "Country222", ParameterDirection = ParameterDirection.ReturnValue }); int retVal = objDataAccess.ExecuteNonQuery(_validDmlCommandTextWithParameter, CommandType.Text, dal); Assert.IsTrue(retVal == -1); }
public void ExecuteScalerTestWithoutInputParameterValue() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); //without Parameter value dal.Add(new DalParameter() { ParameterName = "@p1", ParameterDirection = ParameterDirection.Input }); object retVal = objDataAccess.ExecuteScaler(_validCommandTextWithParameter, CommandType.Text, dal); Assert.IsTrue(retVal != null); }
public void ExecuteDataSetTestWithInValidTableNamesList() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); //without Parameter value dal.Add(new DalParameter() { ParameterName = "@p1", ParameterValue = 2, ParameterDirection = ParameterDirection.Input }); string[] tableNames = new string[] { "CityData", "sdasdas", "dasdasd", "dsadsad" }; DataSet retVal = objDataAccess.ExecuteDataSet(_validCommandTextWithParameter, CommandType.StoredProcedure, dal, tableNames); Assert.IsTrue(retVal.Tables[0].TableName == "CityData"); }
public void ExecuteDataSetTestWithNullTableNames() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); //without Parameter value dal.Add(new DalParameter() { ParameterName = "@p1", ParameterValue = 2, ParameterDirection = ParameterDirection.Input }); string[] tableNames = null; DataSet retVal = objDataAccess.ExecuteDataSet(_validCommandTextWithParameter, CommandType.Text, dal, tableNames); Assert.IsTrue(retVal.Tables[0].TableName == "Table"); }
public void ExecuteNonQueryTestWithWithValidParameterType() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); //without Parameter value dal.Add(new DalParameter() { ParameterName = "@p1", ParameterValue = "Country1", ParameterDirection = ParameterDirection.Input, ParameterType = SqlDbType.VarChar }); int retVal = objDataAccess.ExecuteNonQuery(_validDmlCommandTextWithParameter, CommandType.StoredProcedure, dal); Assert.IsTrue(retVal > 0); }
public void ExecuteDataSetTestWithInvalidParameterDirectionOutput() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); //without Parameter value dal.Add(new DalParameter() { ParameterName = "@p1", ParameterValue = 2, ParameterDirection = ParameterDirection.Output }); DataSet retVal = objDataAccess.ExecuteDataSet(_validCommandTextWithParameter, CommandType.StoredProcedure, dal); Assert.IsTrue(retVal != null); }
public void ExecuteDataReaderTestWithInvalidParameterDirection() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); //without Parameter value dal.Add(new DalParameter() { ParameterName = "@p1", ParameterValue = 2, ParameterDirection = ParameterDirection.ReturnValue }); using (DbDataReader retVal = objDataAccess.ExecuteDataReader(_validCommandTextWithParameter, CommandType.Text, dal)) { Assert.IsTrue(retVal == null); } }
public void ExecuteDataReaderTestWithValidParameter() { FactoryDataAccess objFactory = new FactoryDataAccess(Provider.Sql, _validConnectionString); IDataAccess objDataAccess = objFactory.GetDataAccess(); DalParameterList dal = new DalParameterList(); //without Parameter value dal.Add(new DalParameter() { ParameterName = "@p1", ParameterValue = "2; select * from city", ParameterDirection = ParameterDirection.Input, ParameterType = SqlDbType.VarChar }); using (DbDataReader retVal = objDataAccess.ExecuteDataReader(_validCommandTextWithParameter, CommandType.Text, dal)) { Assert.IsTrue(retVal != null); } }