Sample EDMX Code Generator

NEW POST: Final generator source available?

KevinR — Mon, 02 Jun 2008 22:48:20 GMT

I would like to extend the functionality of the EDMX code generator once the final version has shipped by adding some custom CSDL annotations and modifying the generated code appropriately. Will the source code for the standard generator be available so that I can piggy back on it's code generation. I suppose the alternative is to write an entire EDMX generator from scratch??

NEW POST: Final generator source available?

KevinR — Mon, 02 Jun 2008 22:48:19 GMT

NEW POST: How to get extended property from sql ?

Thierry — Sat, 01 Mar 2008 16:33:39 GMT

Hi

i have a look to this code and it help me to understand.
I want to add CustomAttributes to the classes & properties of the generated code. (I can do that with this code)
But my problem is that the descriptions of the customattribut are in the extended properties of Tables and columns of my sql databases.
So i would get the dataconnection use to retreive the database description for execute some sql commands to get the extended properties and and my CustomAttributes.

How can i do ?

Tx
Thierry

NEW POST: Use it to generate Enum properties

MatthieuMEZIL — Tue, 19 Feb 2008 15:55:58 GMT

I use your code to generate directly in .designer.cs properties of type Enum which encapsulate the csdl properties. All is here: http://blogs.codes-sources.com/matthieu/archive/2008/02/19/matthieu-fait-mumuse-avec-le-g-n-rateur-de-classe-d-edm.aspx

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 19:04:58 GMT

The goal of the Sample EDMX Code Generator is to provide you with enough insight into how the ADO.NET Entity Designer generates code in Visual Studio and hopefully give you a head start with some sample source code.

SampleEdmxCodeGenerator is not intended for production use; instead, it demonstrates custom tool extensibility via SingleFileGenerator, code generation APIs, code generation events and EDM metadata APIs. The sample is also somewhat incomplete on error handling and has not been tuned for performance, stress, etc.

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

Build

Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

Register

Building the project does not register SampleEdmxCodeGenerator with Visual Studio; you should do this manually. If you plan to register and unregister often, it may be a good idea to create a batch file with these steps to make this easier.

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command: gacutil /i <full path to SampleEdmxCodeGenerator.dll>
Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008: reg import <full path to RegisterWithVS.reg> NOTE: RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.

Unregister

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command: gacutil /u SampleEdmxCodeGenerator
Next, type the following commands exactly as they appear to unregister SampleEdmxCodeGenerator with Visual Studio 2008:

reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\CLSID\{322EB3BE-19FB-4B6D-9370-1A6474C60D00}
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{FAE04EC1-301F-11D3-BF4B-00C04F79EFBC} \SampleEdmxCodeGenerator
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{164B10B9-B200-11D0-8C61-00A0C91E29D5}\SampleEdmxCodeGenerator

Test

The SampleEdmxCodeGenerator sources folder has file called SampleModel.edmx that you can use for basic sniff test purposes.

Process an EDMX file with SampleEdmxCodeGenerator

As you probably noticed by now, an EDMX file’s “Custom Tool” property is set to EntityModelCodeGenerator. Making Visual Studio use SampleEdmxCodeGenerator is pretty simple: select the EDMX file in Solution Explorer and type SampleEdmxCodeGenerator as the “Custom Tool” property value.

Visual Studio will immediately run SampleEdmxCodeGenerator to process the EDMX file. You can force Visual Studio to call SampleEdmxCodeGenerator to process the EDMX contents by right-clicking the EDMX file in Solution Explorer and choosing “Run Custom Tool”.

EntityModelCodeGenerator and SampleEdmxCodeGenerator can live side-by-side with each other. For example, you can have 2 EDMX files in the same project with the “Custom Tool” for one set to EntityModelCodeGenerator and other set to SampleEdmxCodeGenerator.

Add and edit CSDL annotations

Since the ADO.NET Entity Designer has no support to visually add or edit CSDL annotations you’ll need to open the EDMX file in XML Editor to do this. This is easy enough to do as follows:

Right-click on the EDMX file in Solution Explorer and choose “Open With…”
Click on “XML Editor” in the “Open With” dialog box
Click OK
The EDMX file opens in XML Editor instead of the ADO.NET Entity Designer
If you prefer, you can reformat the XML document to make it more legible by pressing Ctrl+A and clicking on the “Reformat Selection” button on the XML Editor toolbar

While the ADO.NET Entity Designer doesn’t support it, you could easily imagine a Visual Studio Addin that shows CSDL annotations in a nice GUI and lets you edit them outside of the designer.
When an EDMX file with CSDL annotations is opened in XML Editor, Visual Studio will show information messages saying something like:

