使用95％的SQL代码创建Web应用程序? [英] Creating a web application with 95% of the code in SQL?

问题描述

使用ASP.NET和SQL Server 2008创建几乎所有逻辑和处理都在数据库服务器上的Web应用程序是个好主意吗?

要澄清的是，这将是一个将对复杂设备进行尺寸确定和定价的应用程序.将有一个ASP.NET前端，该前端具有使用存储的proc生成的HTML和Javascript占位符.将存储大量表并动态创建HTML和Javascript.该应用程序对于公司来说将是非常大的并且非常重要.

在SQL中包含所有内容的原因是为了使应用程序具有灵活性，以便它可以表示许多不同的产品系列和系统类型.

Would it be a good or bad idea to create a web application using ASP.NET and SQL Server 2008 where pretty much all of the logic and processing falls on the database server?

To clarify, this would be an application that would size and price complex equipment. There would be an ASP.NET front end that has placeholders for HTML and Javascript that are generated by using stored procs. There would be lots of table stored and dynamically created HTML and Javascript. This application would be quite large and important to the company.

The reason to have everything in SQL would be to make the application flexible so that it could represent many different product lines and system types. It would also be used globally.

推荐答案

我本以为C#/VB比SQL给您更大的灵活性:当然，它应该更易于维护，并且整个负载更易于测试和调试！

I would have thought that C# / VB would give you greater flexibility than SQL: certainly it should be more easily maintainable, and a whole load easier to test and debug!

这篇关于使用95％的SQL代码创建Web应用程序?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！