Please read this article serie from the beginning
The DAL we created in part 13 might be good enough – I would not be ashamed over code like that – however there are some more things to do. As you might know MySQL does (since version 5.0) support stored procedures. Please read the related articles and the [...]
Please read this article serie from the beginning
First step is of course to create a MySQL database – with the same columns as the MSSQL. I used a database called DemoUpload and ran this script
DROP TABLE IF EXISTS `demoupload`.`cust_file`;
CREATE TABLE `demoupload`.`cust_file` (
`id` int(10) unsigned NOT NULL auto_increment,
`customer_id` int(10) unsigned NOT NULL [...]
While the solution downloadable in part 11 is "ok" – I can almost bet that the first time you create such a solution yourself – or even if you just decide to develop a new DAL driver for this particular project I can almost bet you will get an error like
NullReferenceException was unhandled by user [...]
Please read this article serie from the beginning
In part 10 we started implementing our DAL – and having it implement a welldefined interface is gonna make our application able to dynamically load which data access layer to use. It will open up for the possiblity to switch data storage engines – even to later on add [...]