Could not find schema information for the attribute 'http://tempuri.org/SampleAnnotations:ClrAttributes'

These messages can be safely ignored but if you really care then you can create an XSD for your custom namespace and copy the XSD into %vsinstalldir%\Xml\Schemas. Doing this not only gets rid of the messages but you also get intellisense when you type CSDL annotations in XML Editor.

The parsing logic in SampleEdmxCodeGenerator is pretty simplistic and expects multiple CLR attributes to be separated by ‘;’ and only supports string and bool attribute parameters. You could easily extend the sample to work with more complicated constructs.
As soon as you make a change to the EDMX file, Visual Studio will call SampleEdmxCodeGenerator to process the EDMX contents which will immediately generate classes with the appropriate CLR attributes.

Open an EDMX file with CSDL annotations in the designer

The ADO.NET Entity Designer has no support to visually add or edit CSDL annotations. However, the designer preserves any existing CSDL annotations in the EDMX file and the file is rendered properly.

Thus, it is possible to open an EDMX file in the designer even when it contains CSDL annotations and even when it’s “Custom Tool” property is set to SampleEdmxCodeGenerator. One side-effect of this is classes for any new entities created via the designer will be generated by SampleEdmxCodeGenerator. This may be ok as long as you are aware this is happening under the covers.

When an EDMX file with CSDL annotations is opened in the ADO.NET Entity Designer, Visual Studio will show information messages saying it could not find schema information like it did when the EDMX file was opened in XML Editor.

CREATED RELEASE: Sample EDMX Code Generator V1.0 (Jan 24, 2008)

Thu, 24 Jan 2008 19:03:39 GMT

Works with Visual Studio 2008 RTM, Entity Framework Beta 3 and Entity Framework Tools CTP 2.

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 19:01:36 GMT

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

Build

Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

Register

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command: gacutil /i <full path to SampleEdmxCodeGenerator.dll>
Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008: reg import <full path to RegisterWithVS.reg> NOTE: RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.

Unregister

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command: gacutil /u SampleEdmxCodeGenerator
Next, type the following commands exactly as they appear to unregister SampleEdmxCodeGenerator with Visual Studio 2008:

Test

The SampleEdmxCodeGenerator sources folder has file called SampleModel.edmx that you can use for basic sniff test purposes.

Process an EDMX file with SampleEdmxCodeGenerator

Add and edit CSDL annotations

Since the ADO.NET Entity Designer has no support to visually add or edit CSDL annotations you’ll need to open the EDMX file in XML Editor to do this. This is easy enough to do as follows:

Right-click on the EDMX file in Solution Explorer and choose “Open With…”
Click on “XML Editor” in the “Open With” dialog box
Click OK
The EDMX file opens in XML Editor instead of the ADO.NET Entity Designer
If you prefer, you can reformat the XML document to make it more legible by pressing Ctrl+A and clicking on the “Reformat Selection” button on the XML Editor toolbar

Open an EDMX file with CSDL annotations in the designer

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 19:00:23 GMT

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

Build

Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

Register

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command: gacutil /i <full path to SampleEdmxCodeGenerator.dll>
Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008: reg import <full path to RegisterWithVS.reg> NOTE: RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.

Unregister

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command: gacutil /u SampleEdmxCodeGenerator
Next, type the following commands exactly as they appear to unregister SampleEdmxCodeGenerator with Visual Studio 2008: reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\CLSID\{322EB3BE-19FB-4B6D-9370-1A6474C60D00}

reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{FAE04EC1-301F-11D3-BF4B-00C04F79EFBC} \SampleEdmxCodeGenerator
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{164B10B9-B200-11D0-8C61-00A0C91E29D5}\SampleEdmxCodeGenerator

Test

The SampleEdmxCodeGenerator sources folder has file called SampleModel.edmx that you can use for basic sniff test purposes.

Process an EDMX file with SampleEdmxCodeGenerator

As you probably noticed by now, an EDMX file’s “Custom Tool” property is set to EntityModelCodeGenerator. Making Visual Studio use SampleEdmxCodeGenerator is pretty simple: select the EDMX file in Solution Explorer and type SampleEdmxCodeGenerator as the “Custom Tool” property value.
Visual Studio will immediately run SampleEdmxCodeGenerator to process the EDMX file. You can force Visual Studio to call SampleEdmxCodeGenerator to process the EDMX contents by right-clicking the EDMX file in Solution Explorer and choosing “Run Custom Tool”.
EntityModelCodeGenerator and SampleEdmxCodeGenerator can live side-by-side with each other. For example, you can have 2 EDMX files in the same project with the “Custom Tool” for one set to EntityModelCodeGenerator and other set to SampleEdmxCodeGenerator.

