How to: Generate Customized Code by Modifying a DBML File (LINQ to SQL)

  • Article

You can generate Visual Basic or C# source code from a database markup language (.dbml) metadata file. This approach provides an opportunity to customize the default .dbml file before you generate the application mapping code. This is an advanced feature.

The steps in this process are as follows:

  1. Generate a .dbml file.

  2. Use an editor to modify the .dbml file. Note that the .dbml file must validate against the schema definition (.xsd) file for LINQ to SQL .dbml files. For more information, see Code Generation in LINQ to SQL.

  3. Generate the Visual Basic or C# source code.

The following examples use the SQLMetal command-line tool. For more information, see Code Generation Tool (SqlMetal.exe).

Example

The following code generates a .dbml file from the Northwind sample database. As source for the database metadata, you can use either the name of the database or the name of the .mdf file.

sqlmetal /server:myserver /database:northwind /dbml:mymeta.dbml
sqlmetal /dbml:mymeta.dbml mydbfile.mdf

The following code generates Visual Basic or C# source code file from a .dbml file.

sqlmetal /namespace:nwind /code:nwind.vb /language:vb DBMLFile.dbml
sqlmetal /namespace:nwind /code:nwind.cs /language:csharp DBMLFile.dbml

See Also

Concepts

Code Generation in LINQ to SQL

Reference

Code Generation Tool (SqlMetal.exe)

Other Resources

Creating the Object Model (LINQ to SQL)