public int Generate(string nameSpace, string sa, string password) { string SQL = @" USE [{0}] SELECT name, OBJECT_DEFINITION(OBJECT_ID) AS sp FROM sys.procedures WHERE is_ms_shipped <> 1 ORDER BY name "; SqlCmd cmd = new SqlCmd(databaseName.Provider, string.Format(SQL, databaseName.Name)); // cmd.ChangeConnection(sa, password); DataTable dt = cmd.FillDataTable(); foreach (DataRow row in dt.Rows) { SpProc proc = new SpProc(databaseName, (string)row[SP_NAME], row[SP_DEFINITION].IsNull <string>("")); string sourceCode = proc.Proc(nameSpace, databaseName.Name, sa, password); WriteFile(proc.SpName, sourceCode, nameSpace, proc.IsSpChanged(nameSpace, databaseName.Name)); } return(dt.Rows.Count); }
public int Generate(string nameSpace, string sa, string password) { string SQL = @" USE [{0}] SELECT name, OBJECT_DEFINITION(OBJECT_ID) AS sp FROM sys.procedures WHERE is_ms_shipped <> 1 ORDER BY name "; SqlCmd cmd = new SqlCmd(databaseName.Provider, string.Format(SQL, databaseName.Name)); // cmd.ChangeConnection(sa, password); DataTable dt = cmd.FillDataTable(); foreach (DataRow row in dt.Rows) { SpProc proc = new SpProc(databaseName, (string)row[SP_NAME], row[SP_DEFINITION].IsNull<string>("")); string sourceCode = proc.Proc(nameSpace, databaseName.Name, sa, password); WriteFile(proc.SpName, sourceCode, nameSpace, proc.IsSpChanged(nameSpace, databaseName.Name)); } return dt.Rows.Count; }