private void AddInsertUpdateStoredProcedures(CProject dataProject, List <CTable> tables) { //merge version of stored procs //update stored procedures foreach (var table in tables) { var converter3 = new CTableToSqlServerStoredProcedureAddUpdateConverter(); var storedProcedure = converter3.Convert(table); AddSchema(dataProject, $"{storedProcedure.Schema.SchemaName}"); var fileName = $"{storedProcedure.StoredProcedureName}.sql"; //var filePath = System.IO.Path.Combine(System.IO.Path.Combine(OutputRootPath, dataProject.ProjectFolder), fileName); dataProject.ProjectContent.Add(new CProjectContent { Content = storedProcedure, BuildAction = CBuildAction.Build, File = new CFile { Folder = $"{storedProcedure.Schema.SchemaName}\\Stored Procedures", FileName = fileName } }); } }
private void AddInsertUpdateStoredProcedures(KDataStoreProject mDatabaseProject) { //merge version of stored procs //update stored procedures var addUpdateStoredProcedures = new List <KStoredProcedure>(); foreach (var table in mDatabaseProject.Table) { var converter3 = new CTableToSqlServerStoredProcedureAddUpdateConverter(); var storedProcedure = converter3.Convert(table.GeneratedTable); addUpdateStoredProcedures.Add(new KStoredProcedure { StoredProcedureName = storedProcedure.StoredProcedureName, ParameterSetName = storedProcedure.ParameterSetName, ResultSetName = storedProcedure.ResultSetName, GeneratedStoredProcedure = storedProcedure }); } mDatabaseProject.StoredProcedure.AddRange(addUpdateStoredProcedures); }