Informix SchemaProvider for CodeSmith, Informix Database Provider for MS Enterprise Library

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sean Baker - 26 Apr 2006 22:00 GMT

For those interested, I created a SchemaProvider for CodeSmith that uses the Informix .NET Provider. Tested with IDS 9.4 and CSDK 2.9. Source can be found here:

http://community.codesmithtools.com/files/9/schemaproviders/entry12998.aspx

CodeSmith is a great tool for generating .Net code. We're using it to generate the middle layer objects for a .Net project here.

I also have an Informix Database Provider for the Microsoft Enterprise Library (June 2005 release). If anyone is interested, just let me know and I'll send it your way (sbaker@moneymailer.com).

Thanks,

Sean.

Reply to this Message

robsosno - 27 Apr 2006 21:30 GMT

Sean Baker napisał(a):

> For those interested, I created a SchemaProvider for CodeSmith that uses the Informix .NET Provider. Tested with IDS 9.4 and CSDK 2.9. Source can be found here:
>
[quoted text clipped - 7 lines]
>
> Sean.

I've also tried to create Informix Database Provider for Enterprise
Library 2005. I've converted sample Northwind database to Informix and
I've wrote the provider.
Unfortunately unit tests included in the Library revealed that my
provider does not work correctly in many scenarios.
I've discovered that all this problems are related to buggy Informix
.NET 2.90 driver.
Problems with 2.90 driver are:
- no support for multiple result sets (example sql string:
"Select * from Region; Select * from Orders");
- undocumented DeriveParameters which behaves differently than MS SQL
counterpart - different stored procedure parameter counting, RETURN in
place of expected RETURN_VALUE parameter;
- supported only en_us locale in Windows (issue with formating numeric
values for pl_PL locale - CP1250);

So how you've made that magic that Enterprise Library works with
Informix driver? I'm very interested in it because my own approach
failed. I.e. basic functionality works, more complex doesn't.

Robert

Reply to this Message