Software solutions for a mobile world

There are various on-line options to create SQL Server Table definitions to C# classes, but I didn't find one in the marketplace, so I decided to write one. You can download it from the Visual Studio marketplace.

It is integrated into Visual Studio, and is easy to use.

First of all, in SSMS, right click on the table, Select Scrpt Table as, Create To, and clipboard. This will copy your create table script to the clipboard.



The clipboard should then contain something like this:-




Then, in Visual Studio, put your cursor where you want the new class to be created and click on Edit>Paste Special>Paste SQL As Classes otr Paste SQL As Binding Classes


At the point where your cursor is placed, the class for your selected table will be created. 


And if you use the Binding option....


Please let us know if you have any suggestions for any improvements.

Contact

M: +44 (0)7860 907493

pete@gui-innovations.com

More

Connections

   

Twitter Feed