TierDeveloper lets you map your .NET business components against your relational databases, embed complex SQL in them along with your business rules. It generates truly object oriented .NET components in C# and VB.NET. Use these components in COM+ or stand-alone environments and in ASP.NET or Windows Forms applications. Develop apps in matter of hours and days instead of weeks and months.
why would you want to generate and embed complex SQL with your business rules? and what is OO about this approach?
embedded SQL is bad, you can't debug it and it is not optimized for execution.. especially when dealing with complex SQL ...
in an enterprise app you should always keep the data access logic and your business rules separate, encapsulation is the key
This might be a good idea for quick and dirty prototype kind of a scenario but when you talk about large enterprise system that have to be maintained and scaled over time this sort of approach will be a project killer...