System.Data.Common.DbConnection.ExecuteScalar(string, System.Data.Common.DbParameter[])

Here are the examples of the csharp api class System.Data.Common.DbConnection.ExecuteScalar(string, System.Data.Common.DbParameter[]) taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

1 Example 7

1. Example

View license
[TestMethod]
        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);
            }
        }