Change db table name in EF4 (entity framework 4)

by

If you just need to change the name of the table you can:

  1. Open EDMX file with XML Editor.
  2. Locate SSDL section in it.
  3. Locate entity set element for example <EntitySet Name="Customers" EntityType="ExampleModel.Store.Customers" Schema="dbo" />.
  4. Add Table="MyTableName" attribute. <EntitySet Name="Customers" EntityType="ExampleModel.Store.Customers" Schema="dbo" Table="MyTableName" />

Here is a complete CSDL, SSDL, MSL specification.

Hope that helps.

More Related Contents:

  1. Entity Framework/Linq EXpression converting from string to int
  2. Internal .NET Framework Data Provider error 1025
  3. Entity Framework Code Only error: the model backing the context has changed since the database was created
  4. Entity Framework 4: How to find the primary key?
  5. Entity Framework Multiple Object Contexts
  6. Repository Pattern, POCO, and Business Entities
  7. VB Net Class in C# [closed]
  8. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  9. A circular reference was detected while serializing an object of type ‘SubSonic.Schema .DatabaseColumn’.
  10. Entity Framework 4 – AddObject vs Attach
  11. The cast to value type ‘Int32’ failed because the materialized value is null
  12. Entity Framework Join 3 Tables
  13. Making Entity Class Closed for Changes
  14. Filter/Search using Multiple Fields – ASP.NET MVC
  15. The result of a query cannot be enumerated more than once
  16. Entity Framework/Linq to SQL: Skip & Take
  17. Entity Framework – Add Navigation Property Manually
  18. EF Data Context – Async/Await & Multithreading
  19. Why would try/finally rather than a “using” statement help avoid a race condition?
  20. Retrieve an object from entityframework without ONE field
  21. Finding the reason for DBUpdateException
  22. DbContext discard changes without disposing
  23. EF4 Code First: how to add a relationship without adding a navigation property
  24. Max return value if empty query
  25. Group by with multiple columns using lambda
  26. How to do an “in” query in entity framework?
  27. Parallel doesnt work with Entity Framework
  28. big issue in converting string to datetime using linq-to-entities
  29. Entity Framework: Duplicate Records in Many-to-Many relationship
  30. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception

Leave a Comment