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

mattraffel

Rate me:

3.45/5 (13 votes)

19 Dec 2008CDDL3 min read

76.6K

1.5K

With this tool, dynamically generate C# data layer code (CRUD functions) for Microsoft SQL and other databases

sqlcodegen.src.2008-12-19.zip
- SqlCodeGen
  - alt formatter
  - app
    - app.config
    - Code Generation Classes
    - Default.datatypes
    - Default.names
    - documents
      - addparamwithvalue.cs.snippet
      - data.cs.snippet
      - dataproperty.cs.snippet
      - delete.cs.snippet
      - fullaccess.cs.template
      - insert.cs.snippet
      - property.cs.snippet
      - readaccess.cs.template
      - reader.cs.snippet
      - saved config file additions.txt
      - select.cs.snippet
      - update.cs.snippet
    - General Classes
    - known issues.txt
    - Program Inprovement Thoughts.txt
    - Program.cs
    - Properties
    - SqlCodeGen.csproj
    - SqlCodeGen.csproj.user
  - dependancies
    - Big Woo.NET.dll
  - dll
    - Defaults
      - DefaultMemberNameFormatter.cs
      - SqlTableInquiry.cs
    - Properties
      - AssemblyInfo.cs
    - Public Classes
    - Public Interfaces
    - sqlcodegensupport.csproj
    - sqlcodegensupport.csproj.user
  - sqlcodegen.doc
  - sqlcodegen.sln
  - sqlcodegen.suo

<?xml version='1.0' encoding='utf-8'?>
<SettingsFile xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings" CurrentProfile="(Default)" GeneratedClassNamespace="MattRaffelNetCode.Apps.SqlCodeGen.Properties" GeneratedClassName="Settings">
  <Profiles />
  <Settings>
    <Setting Name="TemplatePath" Type="System.String" Scope="Application">
      <Value Profile="(Default)">d:\temp\templates</Value>
    </Setting>
    <Setting Name="DefaultDataTypesFile" Type="System.String" Scope="Application">
      <Value Profile="(Default)">.\default.datatypes</Value>
    </Setting>
    <Setting Name="ConnectionFormat" Type="System.String" Scope="Application">
      <Value Profile="(Default)">Data Source={0};Initial Catalog={1};Integrated Security=True</Value>
    </Setting>
    <Setting Name="OutputPath" Type="System.String" Scope="Application">
      <Value Profile="(Default)">d:\temp\templates\output</Value>
    </Setting>
    <Setting Name="DefaultNameSpace" Type="System.String" Scope="Application">
      <Value Profile="(Default)">mattraffel.com.CodeGenTest</Value>
    </Setting>
  </Settings>
</SettingsFile>

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

mattraffel

Architect

United States

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

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

License

Comments and Discussions