Add and edit CSDL annotations

Since the ADO.NET Entity Designer has no support to visually add or edit CSDL annotations you’ll need to open the EDMX file in XML Editor to do this. This is easy enough to do as follows:

Right-click on the EDMX file in Solution Explorer and choose “Open With…”
Click on “XML Editor” in the “Open With” dialog box
Click OK
The EDMX file opens in XML Editor instead of the ADO.NET Entity Designer
If you prefer, you can reformat the XML document to make it more legible by pressing Ctrl+A and clicking on the “Reformat Selection” button on the XML Editor toolbar

While the ADO.NET Entity Designer doesn’t support it, you could easily imagine a Visual Studio Addin that shows CSDL annotations in a nice GUI and lets you edit them outside of the designer.
When an EDMX file with CSDL annotations is opened in XML Editor, Visual Studio will show information messages saying something like:
Could not find schema information for the attribute 'http://tempuri.org/SampleAnnotations:ClrAttributes'
These messages can be safely ignored but if you really care then you can create an XSD for your custom namespace and copy the XSD into %vsinstalldir%\Xml\Schemas. Doing this not only gets rid of the messages but you also get intellisense when you type CSDL annotations in XML Editor.
The parsing logic in SampleEdmxCodeGenerator is pretty simplistic and expects multiple CLR attributes to be separated by ‘;’ and only supports string and bool attribute parameters. You could easily extend the sample to work with more complicated constructs.
As soon as you make a change to the EDMX file, Visual Studio will call SampleEdmxCodeGenerator to process the EDMX contents which will immediately generate classes with the appropriate CLR attributes.

Open an EDMX file with CSDL annotations in the designer

The ADO.NET Entity Designer has no support to visually add or edit CSDL annotations. However, the designer preserves any existing CSDL annotations in the EDMX file and the file is rendered properly.
Thus, it is possible to open an EDMX file in the designer even when it contains CSDL annotations and even when it’s “Custom Tool” property is set to SampleEdmxCodeGenerator. One side-effect of this is classes for any new entities created via the designer will be generated by SampleEdmxCodeGenerator. This may be ok as long as you are aware this is happening under the covers.
When an EDMX file with CSDL annotations is opened in the ADO.NET Entity Designer, Visual Studio will show information messages saying it could not find schema information like it did when the EDMX file was opened in XML Editor.

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 18:56:18 GMT

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

Build

Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

Register

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command: gacutil /i <full path to SampleEdmxCodeGenerator.dll>
Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008: reg import <full path to RegisterWithVS.reg>

NOTE: RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.

Unregister

