/*
Kooboo is a content management system based on ASP.NET MVC framework. Copyright 2009 Yardi Technology Limited.
This program is free software: you can redistribute it and/or modify it under the terms of the
GNU General Public License version 3 as published by the Free Software Foundation.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program.
If not, see http://www.kooboo.com/gpl3/.
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Common;
namespace Everest.CmsServices.Installation{
public static class DbHelper
{
#region Database
internal static void ExecuteNoQuery(DbProviderFactory dbProviderFactory, string connectionString, string sql)
{
DbConnection connection;
DbCommand command;
BuildCommand(dbProviderFactory, connectionString, sql, out connection, out command);
using (connection)
{
connection.Open();
command.ExecuteNonQuery();
}
}
internal static void BuildCommand(DbProviderFactory dbProviderFactory, string connectionString, string sql, out DbConnection connection, out DbCommand command)
{
connection = dbProviderFactory.CreateConnection();
connection.ConnectionString = connectionString;
command = dbProviderFactory.CreateCommand();
command.Connection = connection;
command.CommandText = sql;
}
internal static object ExecuteScalar(DbProviderFactory dbProviderFactory, string connectionString, string sql)
{
DbConnection connection;
DbCommand command;
BuildCommand(dbProviderFactory, connectionString, sql, out connection, out command);
using (connection)
{
connection.Open();
return command.ExecuteScalar();
}
}
#endregion
}
}
|