Windows应用程序中的存储过程需求 [英] Stored Procedure Needs in Windows Application

问题描述

HI祝大家下午好，
我正在使用C#.net创建一个小型Windows应用程序...我是否可以直接编写sql查询或使用存储过程编写SQL查询...它们的区别是什么...优点和缺点

HI Frds Good Afternoon to Everyone,
I am Creating a small Windows Application using C# .net...Whether i can write sql query directly or by using Stored Procedure...What is diiference of them...Advantages and disadvantages

推荐答案

始终与具有存储过程的SQL Server通信...具有以下优点

1.安全性更容易控制
2.您隐藏了底层数据布局，这意味着您可以对其进行更改
3. SP中可以实现很多业务逻辑；您会感到担忧分开
4. SQL将基于SP自动优化自身

也没有我真正经历过的缺点

Always talk to a SQL server with Stored Procedures ... It has the following advantages

1. Security is much easier to control
2. You hide the underlying data layout, which means you can change it
3. A lot of business logic can be implemented in the SP; you get a separation of concerns
4. SQL will automatically optimise itself based on the SP

and no disadvantages that i''ve ever really experienced

这篇关于Windows应用程序中的存储过程需求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！