生成用于SQL的插入，更新，删除功能的函数 [英] generating functions for insert, update, delete functions of SQL

问题描述

每次创建数据库项目时，我都要编写用于插入，更新，删除函数以及其他SQL qeeries的查询.

是否有任何方法可以为此类查询创建函数，并根据需要根据需要传递所需查询的参数?

另外，我们可以编写用于将MS SQL数据源连接到ASP.NET网页的函数吗?

Every time I create a database project, I''ve to write the queries for inserting, updating, deleting functions and for other SQL qeeries.

Is there any way of creating functions for such queries and just passing the arguments for required queries as per our need?

Also, can we write functions for connecting to MS SQL datbase to ASP.NET webpages?

推荐答案

在CP中找到本文
用于存储过程的C#代码生成器 [

Found this article in CP
C# Code Generator for Stored Procedures[^]

另外，有趣的是ADO.NET实体框架: http://msdn.microsoft.com/en-us/library/bb386876.aspx [ ^ ].

另请参阅: http://channel9.msdn .com/Blogs/kreekman/TechDays-2010-ORM-with-ADONET-Entity-Framework-in-NET-40 [

Also what could be interesting is the ADO.NET Entity Framework: http://msdn.microsoft.com/en-us/library/bb386876.aspx[^].

See also: http://channel9.msdn.com/Blogs/kreekman/TechDays-2010-ORM-with-ADONET-Entity-Framework-in-NET-40[^]

这篇关于生成用于SQL的插入，更新，删除功能的函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！