Important alert: (current site time 9/22/2014 9:57:17 PM EDT)
 

winzip icon

C# Class and Stored Proc Generator

Email
Submitted on: 3/23/2012 4:33:40 PM
By: cyplesma 
Level: Intermediate
User Rating: By 1 Users
Compatibility: C#
Views: 5938
 
     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

 
winzip iconDownload code

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:
  1. Re-scan downloaded files using your personal virus checker before using it.
  2. 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 including:McAfee.com

 
Terms of Agreement:   
By using this code, you agree to the following terms...   
  1. 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.
  2. 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.   
  3. You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
  4. You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


Other 5 submission(s) by this author

 


Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:

Your Vote

What do you think of this code (in the Intermediate category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor (See voting log ...)
 

Other User Comments


 There are no comments on this submission.
 

Add Your Feedback
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.)
 

To post feedback, first please login.