I made this program to generate C# class and MS SQL stored procedures for a MS SQL table. I did use some things I found on the internet to help out. There is a MS SQL script that will create a database, a table in that database and fill that database with the data I use for this program. The table I got from someone else, but I did add a few fields to it to help me get the class generator to work the way I wanted to. You will find the program to work best if you set primary keys on the fields you will be doing your look ups on. There is a section in the program that will create a VB.net class but there are few things it is missing compared to the c# section. I also have a splash screen in this program that will go away when the program shows it's form. The first thing the program does is search the local pc/network the PC is on for any MS SQL servers in can find. This may take a few seconds so I added the splash screen, when the main form has found the SQL servers will close the splash screen and show it self. The SQL servers do have to have their SQL browser service running to be found by the code that does the searching.
Made a few modifications: you won't see the blocks in place of a newline character, use Environment.NewLine instead of "\n". Also seems getting the primary index fields is a little different between 2008 and 2008, this version should have no problems with either now. Other minor changes as well
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
Re-scan downloaded files using your personal virus checker before using it.
NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net
Terms of Agreement:
By using this code, you agree to the following terms...
You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)