C# (CSharp) Utilities.SQL.SQLHelper.ExecuteScalar 예제들

예제 #1

        public void MBDBug()
        {
            string ConnectionString = string.Format("Data Source=localhost;Initial Catalog=Master;Integrated Security=SSPI;Pooling=false");
            string CommandString    = "SELECT database_id FROM Master.sys.Databases WHERE name=@Name";

            using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper(CommandString, CommandType.Text, ConnectionString))
            {
                Utilities.SQL.MicroORM.Parameter <string> Parameter = new Utilities.SQL.MicroORM.Parameter <string>("@Name", DbType.String, "TestDatabase", ParameterDirection.Input, "@");
                Helper.AddParameter(Parameter);
                int DbID = Helper.ExecuteScalar <int>();
                Assert.True(DbID > 0);
            }
            Assert.True(Utilities.SQL.SQLServer.SQLServer.DoesDatabaseExist("TestDatabase", ConnectionString));
            Assert.False(Utilities.SQL.SQLServer.SQLServer.DoesDatabaseExist(null, ConnectionString));
        }

예제 #2

파일: SQLHelper.cs 프로젝트: rgshare/Craig-s-Utility-Library

 public void MBDBug()
 {
     string ConnectionString = string.Format("Data Source=localhost;Initial Catalog=Master;Integrated Security=SSPI;Pooling=false");
     string CommandString = "SELECT database_id FROM Master.sys.Databases WHERE name=@Name";
     using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper(CommandString, CommandType.Text, ConnectionString))
     {
         Utilities.SQL.MicroORM.Parameter<string> Parameter = new Utilities.SQL.MicroORM.Parameter<string>("@Name", DbType.String, "TestDatabase", ParameterDirection.Input, "@");
         Helper.AddParameter(Parameter);
         int DbID = Helper.ExecuteScalar<int>();
         Assert.True(DbID > 0);
     }
     Assert.True(Utilities.SQL.SQLServer.SQLServer.DoesDatabaseExist("TestDatabase", ConnectionString));
     Assert.False(Utilities.SQL.SQLServer.SQLServer.DoesDatabaseExist(null, ConnectionString));
 }