Entity Framework – Generating Classes

by

1) First you need to generate EDMX model using your database. To do that you should add new item to your project:

  • Select ADO.NET Entity Data Model from the Templates list.
  • On the Choose Model Contents page, select the Generate from Database option and click Next.
  • Choose your database.
  • On the Choose Your Database Objects page, check the Tables. Choose Views or Stored Procedures if you need.

So now you have Model1.edmx file in your project.

2) To generate classes using your model:

  • Open your EDMX model designer.
  • On the design surface Right Click –> Add Code Generation Item…
  • Select Online templates.
  • Select EF 4.x DbContext Generator for C#.
  • Click ‘Add’.

Notice that two items are added to your project:

  • Model1.tt (This template generates very simple POCO classes for each entity in your model)
  • Model1.Context.tt (This template generates a derived DbContext to use for querying and persisting data)

3) Read/Write Data example:

 var dbContext = new YourModelClass(); //class derived from DbContext
 var contacts = from c in dbContext.Contacts select c; //read data
 contacts.FirstOrDefault().FirstName = "Alex"; //edit data
 dbContext.SaveChanges(); //save data to DB

Don’t forget that you need 4.x version of EntityFramework. You can download EF 4.1 here: Entity Framework 4.1.

More Related Contents:

  1. summing values of a column based on id [closed]
  2. There is already an open DataReader associated with this Command which must be closed first
  3. MSSQL Error ‘The underlying provider failed on Open’
  4. Why does the EF 6 tutorial use asynchronous calls?
  5. Entity Framework Stored Procedure Table Value Parameter
  6. Method cannot be translated into a store expression
  7. How can I automatically filter out soft deleted entities with Entity Framework?
  8. Implementing Zero Or One to Zero Or One relationship in EF Code first by Fluent API
  9. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  10. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  11. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  12. One to one optional relationship using Entity Framework Fluent API
  13. Implementing Audit Log / Change History with MVC & Entity Framework
  14. Filter all queries (trying to achieve soft delete)
  15. Entity Framework – Cannot convert lambda expression to type ‘string’ because it is not a delegate type
  16. Internal .NET Framework Data Provider error 1025
  17. Missing ProviderName when debugging AzureFunction as well as deploying azure function
  18. SQL Injection attack prevention: where do I start
  19. Can EF automatically delete data that is orphaned, where the parent is not deleted?
  20. How to filter data using Entity Framework in a way that DataGridView be editable and context track changes?
  21. Filtering include items in LINQ and Entity Framework [duplicate]
  22. Getting all changes made to an object in the Entity Framework
  23. How are people unit testing with Entity Framework 6, should you bother?
  24. Duplicate key exception from Entity Framework?
  25. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  26. How do I specify that a property should generate a TEXT column rather than an nvarchar(4000)
  27. Change db table name in EF4 (entity framework 4)
  28. System.Data.MetadataException: Unable to load the specified metadata resource
  29. Where to convert business model to view model?
  30. Entity Framework SaveChanges() vs. SaveChangesAsync() and Find() vs. FindAsync()

Leave a Comment