public static SqlCommand GetSpCommandByConnectToDb(SqlServerDBs DbToConnect, string SpName)
{
SqlConnection sqlConnection = new SqlConnection(GetSqlServerConnectionString(SqlServerDBs.DbAdmin).ToString());
sqlConnection.Open();
return(new SqlCommand(SpName, sqlConnection)
{
CommandType = System.Data.CommandType.StoredProcedure,
});
}
public static string GetSqlServerConnectionString(SqlServerDBs DbToConnect)
{
string DbConnetionString = string.Empty;
switch (DbToConnect)
{
case SqlServerDBs.DbAdmin:
DbConnetionString = "Server=" + HostName + ";User Id=" + DbUserName + ";pwd=" + DbPassWord + ";Database=" + DbToConnect.ToString();
break;
case SqlServerDBs.SampleDb:
new Exception("No Db like " + DbToConnect.ToString());
break;
default:
DbConnetionString = "Server=" + HostName + ";User Id=" + DbUserName + ";pwd=" + DbPassWord + ";Database=" + DbToConnect.ToString();
break;
}
return(DbConnetionString);
}
