System.Data.Common.DbCommand.ExecuteScalarToOrDefault(int)

Here are the examples of the csharp api class System.Data.Common.DbCommand.ExecuteScalarToOrDefault(int) taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

1 Example 7

1. Example

Project: Z.ExtensionMethods
Source File: DbCommand.ExecuteScalarToOrDefault.cs
[TestMethod]
        public void ExecuteScalarToOrDefault()
        {
            const string sql = @"SELECT 'FizzBuzz' As StringColumn";

            // Examples
            using (var conn = new SqlConnection(My.Config.ConnectionString.UnitTest.ConnectionString))
            {
                using (SqlCommand @this = conn.CreateCommand())
                {
                    conn.Open();
                    @this.CommandText = sql;
                    var result1 = @this.ExecuteScalarToOrDefault<string>();
                    var result2 = @this.ExecuteScalarToOrDefault<int>();
                    int result3 = @this.ExecuteScalarToOrDefault(-1);
                    int result4 = @this.ExecuteScalarToOrDefault(command => -2);

                    // UnitTest
                    Assert.AreEqual("FizzBuzz", result1);
                    Assert.AreEqual(0, result2);
                    Assert.AreEqual(-1, result3);
                    Assert.AreEqual(-2, result4);
                }
            }
        }