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); }