Best Aproach to Relate A Entity Class to the Correspoding Table in a DataBase

Question

i want to relate each Field of an Entity Class to the corresponding datatable Field. im working on c# currently

Any Suggestions?

Answer 1

It is what entity framework is doing, isn't it?

Answer 2

The Entity Framework does exactly that, and very well. It also does a whole lot more such as let you write strong typed LINQ queries directly from your application code.

your other good options are NHibernate or Linq to SQL

this class of frameworks is generally called Object Relational Mapper (ORM)

I would say Entity Framework offers the most conveniences for beginners such as visually configuring your data model. it can infer your object model from your database or it can create a database for you from your object model.

The new Entity Framework Code First approach is incredibly simple and powerful in my opinion http://blogs.msdn.com/b/adonet/archive/2010/07/14/ctp4codefirstwalkthrough.aspx

Answer 3

Microsoft's ADO.NET team just published an Entity Framework Beginners Guide at their team blog: http://blogs.msdn.com/b/adonet/archive/2010/07/19/absolue-beginners-guide-to-entity-framework.aspx

Greets Flo