Sql Server vs Nhibernate vs Entity Framework [英] Sql Server vs Nhibernate vs Entity Framework

问题描述

嗨专家，



我需要生成条件（50+）列的动态查询。以下哪项技术性能好？



1. Sql Server

2. Nhibernate

3 。实体框架



请建议。

Hi Experts,

I needs to generate dynamic query having where condition (50+) columns. Which technology from the following is good in performance?

1. Sql Server
2. Nhibernate
3. Entity Framework

Please suggest.

推荐答案

2和3可以坐在1 ..我猜你的意思是System.Data.SqlClient？



无论如何 - 只要你只询问你需要的数据，这三者在性能方面都是完全足够的并在数据库服务器端执行所有过滤和聚合操作。

2 and 3 can sit on top of 1... I guess you actually mean System.Data.SqlClient?

Anyway - all three are perfectly adequate in terms of performance so long as you only ask for the data you need and perform all of your filtering and aggregation operations on the database server side.

实体框架和Nhibernate是对象关系映射器（ORM）.Entity框架是一个很好的选择，因为它带有Nuget包。



LINQ也是一个生成动态查询的选项。

Entity framework and Nhibernate are Object relation mappers(ORM).Entity framework is a good choice as it comes with Nuget package.

LINQ will also be an option to generate dynamic queries.

这篇关于Sql Server vs Nhibernate vs Entity Framework的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！