Pick an open source project and contribute!
Cheers!
Pick an open source project and contribute!
Cheers!
Don't get your hopes up that inline SQL will just run on any database you want. Even coding directly to the ANSI specification (92, 99, or 03) does not guarantee you can just point your app to any database and have it work or work without any issues. (like performance issues) Even in your simple example, "select @@identity" will work on MSSQL databases. Just like Java: "Write once, test everywhere...." You might want to think about abstracting your data access into different interfaces. Something like having an MSSQL interface, a Access DB interface, a MySQL interface. This, combined with a good unit testing plan, can get you close to DB independence...
Cheers
Try creating a user control with the Address(name address,city,zip) info on it. Then you add\delete the just the user control each time. This way you only need to manage 1 control per address...
Cheers