Abstract
Another version of this very useful component which will help you in managing relational database schema changes and database schema distribution was just now released.
What is New
The following changes have been made to the project:
- Oracle support (tested on version 10g)
- New precondition
DbTriggerNotFound
(supported only on Oracle and MSSQL) - New Oracle specific precondition
OraDbSequenceNotFound
IDatabaseService
interface extended by TriggerExists()
method contract
Files are available for download on Google Code at http://code.google.com/p/dbkeepernet/downloads/list.
How to Use It
To enable DbKeeperNet
within your project:
- Download the engine.
- Update your App.Config (or Web.Config).
- Prepare your database update script (check the sample projects within the source package).
- Add the following 8 lines of code to enable the
DbKeeperNet
within your project (the code below should be part of an installation procedure):
using (UpdateContext context = new UpdateContext())
{
context.LoadExtensions();
context.InitializeDatabaseService(connString);
Updater updater = new Updater(context);
updater.ExecuteXmlFromConfig();
}
References
I'm software developer since 1996. I started with assembler on Intel 8051 CPUs, during years I was interested in C, C++, Sybase PowerBuilder, PHP, Sybase Anywhere Database, MSSQL server and multiplatform development.
Currently I'm developing in C++ and C# (this is my favorit and I spent some time with MCPD achievement). I'm also interested in design patterns.