Evolve db with code
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
You can use the MDriven Framework to do the evolve-database operation from within VisualStudio: | |||
[[File:2019-10-06 14h29 19.png|none|thumb|623x623px]] | [[File:2019-10-06 14h29 19.png|none|thumb|623x623px]] | ||
Line 21: | Line 21: | ||
PersistenceMapperAdo2 pmapp | PersistenceMapperAdo2 pmapp | ||
pmapp.CreateDatabaseSchema(YourEcoSpace.GetTypeSystemService(), new DefaultCleanPsConfig(true)); | pmapp.CreateDatabaseSchema(YourEcoSpace.GetTypeSystemService(), new DefaultCleanPsConfig(true)); | ||
[[Category:MDriven Framework]] | [[Category:MDriven Framework]] | ||
[[Category:Database]] | |||
[[Category:Database]] |
Revision as of 08:54, 9 February 2023
This page was created by Hans.karlsen on 2019-10-06. Last edited by Edgar on 2025-01-20.
You can use the MDriven Framework to do the evolve-database operation from within VisualStudio:
You can also do these operations in runtime:
PersistenceMapperAdo2 pmapp var systemservice = YourEcoSpace.GetTypeSystemService(); string[] ExecutedStatements; string result; IDBEvolutor evolutor = pmapp.GetEvolutor(systemservice); evolutor.CalculateScript(); evolutor.GenerateDbScript(); evolutor.GenerateMappingScript(); evolutor.GenerateWarnings(); evolutor.GenerateErrors(); evolutor.ExecuteScript(); result = "Evolve success\r\n"; ExecutedStatements = evolutor.GenerateExecutedStatements(); foreach (string s in ExecutedStatements) result += s + "\r\n";
To fill a database with schema information the first time:
PersistenceMapperAdo2 pmapp pmapp.CreateDatabaseSchema(YourEcoSpace.GetTypeSystemService(), new DefaultCleanPsConfig(true));