Unregistering SampleEdmxCodeGenerator is pretty much the reverse of the registration operation. If you plan to register and unregister often, it may be a good idea to create a batch file with these steps to make this easier.
1. Exit Visual Studio 2008 if it is running
2. Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools
NOTE: Run as Administrator if running on Windows Vista.
3. Type the following command:
gacutil /u SampleEdmxCodeGenerator
4. Next, type the following commands exactly as they appear to unregister SampleEdmxCodeGenerator with Visual Studio 2008:
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\CLSID\{322EB3BE-19FB-4B6D-9370-1A6474C60D00}
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{FAE04EC1-301F-11D3-BF4B-00C04F79EFBC}\SampleEdmxCodeGenerator
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{164B10B9-B200-11D0-8C61-00A0C91E29D5}\SampleEdmxCodeGenerator
Test
The SampleEdmxCodeGenerator sources folder has file called SampleModel.edmx that you can use for basic sniff test purposes.
Process an EDMX file with SampleEdmxCodeGenerator
As you probably noticed by now, an EDMX file’s “Custom Tool” property is set to EntityModelCodeGenerator. Making Visual Studio use SampleEdmxCodeGenerator is pretty simple: select the EDMX file in Solution Explorer and type SampleEdmxCodeGenerator as the “Custom Tool” property value.
Visual Studio will immediately run SampleEdmxCodeGenerator to process the EDMX file. You can force Visual Studio to call SampleEdmxCodeGenerator to process the EDMX contents by right-clicking the EDMX file in Solution Explorer and choosing “Run Custom Tool”.
EntityModelCodeGenerator and SampleEdmxCodeGenerator can live side-by-side with each other. For example, you can have 2 EDMX files in the same project with the “Custom Tool” for one set to EntityModelCodeGenerator and other set to SampleEdmxCodeGenerator.
Add and edit CSDL annotations
Since the ADO.NET Entity Designer has no support to visually add or edit CSDL annotations you’ll need to open the EDMX file in XML Editor to do this. This is easy enough to do as follows:
1. Right-click on the EDMX file in Solution Explorer and choose “Open With…”
2. Click on “XML Editor” in the “Open With” dialog box
3. Click OK
4. The EDMX file opens in XML Editor instead of the ADO.NET Entity Designer
5. If you prefer, you can reformat the XML document to make it more legible by pressing Ctrl+A and clicking on the “Reformat Selection” button on the XML Editor toolbar
While the ADO.NET Entity Designer doesn’t support it, you could easily imagine a Visual Studio Addin that shows CSDL annotations in a nice GUI and lets you edit them outside of the designer.
When an EDMX file with CSDL annotations is opened in XML Editor, Visual Studio will show information messages saying something like:
Could not find schema information for the attribute 'http://tempuri.org/SampleAnnotations:ClrAttributes'.
These messages can be safely ignored but if you really care then you can create an XSD for your custom namespace and copy the XSD into %vsinstalldir%\Xml\Schemas. Doing this not only gets rid of the messages but you also get intellisense when you type CSDL annotations in XML Editor.
The parsing logic in SampleEdmxCodeGenerator is pretty simplistic and expects multiple CLR attributes to be separated by ‘;’ and only supports string and bool attribute parameters. You could easily extend the sample to work with more complicated constructs.
As soon as you make a change to the EDMX file, Visual Studio will call SampleEdmxCodeGenerator to process the EDMX contents which will immediately generate classes with the appropriate CLR attributes.
Open an EDMX file with CSDL annotations in the designer
The ADO.NET Entity Designer has no support to visually add or edit CSDL annotations. However, the designer preserves any existing CSDL annotations in the EDMX file and the file is rendered properly.
Thus, it is possible to open an EDMX file in the designer even when it contains CSDL annotations and even when it’s “Custom Tool” property is set to SampleEdmxCodeGenerator. One side-effect of this is classes for any new entities created via the designer will be generated by SampleEdmxCodeGenerator. This may be ok as long as you are aware this is happening under the covers.
When an EDMX file with CSDL annotations is opened in the ADO.NET Entity Designer, Visual Studio will show information messages saying it could not find schema information like it did when the EDMX file was opened in XML Editor.

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 18:55:36 GMT

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

Build

Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

Register

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command: gacutil /i <full path to SampleEdmxCodeGenerator.dll>
Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008:

reg import <full path to RegisterWithVS.reg>
NOTE: RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.

Unregister

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 18:53:41 GMT

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

Build

Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

Register

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command:

Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008:

reg import <full path to RegisterWithVS.reg>
NOTE: RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.

Unregister

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 18:52:34 GMT

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

Build

Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

Register

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command:

//single line
gacutil /i <full path to SampleEdmxCodeGenerator.dll>
}}

Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008:

reg import <full path to RegisterWithVS.reg>
NOTE: RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.

Unregister

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 18:51:35 GMT

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

Build

Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

Register

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command:

