Q: Having looked at the tool converted code I think the best approach would be to "rewriting the code to use a .NET emulation of ADODB (this is compatible with what you have, but still requires some work)" because any other option would require significant re-engineering to make the application work. I wanted to run the FMStocks sample, however I couldn't find the SQL database in the zip file. I tried accessing the http://www.fmstocks.com/ website but it is not available. Wonder if you could send me the SQL script or data file by email.
A: Regarding "having looked at tool converted code": bear in mind that you are looking at a default conversion. gmStudio can produce other code based on the rules you provide including automating most of the "significant re-engineering required to make the application work". I know I mentioned this already, but most developers have difficulty grasping this concept because this type of flexibility has never been available in a software "converter". These developers believe if they must take whatever code the tool generates right out-of-the-box and finish it by hand. I admit it does take effort to learn how to setup rules and ADODB is a big API and it is a quite different from design patterns for other .NET data access techniques.
Having said this, the C# will be your system in the long term, long after the conversion. This is your decision to make. So, having said that:
I uploaded a copy of the database files: http://www.greatmigrations.com/pubs/stocks_data.zip (SQL 2008)
They can also be found here: http://www.microsoft.com/en-us/download/details.aspx?id=666
DataLib Email
I have prepared the source for DataLib and unit tests. Sorry for the delay, we were making some improvements that I wanted to include in your copy.
The content will be here for the next few days:
http://www.greatmigrations.com/pubs/MigrationSupport.DataLib.zip
There is also a test DB for the unit tests
http://www.greatmigrations.com/pubs/stocks_db.zip
Please let me know when you have downloaded it.
About DataLib
- This code is offered without warranty.
- You are responsible for testing and fixing it as needed by your application.
- Some of the less frequently used ADODB features that are not yet implemented.
- You may include DataLib source with other project deliverables if you used a licensed copy of gmStudio to produce the code that uses DataLib.
- Having said that, we would like to hear about any problems you encounter with this code as we are always improving it here.
- GM can provide supported for DataLib in the context of an active gmStudio statement of work and services contract.
Regards,
Mark Juras | www.GreatMigrations.com | 614-638-4632 | mailto:Mark@GreatMigrations.com
See also Support Statement: Stub Replacement