Click here to Skip to main content
15,896,557 members
Articles / Programming Languages / C#

Dynamically Generate C# Data Access Code for Microsoft SQL and Other Databases

Rate me:
Please Sign up or sign in to vote.
3.45/5 (13 votes)
19 Dec 2008CDDL3 min read 76.7K   1.5K   76  
With this tool, dynamically generate C# data layer code (CRUD functions) for Microsoft SQL and other databases
/*
 ******************************************************************************
 This file is part of MattRaffelNetCode.

    MattRaffelNetCode is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    MattRaffelNetCode is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with MattRaffelNetCode; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA


    architected and written by 
    matt raffel 
    matt.raffel@mindspring.com

       copyright (c) 2007 by matt raffel unless noted otherwise

 ******************************************************************************
*/
#region using statements
using System;
using System.Collections.Generic;
using System.Text;
#endregion

namespace MattRaffelNetCode.Apps.SqlCodeGen
{
    /// <summary>
    /// if the ? was encountered in the command line, this exception will be thrown
    /// and need to be caught at the program main execution point
    /// </summary>
    internal class HelpException : Exception {}

    /// <summary>
    /// if the command line arguments are invalid in any way (format or missing)
    /// this exception will be thrown and needs to be handled at the 
    /// main exceution point
    /// </summary>
    internal class InvalidCommandLineException : Exception { }

    /// <summary>
    /// Indicates on the commandline that a table was specified but it was not
    /// found in the database
    /// </summary>
    internal class MissingTableException : Exception 
    {
        public MissingTableException(string msg) : base(msg) { }
    }
    
    /// <summary>
    /// exceptions of this nature mean that the program attempted to do something
    /// that made no sense and other mechanisms for finding this error failed to
    /// catch it.  A good example would be bad data in the configuration file got
    /// past the point of loading the configuration file.  I would think that
    /// this exception raised means the programmer did something wrong
    /// </summary>
    internal class ProgramFlowException : Exception
    {
        public ProgramFlowException(string msg) : base(msg) { }
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Common Development and Distribution License (CDDL)


Written By
Architect
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions