blocks|key|962965|text|.edmx是实体框架。.dbml是LINQ-to-SQL。虽然它们的一般用途是相同的，但它们是完全不同的框架。实体框架比较新，可能是您学习时间的最佳投资，因为我怀疑这将是许多创新的地方。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|962966|entityMap^0|0|5|B|5|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

<code>.edmx</code> is the Entity Framework. <code>.dbml</code> is LINQ-to-SQL. While their general purpose is the same, they are entirely different frameworks. Entity Framework is newer and will probably be the best investment of your time to learn since I suspect that is where a lot of innovation is going to go.

blocks|key|963005|text|LINQ+to+SQL的主要功能是支持针对SQL+Server的快速应用程序开发。LINQ+to+SQL允许您拥有现有数据库架构的强类型视图。您可以在表上构建LINQ查询，并将结果作为强类型对象返回。当添加到应用程序中时，LINQ+to+SQL有“.dbml”(LINQ+to+SQL)文件。您可以通过使用属性修饰现有类来使用LINQ+to+SQL。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|963006|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

LINQ to SQL mainly has features to support Rapid Application Development against SQL Server. LINQ to SQL allows you to have a strongly typed view of your existing database schema. You can build LINQ queries over tables and return results as strong typed objects. LINQ to SQL has “.dbml”(LINQ to SQL) file when added in the application. You can use LINQ to SQL by decorating the existing classes with the attributes.

blocks|key|963070|text|这两种技术都是作为最新技术引入的，有时会让人有点困惑，什么时候该使用哪种技术。Entity+Framework和LINQ+to+SQL有很多共同之处，但在许多方面仍然不同：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|963071|实体框架：|963072|企业开发:使用数据库的概念模型:使用所有数据源:使用实体框架时创建.EDMX：|963073|LINQ:：|963074|快速应用开发:使用数据库中的对象:主要使用SQL+Server:".dbml“是在使用LINQ+to+SQL时创建的：|963075|：|963076|实体框架更多地针对企业开发，在企业开发中，模式通常针对存储考虑因素进行了优化，如性能、一致性和分区。Entity+Framework是围绕公开面向应用程序的数据模型而设计的，该数据模型是松散耦合的，可能与现有的数据库架构不同。例如，您可以将单个实体(类)映射到多个实体，或者将多个实体映射到同一个表。实体框架在添加到应用程序中时会有“.edmx”(ADO.NET实体模型)文件。|963077|LINQ+to+SQL的主要功能是支持针对SQL+Server的快速应用程序开发。LINQ+to+SQL允许您拥有现有数据库架构的强类型视图。您可以在表上构建LINQ查询，并将结果作为强类型对象返回。当添加到应用程序中时，LINQ+to+SQL有“.dbml”(LINQ+to+SQL)文件。您可以通过使用属性修饰现有类来使用LINQ+to+SQL。|963078|Original+source:+[https://parassanghani.blogspot.com/2011/01/entity-framework-vs-linq-to-sql.html]|offset|length|963079|entityMap|0|LINK|mutability|MUTABLE|url|https://parassanghani.blogspot.com/2011/01/entity-framework-vs-linq-to-sql.html^0|0|0|0|0|0|0|0|0|0|2Q|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|13|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|14|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|15|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|16|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|17|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|18|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|19|8|@]|9|@$R|1A|S|1B|1|1C]]|A|$]]|$1|T|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|U|$V|$5|W|X|Y|A|$Z|10]]]]

Both are introduced as latest technologies and at times a bit confusing when to use which. Entity Framework and LINQ to SQL have a lot in common but still different from each other in quite a few ways: 

Entity Framework: 
1. Enterprise Development: 
2. Works with Conceptual model of database: 
3. Works with all data sources: 
4. ".EDMX" is created while using Entity Framework: 

LINQ:: 
1. Rapid Application Development: 
2. Works with objects in database: 
3. Mainly woks with SQL Server: 
4. ".dbml" is created while using LINQ to SQL: : 

Entity Framework is more targeted towards Enterprise Development where the schema is usually optimized for storage considerations like performance consistency and partitioning. Entity Framework is designed around exposing an application-oriented data model that is loosely coupled and may differ from the existing database schema. For example, you can map a single entity (class) to multiple or map multiple entities to the same table. Entity Framework has “.edmx” (ADO.NET Entity Model) file when added in the application.

LINQ to SQL mainly has features to support Rapid Application Development against SQL Server. LINQ to SQL allows you to have a strongly typed view of your existing database schema. You can build LINQ queries over tables and return results as strong typed objects. LINQ to SQL has “.dbml”(LINQ to SQL) file when added in the application. You can use LINQ to SQL by decorating the existing classes with the attributes.

[Original source: <a href="https://parassanghani.blogspot.com/2011/01/entity-framework-vs-linq-to-sql.html" rel="nofollow noreferrer">https://parassanghani.blogspot.com/2011/01/entity-framework-vs-linq-to-sql.html]</a>

blocks|key|747262|text|我从来没有理解过像定义这样的文献。无论如何，底线是L2S是轻量级的，而EF是重量级的。这意味着L2S只适用于SQLServer，而EF适用于更多。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|747263|参考：Difference+between+L2S+and+EF|offset|length|747264|entityMap|0|LINK|mutability|MUTABLE|url|http://www.dotnettricks.com/learn/entityframework/difference-between-linq-to-sql-and-entity-framework^0|0|3|T|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I never understood the literature like definitions. Anyways the bottom line is L2S is lightweight and EF is heavy weight. Meaning L2S works only with SQLServer and EF works with many more. 

Reference: <a href="http://www.dotnettricks.com/learn/entityframework/difference-between-linq-to-sql-and-entity-framework" rel="nofollow noreferrer">Difference between L2S and EF</a>

What is difference between .edmx and .dbml file in linq?In VS 2008 which datasource is best choice where edmx or dbml?Any problem will arise using edmx file in VS 2008?Can i use edmx in VS-2008?

What is difference between .edmx and .dbml file in linq?

SQL Server

数据库

在linq中.edmx和.dbml文件有什么不同?在VS2008中哪个数据源是edmx或dbml的最佳选择?在VS2008中使用edmx文件会出现任何问题吗?我可以在VS-2008中使用edmx吗？

问linq中的.edmx文件和.dbml文件有什么不同？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问linq中的.edmx文件和.dbml文件有什么不同？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问linq中的.edmx文件和.dbml文件有什么不同？
EN