Category Archives: database

Using DbUpdater with MySql

DbUpdater can be used with mysql. Here are the files you need to jumpstart the integration – DbUpdater-MySql.zip 1. You might need to change the path to mysql.exe in mysql-exec.bat. 2. Modify values in mysql-sample-command-line.bat. Make sure mysql.data.dll is placed in GAC or in the same directory as DbUpdater.exe. Connector binaries can be downloaded from [...]
Also posted in opensource, sql, tips | Tagged , , , , , , , | Leave a comment

Using NHibernate With SQLite in DbUpdater

DbUpdater (version 1.3 onwards) can be used with sqlite3. Review the files included in DbUpdater-sqlite3.zip 1. DbUpdater.exe.config must be modified. Note changes to the following keys – exe-file, exe-args, dialect, driver_class, connetion_string. 2. SchemaVersion.hbm.xml must be modified. The ‘class’ attributes value for the ‘generator’ of ‘id’ must be changed to ‘identity’. No other changes are [...]
Also posted in code, opensource, sql | Tagged , , , | 8 Comments

DbUpdater on SourceForge

By popular demand, DbUpdater is now up on the sourceforge. Latest download (v1.2) is now available from there.
Also posted in opensource | Tagged , , , | Leave a comment

WPF – LINQ to SQL Sample

This exercise in binding a WPF ListView control with LINQ to SQL was a lot of fun ! The following image shows data from AdventureWorks sample database displayed in the ListView control. The end result is very admirable, even in this very basic demo. Feeling a complete sense of freedom is unavoidable when working with [...]
Also posted in C#, code, LINQ, sql, WPF | Tagged , , , , , , , , , , , , , , , , | 7 Comments