Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 C# Generator

Author  Topic 

Onamuji
Aged Yak Warrior

504 Posts

Posted - 2002-05-16 : 10:44:21
The VB code was ok if you wanted it to be basic but when I was using it and trying to get it to work into my project it was quite painful. So in retrospect I have gone back to C# ... so I can have operator overloading plus smaller code anyhow ... will post here new routine ... working on one that will convert a stored procedure to a function as well...
...
I still have the old code if anyone is interested, but like I said ... it's not very robust and getting it there in VB.NET just was a bigger pain than I need at the moment ...

Edited by - onamuji on 05/23/2002 13:05:52

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-05-16 : 11:31:27
SWEET!

I do have one request though: if you are a code indenter, and you're gonna use the [ code ] tags on SQL Team, PLEASE break the lines in your code.

I'm running at 1280x960, and I STILL have to scroll to read everything.

Go to Top of Page

Onamuji
Aged Yak Warrior

504 Posts

Posted - 2002-05-23 : 13:05:38
This script will convert each table into a C# struct with the columns of the table being properties. It should work most of the time unless you have weird naming standards... but this is definitely helpful for create a type that represents a row of data ... i will post help scripts here in the future...

http://www.notevil.net/scripts/sql/SQL0001.sql



Go to Top of Page
   

- Advertisement -