Home / Software / Tips and Tricks / how to use SQLMetal code generator tool for LINQ to SQL

how to use SQLMetal code generator tool for LINQ to SQL

Updated:  11/02/2013 04:11 AM
Author:  Shiju Mathews

Status:    Resolved.


SQLMetal works as a command line tool that accepts a bunch of parameter options such as database connection parameters and outputs mapping or code files. You would then use this code file within your development environment with LINQ code for accessing and manipulating data in the database.

SQLMetal generates csharp classes and mapping files in the specified locations.

This tool can be used in Visual studio command prompt (START >> All Programs >> Microsoft Visual Studio [version] >> Visual studio tools >> Visual studio command prompt).



sample File


The above command will generate classes and mapping file from database "TestDB" located on Local SQL server.