DB2 doesnt like [ and ]

[jpvanheerden]

Hi

I have made my first dOOdad based application live, but I needed to make some changes to OleDbDynamicQuery.cs and BusinessEntity.cs so that DB2 would be happy with SQL. DB2 doesnt like [ and ] around table and column names.

Obviously I didnt want to change the framework itself, but I had to, otherwise it wouldnt have worked.

The following is an example of the change:

columnName = \"[\" + wItem.Column + \"]\";

changed to:

columnName = wItem.Column;

Can we create a property called DoesntLikeSquareBrackets that if set to true wouldn't try to create square brackets around table names and columns?

Any ideas?

Thanks
Jean-Pierre

[dnparsons]

Instead of changing BusinessEntity.cs, I would override AddNew in OleDbEntity.cs. You can look at MySql4Entity.cs to see how that was done. That way you only affect the OleDb dOOdads data adapter, not all the others (just in case you need them down the road.)

Of course, the best solution would be to make a DB2 specific dOOdads data adapter by copying the OleDbDynamicQuery.cs and OleDbEntity.cs files, rename them Db2DynamicQuery.cs and Db2Entity.cs, and put the provider specific code there. The tricky part would be making the dOOdads Business Entity template DB2 aware. But, if you did that, and shared, you might get your name in lights

[jpvanheerden]

David

Thanks for the input, I give that a go.

Jean-Pierre

[jpvanheerden]

Morning all

I have made the changes suggested - I have created Db2DynamicQuery.cs and Db2Entity.cs and ammended the \"dOOdads Business Entity\" template to be aware of iSeries and then offer the option of using the classes above instead of OleDbDynamicQuery.cs and OleDbEntity.cs

Where should I send the classes and template so that they are included in the next build?

Jean-Pierre

[dnparsons]

That is awesome

I wouldn't presume to speak for Mike or Justin about getting them included in the next build, especially since I do not even have access to an iSeries to help test. There would be a lot of work ahead before that happened... VB version, testing, documentation, etc.

In the meantime, they have generously provided a template archive, so you can still share and get some peer-to-peer feedback. There are some general template archive instructions in this thread. As an avid MyGeneration user, I have some specific (but un-official) suggestions:

Before uploading, (assuming you started with a working copy of he official template), make sure you gave the template a unique Guid, Name, NameSpace, and SaveAs filename.

I would create a \"DB2 DataAdapter for dOOdads(Beta)\" template archive and post it there. You should also zip up the cs files and upload them as well. This will give you a description area to elaborate a bit on its use, will give the community an opportunity to try it out, and will notify you via email of messages posted in the archive.

As far as template archive categories, unfortunately, there is no specific category for dOOdads. I think Multi-Tier, Win32, and C# would give people ample opportunity to find it.

I would announce it in the peer-to-peer forum.

I hope this helps,

[jpvanheerden]

David

Suggestions followed to the letter


Jean-Pierre

[jpvanheerden]

David

Browsing around the templates I noticed that you did some work on generating C# forms - whats the status on that?

Thanks,
Jean-Pierre

[dnparsons]

Suggestions followed to the letter

hehe... I can see that. I'm glad you found them useful. Now, if I could only get my nieces and nephews to take me seriously. If your last post had been, "You're not the boss of me!", it would have been OK. I would have felt like I was back vacationing at my sister's.

Thanks for sharing

[dnparsons]

My focus is now on EntitySpaces. Some generous users did pick up where I last left things. MyKey0815 converted them to VB, well0549 has improved upon those, and MadMan2 has a version for the .NET 2 DataGridView and other niceties.