When using LINQ to SQL in one of our projects, we came across a situation where we had to make a lot of changes to the DBML file SqlMetal generates, such as:
- Change all lookup values to enums so that our code looks more elegant
- Modify the generated association member names to our own names for better readability
- Remove unwanted tables/Stored Procedures
- etc.
The add-in looks for an XML file in the same folder as the DBML file with a name as DBML file name "custom.xml". So, if your DBML file name is Northwind.dbml, then your custom mapping file should be named as "northwind.dbml.custom.xml".
View XML well structured and clearly, modification is made easy by various editing features.
Comments