Click here to Skip to main content
15,885,216 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.4K   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;
using Signum.Engine.Maps;
using Signum.Engine.DynamicQuery;
using System.Reflection;
using Southwind.Entities;
using Signum.Engine;
using Signum.Utilities;
using Signum.Entities;

namespace Southwind.Logic
{
    public static class ProductLogic
    {
        public static void Start(SchemaBuilder sb, DynamicQueryManager dqm)
        {
            if (sb.NotDefined(MethodInfo.GetCurrentMethod()))
            {
                sb.Include<ProductDN>();

                dqm[typeof(ProductDN)] = (from p in Database.Query<ProductDN>()
                                          select new
                                          {
                                              Entity = p.ToLite(),
                                              p.Id,
                                              p.ProductName,
                                              p.Supplier,
                                              p.Category,
                                              p.QuantityPerUnit,
                                              p.UnitPrice,
                                              p.UnitsInStock,
                                              p.Discontinued
                                          }).ToDynamic();

                dqm[ProductQueries.Current] = (from p in Database.Query<ProductDN>()
                                               where !p.Discontinued
                                               select new
                                               {
                                                   Entity = p.ToLite(),
                                                   p.Id,
                                                   p.ProductName,
                                                   p.Supplier,
                                                   p.Category,
                                                   p.QuantityPerUnit,
                                                   p.UnitPrice,
                                                   p.UnitsInStock,
                                               }).ToDynamic();

                dqm[typeof(SupplierDN)] = (from s in Database.Query<SupplierDN>()
                                           select new
                                           {
                                               Entity = s.ToLite(),
                                               s.Id,
                                               s.CompanyName,
                                               s.ContactName,
                                               s.Phone,
                                               s.Fax,
                                               s.HomePage,
                                               s.Address
                                           }).ToDynamic();

                dqm[typeof(CategoryDN)] = (from s in Database.Query<CategoryDN>()
                                           select new
                                           {
                                               Entity = s.ToLite(),
                                               s.Id,
                                               s.CategoryName,
                                               s.Description,
                                           }).ToDynamic(); 

            }
        }
    }
}

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