public void ExecuteNonQuery() { string sql = "DECLARE @FizzBuzz VARCHAR(MAX) = @Fizz"; var dict = new Dictionary<string, object> {{"@Fizz", 1}}; // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { conn.Open(); conn.ExecuteNonQuery(sql, dict.ToDbParameters(conn)); } }
public void ToDbParameters() { const string sql = @"SELECT 1 WHERE @Fizz = 1 AND @Buzz = 2"; var dict = new Dictionary <string, object>(); dict.Add("@Fizz", 1); dict.Add("@Buzz", 2); // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { using (DbCommand command = conn.CreateCommand()) { command.CommandText = sql; command.Parameters.AddRange(dict.ToDbParameters(command)); conn.Open(); object result = command.ExecuteScalar(); // UnitTest Assert.AreEqual(1, result); } } using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { using (SqlCommand command = conn.CreateCommand()) { command.CommandText = sql; command.Parameters.AddRange(dict.ToDbParameters(conn)); conn.Open(); object result = command.ExecuteScalar(); // UnitTest Assert.AreEqual(1, result); } } }
public void ToDbParameters() { const string sql = @"SELECT 1 WHERE @Fizz = 1 AND @Buzz = 2"; var dict = new Dictionary<string, object>(); dict.Add("@Fizz", 1); dict.Add("@Buzz", 2); // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { using (DbCommand command = conn.CreateCommand()) { command.CommandText = sql; command.Parameters.AddRange(dict.ToDbParameters(command)); conn.Open(); object result = command.ExecuteScalar(); // UnitTest Assert.AreEqual(1, result); } } using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { using (SqlCommand command = conn.CreateCommand()) { command.CommandText = sql; command.Parameters.AddRange(dict.ToDbParameters(conn)); conn.Open(); object result = command.ExecuteScalar(); // UnitTest Assert.AreEqual(1, result); } } }
public void ExecuteNonQuery() { string sql = "DECLARE @FizzBuzz VARCHAR(MAX) = @Fizz"; var dict = new Dictionary <string, object> { { "@Fizz", 1 } }; // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { conn.Open(); conn.ExecuteNonQuery(sql, dict.ToDbParameters(conn)); } }
/// <summary> /// Execute the specified sql using the specified parameters /// </summary> /// <param name="sql"></param> /// <param name="parameters"></param> /// <returns></returns> public IEnumerable <dynamic> Query(string sql, Dictionary <string, object> parameters) { try { Database db = Database; IEnumerable <DbParameter> dbParameters = parameters.ToDbParameters(db); return(Database.GetDataTable(sql, System.Data.CommandType.Text, dbParameters.ToArray()).ToDynamicList()); } catch (Exception ex) { ExceptionArbiter.Catch(this, ex); } return(new List <dynamic>()); }
public void ExecuteScalar() { const string sql = @"SELECT 1 As IntColumn WHERE @Fizz = 1"; var dict = new Dictionary<string, object> {{"@Fizz", 1}}; // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { conn.Open(); object result = conn.ExecuteScalar(sql, dict.ToDbParameters(conn)); // UnitTest Assert.AreEqual(1, result); } }
public void ExecuteExpandoObject() { string sql = "SELECT 1 AS IntColumn, 'FizzBuzz' AS StringColumn WHERE @Fizz = 1"; var dict = new Dictionary<string, object> {{"@Fizz", 1}}; // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { conn.Open(); dynamic entity = conn.ExecuteExpandoObject(sql, dict.ToDbParameters(conn)); // Unit Test Assert.AreEqual(1, entity.IntColumn); Assert.AreEqual("FizzBuzz", entity.StringColumn); } }
public void ExecuteScalar() { const string sql = @"SELECT 1 As IntColumn WHERE @Fizz = 1"; var dict = new Dictionary <string, object> { { "@Fizz", 1 } }; // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { conn.Open(); object result = conn.ExecuteScalar(sql, dict.ToDbParameters(conn)); // UnitTest Assert.AreEqual(1, result); } }
public void ExecuteExpandoObjects() { string sql = "SELECT 1 AS IntColumn, 'FizzBuzz' AS StringColumn UNION SELECT 2, 'BuzzBuzz' WHERE @Fizz = 1"; var dict = new Dictionary<string, object> {{"@Fizz", 1}}; // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { conn.Open(); List<dynamic> list = conn.ExecuteExpandoObjects(sql, dict.ToDbParameters(conn)).ToList(); // Unit Test Assert.AreEqual(1, list[0].IntColumn); Assert.AreEqual("FizzBuzz", list[0].StringColumn); Assert.AreEqual(2, list[1].IntColumn); Assert.AreEqual("BuzzBuzz", list[1].StringColumn); } }
public void ExecuteExpandoObject() { string sql = "SELECT 1 AS IntColumn, 'FizzBuzz' AS StringColumn WHERE @Fizz = 1"; var dict = new Dictionary <string, object> { { "@Fizz", 1 } }; // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { conn.Open(); dynamic entity = conn.ExecuteExpandoObject(sql, dict.ToDbParameters(conn)); // Unit Test Assert.AreEqual(1, entity.IntColumn); Assert.AreEqual("FizzBuzz", entity.StringColumn); } }
public void ExecuteExpandoObjects() { string sql = "SELECT 1 AS IntColumn, 'FizzBuzz' AS StringColumn UNION SELECT 2, 'BuzzBuzz' WHERE @Fizz = 1"; var dict = new Dictionary <string, object> { { "@Fizz", 1 } }; // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { conn.Open(); List <dynamic> list = conn.ExecuteExpandoObjects(sql, dict.ToDbParameters(conn)).ToList(); // Unit Test Assert.AreEqual(1, list[0].IntColumn); Assert.AreEqual("FizzBuzz", list[0].StringColumn); Assert.AreEqual(2, list[1].IntColumn); Assert.AreEqual("BuzzBuzz", list[1].StringColumn); } }
public void ExecuteReader() { string sql = "SELECT 1 AS IntColumn, 'FizzBuzz' AS StringColumn WHERE @Fizz = 1"; var dict = new Dictionary<string, object> {{"@Fizz", 1}}; // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { conn.Open(); using (IDataReader reader = conn.ExecuteReader(sql, dict.ToDbParameters(conn))) { reader.Read(); object result1 = reader[0]; object result2 = reader[1]; // Unit Test Assert.AreEqual(1, result1); Assert.AreEqual("FizzBuzz", result2); } } }
public void ExecuteReader() { string sql = "SELECT 1 AS IntColumn, 'FizzBuzz' AS StringColumn WHERE @Fizz = 1"; var dict = new Dictionary <string, object> { { "@Fizz", 1 } }; // Examples using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString)) { conn.Open(); using (IDataReader reader = conn.ExecuteReader(sql, dict.ToDbParameters(conn))) { reader.Read(); object result1 = reader[0]; object result2 = reader[1]; // Unit Test Assert.AreEqual(1, result1); Assert.AreEqual("FizzBuzz", result2); } } }
public static void ExecuteSql(this string sql, Database db, Dictionary <string, object> parameters) { db.ExecuteSql(sql, System.Data.CommandType.Text, parameters.ToDbParameters(db).ToArray()); }
public IEnumerable <dynamic> Query(string sqlQuery, Dictionary <string, object> dictDbParameters, string typeName = null) { DbParameter[] dbParameters = dictDbParameters.ToDbParameters(this).ToArray(); return(Query(sqlQuery, dbParameters, typeName)); }
public virtual DataTable GetDataTable(string sqlStatement, Dictionary <string, object> parameters) { return(GetDataTable(sqlStatement, parameters.ToDbParameters(this).ToArray())); }
public virtual DataRow GetFirstRow(string sqlStatement, Dictionary <string, object> dbParameters) { return(GetFirstRow(sqlStatement, dbParameters.ToDbParameters(this).ToArray())); }
public IEnumerable <T> Query <T>(string sqlQuery, Dictionary <string, object> dbParameters) { return(Query <T>(sqlQuery, dbParameters.ToDbParameters(this).ToArray())); }