{{ gacutil /i <full path to SampleEdmxCodeGenerator.dll>
# Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008:
reg import <full path to RegisterWithVS.reg>
*NOTE:* RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.

!!!! Unregister
Unregistering SampleEdmxCodeGenerator is pretty much the reverse of the registration operation. If you plan to register and unregister often, it may be a good idea to create a batch file with these steps to make this easier.
1. Exit Visual Studio 2008 if it is running
2. Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools
NOTE: Run as Administrator if running on Windows Vista.
3. Type the following command:
gacutil /u SampleEdmxCodeGenerator
4. Next, type the following commands exactly as they appear to unregister SampleEdmxCodeGenerator with Visual Studio 2008:
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\CLSID\{322EB3BE-19FB-4B6D-9370-1A6474C60D00}
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{FAE04EC1-301F-11D3-BF4B-00C04F79EFBC}\SampleEdmxCodeGenerator
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{164B10B9-B200-11D0-8C61-00A0C91E29D5}\SampleEdmxCodeGenerator
Test
The SampleEdmxCodeGenerator sources folder has file called SampleModel.edmx that you can use for basic sniff test purposes.
Process an EDMX file with SampleEdmxCodeGenerator
As you probably noticed by now, an EDMX file’s “Custom Tool” property is set to EntityModelCodeGenerator. Making Visual Studio use SampleEdmxCodeGenerator is pretty simple: select the EDMX file in Solution Explorer and type SampleEdmxCodeGenerator as the “Custom Tool” property value.
Visual Studio will immediately run SampleEdmxCodeGenerator to process the EDMX file. You can force Visual Studio to call SampleEdmxCodeGenerator to process the EDMX contents by right-clicking the EDMX file in Solution Explorer and choosing “Run Custom Tool”.
EntityModelCodeGenerator and SampleEdmxCodeGenerator can live side-by-side with each other. For example, you can have 2 EDMX files in the same project with the “Custom Tool” for one set to EntityModelCodeGenerator and other set to SampleEdmxCodeGenerator.
Add and edit CSDL annotations
Since the ADO.NET Entity Designer has no support to visually add or edit CSDL annotations you’ll need to open the EDMX file in XML Editor to do this. This is easy enough to do as follows:
1. Right-click on the EDMX file in Solution Explorer and choose “Open With…”
2. Click on “XML Editor” in the “Open With” dialog box
3. Click OK
4. The EDMX file opens in XML Editor instead of the ADO.NET Entity Designer
5. If you prefer, you can reformat the XML document to make it more legible by pressing Ctrl+A and clicking on the “Reformat Selection” button on the XML Editor toolbar
While the ADO.NET Entity Designer doesn’t support it, you could easily imagine a Visual Studio Addin that shows CSDL annotations in a nice GUI and lets you edit them outside of the designer.
When an EDMX file with CSDL annotations is opened in XML Editor, Visual Studio will show information messages saying something like:
Could not find schema information for the attribute 'http://tempuri.org/SampleAnnotations:ClrAttributes'.
These messages can be safely ignored but if you really care then you can create an XSD for your custom namespace and copy the XSD into %vsinstalldir%\Xml\Schemas. Doing this not only gets rid of the messages but you also get intellisense when you type CSDL annotations in XML Editor.
The parsing logic in SampleEdmxCodeGenerator is pretty simplistic and expects multiple CLR attributes to be separated by ‘;’ and only supports string and bool attribute parameters. You could easily extend the sample to work with more complicated constructs.
As soon as you make a change to the EDMX file, Visual Studio will call SampleEdmxCodeGenerator to process the EDMX contents which will immediately generate classes with the appropriate CLR attributes.
Open an EDMX file with CSDL annotations in the designer
The ADO.NET Entity Designer has no support to visually add or edit CSDL annotations. However, the designer preserves any existing CSDL annotations in the EDMX file and the file is rendered properly.
Thus, it is possible to open an EDMX file in the designer even when it contains CSDL annotations and even when it’s “Custom Tool” property is set to SampleEdmxCodeGenerator. One side-effect of this is classes for any new entities created via the designer will be generated by SampleEdmxCodeGenerator. This may be ok as long as you are aware this is happening under the covers.
When an EDMX file with CSDL annotations is opened in the ADO.NET Entity Designer, Visual Studio will show information messages saying it could not find schema information like it did when the EDMX file was opened in XML Editor.

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 18:44:59 GMT

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

Build

Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

Register

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command: {{ gacutil /i <full path to SampleEdmxCodeGenerator.dll>

# Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008:
reg import <full path to RegisterWithVS.reg>
*NOTE:* RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.

!!!! Unregister
Unregistering SampleEdmxCodeGenerator is pretty much the reverse of the registration operation. If you plan to register and unregister often, it may be a good idea to create a batch file with these steps to make this easier.
1. Exit Visual Studio 2008 if it is running
2. Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools
NOTE: Run as Administrator if running on Windows Vista.
3. Type the following command:
gacutil /u SampleEdmxCodeGenerator
4. Next, type the following commands exactly as they appear to unregister SampleEdmxCodeGenerator with Visual Studio 2008:
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\CLSID\{322EB3BE-19FB-4B6D-9370-1A6474C60D00}
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{FAE04EC1-301F-11D3-BF4B-00C04F79EFBC}\SampleEdmxCodeGenerator
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{164B10B9-B200-11D0-8C61-00A0C91E29D5}\SampleEdmxCodeGenerator
Test
The SampleEdmxCodeGenerator sources folder has file called SampleModel.edmx that you can use for basic sniff test purposes.
Process an EDMX file with SampleEdmxCodeGenerator
As you probably noticed by now, an EDMX file’s “Custom Tool” property is set to EntityModelCodeGenerator. Making Visual Studio use SampleEdmxCodeGenerator is pretty simple: select the EDMX file in Solution Explorer and type SampleEdmxCodeGenerator as the “Custom Tool” property value.
Visual Studio will immediately run SampleEdmxCodeGenerator to process the EDMX file. You can force Visual Studio to call SampleEdmxCodeGenerator to process the EDMX contents by right-clicking the EDMX file in Solution Explorer and choosing “Run Custom Tool”.
EntityModelCodeGenerator and SampleEdmxCodeGenerator can live side-by-side with each other. For example, you can have 2 EDMX files in the same project with the “Custom Tool” for one set to EntityModelCodeGenerator and other set to SampleEdmxCodeGenerator.
Add and edit CSDL annotations
Since the ADO.NET Entity Designer has no support to visually add or edit CSDL annotations you’ll need to open the EDMX file in XML Editor to do this. This is easy enough to do as follows:
1. Right-click on the EDMX file in Solution Explorer and choose “Open With…”
2. Click on “XML Editor” in the “Open With” dialog box
3. Click OK
4. The EDMX file opens in XML Editor instead of the ADO.NET Entity Designer
5. If you prefer, you can reformat the XML document to make it more legible by pressing Ctrl+A and clicking on the “Reformat Selection” button on the XML Editor toolbar
While the ADO.NET Entity Designer doesn’t support it, you could easily imagine a Visual Studio Addin that shows CSDL annotations in a nice GUI and lets you edit them outside of the designer.
When an EDMX file with CSDL annotations is opened in XML Editor, Visual Studio will show information messages saying something like:
Could not find schema information for the attribute 'http://tempuri.org/SampleAnnotations:ClrAttributes'.
These messages can be safely ignored but if you really care then you can create an XSD for your custom namespace and copy the XSD into %vsinstalldir%\Xml\Schemas. Doing this not only gets rid of the messages but you also get intellisense when you type CSDL annotations in XML Editor.
The parsing logic in SampleEdmxCodeGenerator is pretty simplistic and expects multiple CLR attributes to be separated by ‘;’ and only supports string and bool attribute parameters. You could easily extend the sample to work with more complicated constructs.
As soon as you make a change to the EDMX file, Visual Studio will call SampleEdmxCodeGenerator to process the EDMX contents which will immediately generate classes with the appropriate CLR attributes.
Open an EDMX file with CSDL annotations in the designer
The ADO.NET Entity Designer has no support to visually add or edit CSDL annotations. However, the designer preserves any existing CSDL annotations in the EDMX file and the file is rendered properly.
Thus, it is possible to open an EDMX file in the designer even when it contains CSDL annotations and even when it’s “Custom Tool” property is set to SampleEdmxCodeGenerator. One side-effect of this is classes for any new entities created via the designer will be generated by SampleEdmxCodeGenerator. This may be ok as long as you are aware this is happening under the covers.
When an EDMX file with CSDL annotations is opened in the ADO.NET Entity Designer, Visual Studio will show information messages saying it could not find schema information like it did when the EDMX file was opened in XML Editor.

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 18:42:41 GMT

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

Build

Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

Register

Exit Visual Studio 2008 if it is running
Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools NOTE: Run as Administrator if running on Windows Vista.
Type the following command:

gacutil /i <full path to SampleEdmxCodeGenerator.dll>

Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008:

reg import <full path to RegisterWithVS.reg>
NOTE: RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.

Unregister

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 18:40:14 GMT

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

Build

Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

!!Register
Building the project does not register SampleEdmxCodeGenerator with Visual Studio; you should do this manually. If you plan to register and unregister often, it may be a good idea to create a batch file with these steps to make this easier.
1. Exit Visual Studio 2008 if it is running
2. Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools
NOTE: Run as Administrator if running on Windows Vista.
3. Type the following command:
gacutil /i <full path to SampleEdmxCodeGenerator.dll>
4. Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008:
reg import <full path to RegisterWithVS.reg>
NOTE: RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.
Unregister
Unregistering SampleEdmxCodeGenerator is pretty much the reverse of the registration operation. If you plan to register and unregister often, it may be a good idea to create a batch file with these steps to make this easier.
1. Exit Visual Studio 2008 if it is running
2. Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools
NOTE: Run as Administrator if running on Windows Vista.
3. Type the following command:
gacutil /u SampleEdmxCodeGenerator
4. Next, type the following commands exactly as they appear to unregister SampleEdmxCodeGenerator with Visual Studio 2008:
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\CLSID\{322EB3BE-19FB-4B6D-9370-1A6474C60D00}
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{FAE04EC1-301F-11D3-BF4B-00C04F79EFBC}\SampleEdmxCodeGenerator
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{164B10B9-B200-11D0-8C61-00A0C91E29D5}\SampleEdmxCodeGenerator
Test
The SampleEdmxCodeGenerator sources folder has file called SampleModel.edmx that you can use for basic sniff test purposes.
Process an EDMX file with SampleEdmxCodeGenerator
As you probably noticed by now, an EDMX file’s “Custom Tool” property is set to EntityModelCodeGenerator. Making Visual Studio use SampleEdmxCodeGenerator is pretty simple: select the EDMX file in Solution Explorer and type SampleEdmxCodeGenerator as the “Custom Tool” property value.
Visual Studio will immediately run SampleEdmxCodeGenerator to process the EDMX file. You can force Visual Studio to call SampleEdmxCodeGenerator to process the EDMX contents by right-clicking the EDMX file in Solution Explorer and choosing “Run Custom Tool”.
EntityModelCodeGenerator and SampleEdmxCodeGenerator can live side-by-side with each other. For example, you can have 2 EDMX files in the same project with the “Custom Tool” for one set to EntityModelCodeGenerator and other set to SampleEdmxCodeGenerator.
Add and edit CSDL annotations
Since the ADO.NET Entity Designer has no support to visually add or edit CSDL annotations you’ll need to open the EDMX file in XML Editor to do this. This is easy enough to do as follows:
1. Right-click on the EDMX file in Solution Explorer and choose “Open With…”
2. Click on “XML Editor” in the “Open With” dialog box
3. Click OK
4. The EDMX file opens in XML Editor instead of the ADO.NET Entity Designer
5. If you prefer, you can reformat the XML document to make it more legible by pressing Ctrl+A and clicking on the “Reformat Selection” button on the XML Editor toolbar
While the ADO.NET Entity Designer doesn’t support it, you could easily imagine a Visual Studio Addin that shows CSDL annotations in a nice GUI and lets you edit them outside of the designer.
When an EDMX file with CSDL annotations is opened in XML Editor, Visual Studio will show information messages saying something like:
Could not find schema information for the attribute 'http://tempuri.org/SampleAnnotations:ClrAttributes'.
These messages can be safely ignored but if you really care then you can create an XSD for your custom namespace and copy the XSD into %vsinstalldir%\Xml\Schemas. Doing this not only gets rid of the messages but you also get intellisense when you type CSDL annotations in XML Editor.
The parsing logic in SampleEdmxCodeGenerator is pretty simplistic and expects multiple CLR attributes to be separated by ‘;’ and only supports string and bool attribute parameters. You could easily extend the sample to work with more complicated constructs.
As soon as you make a change to the EDMX file, Visual Studio will call SampleEdmxCodeGenerator to process the EDMX contents which will immediately generate classes with the appropriate CLR attributes.
Open an EDMX file with CSDL annotations in the designer
The ADO.NET Entity Designer has no support to visually add or edit CSDL annotations. However, the designer preserves any existing CSDL annotations in the EDMX file and the file is rendered properly.
Thus, it is possible to open an EDMX file in the designer even when it contains CSDL annotations and even when it’s “Custom Tool” property is set to SampleEdmxCodeGenerator. One side-effect of this is classes for any new entities created via the designer will be generated by SampleEdmxCodeGenerator. This may be ok as long as you are aware this is happening under the covers.
When an EDMX file with CSDL annotations is opened in the ADO.NET Entity Designer, Visual Studio will show information messages saying it could not find schema information like it did when the EDMX file was opened in XML Editor.

UPDATED WIKI: Home

elisaf_MSFT — Thu, 24 Jan 2008 18:39:48 GMT

Building and deploying

NOTE: You don’t need to install the Visual Studio 2008 SDK to use this sample.

!!Build
#Download and unzip SampleEdmxCodeGenerator.zip to a folder on your hard disk.
#Start Visual Studio 2008 and open SampleEdmxCodeGenerator.sln
#Build the solution to get SampleEdmxCodeGenerator.dll in the project output directory

!!Register
Building the project does not register SampleEdmxCodeGenerator with Visual Studio; you should do this manually. If you plan to register and unregister often, it may be a good idea to create a batch file with these steps to make this easier.
1. Exit Visual Studio 2008 if it is running
2. Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools
NOTE: Run as Administrator if running on Windows Vista.
3. Type the following command:
gacutil /i <full path to SampleEdmxCodeGenerator.dll>
4. Next, type the following command to register SampleEdmxCodeGenerator with Visual Studio 2008:
reg import <full path to RegisterWithVS.reg>
NOTE: RegisterWithVS.reg is in the same folder as the SampleEdmxCodeGenerator sources.
Unregister
Unregistering SampleEdmxCodeGenerator is pretty much the reverse of the registration operation. If you plan to register and unregister often, it may be a good idea to create a batch file with these steps to make this easier.
1. Exit Visual Studio 2008 if it is running
2. Start a Visual Studio 2008 Command Prompt available from Start  All Programs  Visual Studio 2008  Visual Studio Tools
NOTE: Run as Administrator if running on Windows Vista.
3. Type the following command:
gacutil /u SampleEdmxCodeGenerator
4. Next, type the following commands exactly as they appear to unregister SampleEdmxCodeGenerator with Visual Studio 2008:
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\CLSID\{322EB3BE-19FB-4B6D-9370-1A6474C60D00}
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{FAE04EC1-301F-11D3-BF4B-00C04F79EFBC}\SampleEdmxCodeGenerator
reg delete HKLM\SOFTWARE\Microsoft\VisualStudio\9.0\Generators\{164B10B9-B200-11D0-8C61-00A0C91E29D5}\SampleEdmxCodeGenerator
Test
The SampleEdmxCodeGenerator sources folder has file called SampleModel.edmx that you can use for basic sniff test purposes.
Process an EDMX file with SampleEdmxCodeGenerator
As you probably noticed by now, an EDMX file’s “Custom Tool” property is set to EntityModelCodeGenerator. Making Visual Studio use SampleEdmxCodeGenerator is pretty simple: select the EDMX file in Solution Explorer and type SampleEdmxCodeGenerator as the “Custom Tool” property value.
Visual Studio will immediately run SampleEdmxCodeGenerator to process the EDMX file. You can force Visual Studio to call SampleEdmxCodeGenerator to process the EDMX contents by right-clicking the EDMX file in Solution Explorer and choosing “Run Custom Tool”.
EntityModelCodeGenerator and SampleEdmxCodeGenerator can live side-by-side with each other. For example, you can have 2 EDMX files in the same project with the “Custom Tool” for one set to EntityModelCodeGenerator and other set to SampleEdmxCodeGenerator.
Add and edit CSDL annotations
Since the ADO.NET Entity Designer has no support to visually add or edit CSDL annotations you’ll need to open the EDMX file in XML Editor to do this. This is easy enough to do as follows:
1. Right-click on the EDMX file in Solution Explorer and choose “Open With…”
2. Click on “XML Editor” in the “Open With” dialog box
3. Click OK
4. The EDMX file opens in XML Editor instead of the ADO.NET Entity Designer
5. If you prefer, you can reformat the XML document to make it more legible by pressing Ctrl+A and clicking on the “Reformat Selection” button on the XML Editor toolbar
While the ADO.NET Entity Designer doesn’t support it, you could easily imagine a Visual Studio Addin that shows CSDL annotations in a nice GUI and lets you edit them outside of the designer.
When an EDMX file with CSDL annotations is opened in XML Editor, Visual Studio will show information messages saying something like:
Could not find schema information for the attribute 'http://tempuri.org/SampleAnnotations:ClrAttributes'.
These messages can be safely ignored but if you really care then you can create an XSD for your custom namespace and copy the XSD into %vsinstalldir%\Xml\Schemas. Doing this not only gets rid of the messages but you also get intellisense when you type CSDL annotations in XML Editor.
The parsing logic in SampleEdmxCodeGenerator is pretty simplistic and expects multiple CLR attributes to be separated by ‘;’ and only supports string and bool attribute parameters. You could easily extend the sample to work with more complicated constructs.
As soon as you make a change to the EDMX file, Visual Studio will call SampleEdmxCodeGenerator to process the EDMX contents which will immediately generate classes with the appropriate CLR attributes.
Open an EDMX file with CSDL annotations in the designer
The ADO.NET Entity Designer has no support to visually add or edit CSDL annotations. However, the designer preserves any existing CSDL annotations in the EDMX file and the file is rendered properly.
Thus, it is possible to open an EDMX file in the designer even when it contains CSDL annotations and even when it’s “Custom Tool” property is set to SampleEdmxCodeGenerator. One side-effect of this is classes for any new entities created via the designer will be generated by SampleEdmxCodeGenerator. This may be ok as long as you are aware this is happening under the covers.
When an EDMX file with CSDL annotations is opened in the ADO.NET Entity Designer, Visual Studio will show information messages saying it could not find schema information like it did when the EDMX file was opened in XML Editor.