This advanced feature comes with some exceptions. SQLMetal cannot extract a
stored procedure that calls itself. The nesting level of the database objects, like views,
functions, and stored procedures, should not exceed 32.
For creating the entity classes for the Deserts database that we created through the
previous examples, the command would look like this:
sqlmetal /server:.\SQLExpress /database:c:\demo\Deserts.mdf
/pluralize/namespace:Deserts /code:Deserts.cs
The above command will create the Deserts.cs file which contains the entity
classes, and their relationship and definitions for the objects. This will create the
classes using C# language. If you want to get the classes in VB, just rename the code
as Deserts.vb instead of Deserts.cs to identify the language to be used. SQLMetal
also has an option to specify the language. We can use that as well for creating the
entity classes.
Using SQLMetal, we can create the DBML as follows:
sqlmetal /server:.\SQLExpress /database:c:\demo\Deserts.
Pages:
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199