表现明智哪个更好？实体框架/ LinqSQL / ado.net在c＃windows应用程序中存储proc [英] performance wise which is better choice? Entity framework / LinqSQL / ado.net store proc in c# windows application

问题描述

我们计划开发拥有大约1000名用户的c＃windows应用程序。哪个是与sql db通信的最佳选择？ ado.net与商店proc？ EF&LSQL可能性能不好吗？如果错了，请纠正我？

We are plannig to develope c# windows application having around 1000 users. which is the best option for communicating to sql db? ado.net with store proc? EF & LSQL could be perfomance wise bad ? correct me if am wrong?

推荐答案

I think always using SP's is somewhat old school. I used to code that way, and now do everything I can in EF generated code...and when I have a performance problem, or other special need, I then add back in a strategic SP to solve a particular problem....it doesn't have to be either or - use both.

All my basic CRUD operations are straight EF generated code - my web apps used to have 100's or more of SP's, now a typical one will have a dozen SP's and everything else is done in my C# code....and my productivity has gone WAY up by eliminating those 95% of CRUD stored procs.

这篇关于表现明智哪个更好？实体框架/ LinqSQL / ado.net在c＃windows应用程序中存储proc的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！