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));
            }
        }
Esempio n. 5
0
        /// <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);
            }
        }
Esempio n. 8
0
        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);
            }
        }
Esempio n. 10
0
        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);
            }
        }
Esempio n. 11
0
        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);
                }
            }
        }
Esempio n. 13
0
        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);
                }
            }
        }
Esempio n. 14
0
 public static void ExecuteSql(this string sql, Database db, Dictionary <string, object> parameters)
 {
     db.ExecuteSql(sql, System.Data.CommandType.Text, parameters.ToDbParameters(db).ToArray());
 }
Esempio n. 15
0
 public IEnumerable <dynamic> Query(string sqlQuery, Dictionary <string, object> dictDbParameters, string typeName = null)
 {
     DbParameter[] dbParameters = dictDbParameters.ToDbParameters(this).ToArray();
     return(Query(sqlQuery, dbParameters, typeName));
 }
Esempio n. 16
0
 public virtual DataTable GetDataTable(string sqlStatement, Dictionary <string, object> parameters)
 {
     return(GetDataTable(sqlStatement, parameters.ToDbParameters(this).ToArray()));
 }
Esempio n. 17
0
 public virtual DataRow GetFirstRow(string sqlStatement, Dictionary <string, object> dbParameters)
 {
     return(GetFirstRow(sqlStatement, dbParameters.ToDbParameters(this).ToArray()));
 }
Esempio n. 18
0
 public IEnumerable <T> Query <T>(string sqlQuery, Dictionary <string, object> dbParameters)
 {
     return(Query <T>(sqlQuery, dbParameters.ToDbParameters(this).ToArray()));
 }