Tool to generate DAL for Python and .NET

[Hamster]

I was just wondering if there is a tool out there that can replace the in-house solution that we have. What we want is something that allows us to code our sql queries etc in DSL and then generate the DAL classes etc for other general purpose languages.

Currently we use Python (both on Windows and AIX) and .NET. Anyone know of a tool like this?

 

[Gnome]

DAL is a Data Access Layer correct? Don't you have some kind of business layer?

From an architectural standpoint, I would say having the code duplicated among many languages is very, very bad. I can think of several scenarios that would be a headache to diagnose because many languages have direct access to the DB. To each his own I guess.

But for maintenance and architectural quality I would have a web-service and all the languages simply call methods on that web-service. The web-service would also include the business logic. Therefore any DB queries are identical with each language and changed in 1 place. Apparently .NET is very stable so it should surely be possible to run a web-service that doesn't fall over under load.

 

[Hamster]

Webservices are too slow. This is a massive system that takes up to 200,000 transactions an hour in peak season. The reason we have Python and .NET accessing the DB is because they are effectively two separate systems each with its own DAL and business layer.

 

[Gnome]

Well on Java that wouldn't be an issue but I guess in the .NET world that is a problem.