需要一些关于在LINQ中使用ADO.NET或EF的建议 [英] Need some suggestions on using ADO.NET or EF with LINQ

问题描述

嗨伙计，



我们有Asp.Net 2.0和SQL服务器数据库的应用程序，每个月我们在我的一个数据库表中保存了20万笔交易。在这个表中，我们有一个数据类型为Text的列（我可以将大数据作为字符串）。



现在我想用MVC 5实现相同的应用程序。请建议我哪个更适合我的应用程序Ado.NET或EF？



谢谢，

Eswar



我的尝试：



我认为ADO.Net最适合大型数据库。我需要你的建议。

Hi Folks,

we have application with Asp.Net 2.0 and SQL server Database and every month we save 2 lakhs transactions in one of my database table. In this table we have column with datatype as Text(where i can have huge data as string).

Now i want to implement same application with MVC 5. Please suggest me which one is better for my application Ado.NET or EF ?

Thanks,
Eswar

What I have tried:

I am thinking that ADO.Net is best for Huge Databases. I need suggestions from you.

推荐答案

谷歌实体框架与ado.net，看看两者的优缺点，并决定哪一个符合你的要求。如果原始速度是一个因素，你可能会对ado.net犯错，但如果你的代码更复杂，你可能更喜欢EF的简单性。

Google "entity framework vs ado.net" to see the pros and cons of both and decide which one meets your requirements. If raw speed is a factor you may err toward ado.net, but if your code is more complex you might prefer the simplicity of EF.

由你来决定，但是EF 6.0有改进了很多，并有许多新功能。如果您想要编写Store Procedures并想要从C＃驱动所有操作和业务逻辑，请转到EF。

Its upto you to decide, but EF 6.0 has improved a lot and have many new features. If you want to go away with writing Store Procedures and want all your operations and business logic's to be driven from C#, go for EF.

这篇关于需要一些关于在LINQ中使用ADO.NET或EF的建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！