Click here to Skip to main content
15,897,371 members
Articles / Web Development / HTML

Signum Framework Tutorials Part 3 - Southwind Load

Rate me:
Please Sign up or sign in to vote.
4.62/5 (7 votes)
21 Nov 2012CPOL23 min read 24.5K   319   10  
In this part we'll write the loading application to move data from Northwind to Southwind.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Signum.Engine.SchemaInfoTables
{
#pragma warning disable 649

   

    [SqlViewName("sys.objects")]
    public class SysObjects : IView
    {
        public int object_id;
        public string name;
    }


    [SqlViewName("sys.tables")]
    public class SysTables : IView
    {
        public string name;
        public int object_id;
    }

    [SqlViewName("sys.views")]
    public class SysViews : IView
    {
        public string name;
        public int object_id;
    }

    [SqlViewName("sys.columns")]
    public class SysColumns : IView
    {
        public string name;
        public int object_id;
        public int column_id;
        public int default_object_id;
        public bool is_nullable;
        public int user_type_id;
        public int max_length;
        public int precision;
        public int scale;
        public bool is_identity; 
    }

    [SqlViewName("sys.types")]
    public class SysTypes : IView
    {
        public int user_type_id;
        public string name;
    }

    [SqlViewName("sys.foreign_keys")]
    public class SysForeignKeys : IView
    {
        public int object_id;
        public string name;
        public int parent_object_id;
        public int referenced_object_id; 
    }

    [SqlViewName("sys.foreign_key_columns")]
    public class SysForeignKeyColumns : IView
    {
        public int constraint_object_id;
        public int constraint_column_id;
        public int parent_object_id;
        public int parent_column_id;
        public int referenced_object_id;
        public int referenced_column_id;
    }

    [SqlViewName("sys.indexes")]
    public class SysIndexes : IView
    {
        public int index_id;
        public string name;
        public int object_id;
        public bool is_unique;
        public bool is_primary_key;
    }

    [SqlViewName("sys.index_columns")]
    public class SysIndexColumn : IView
    {
        public int object_id;
        public int index_id;
        public int column_id;
    }

    [SqlViewName("sys.extended_properties")]
    public class SysExtendedProperties : IView
    {
        public int major_id;
        public string name;
    }

#pragma warning restore 649
}

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 Code Project Open License (CPOL)


Written By
Software Developer (Senior) Signum Software
Spain Spain
I'm Computer Scientist, one of the founders of Signum Software, and the lead developer behind Signum Framework.

www.signumframework.com

I love programming in C#, Linq, Compilers, Algorithms, Functional Programming, Computer Graphics, Maths...

Comments and Discussions