Search results matching tag 'Utah Code Camp'

LINQ to Entities Example Queries

NathanZaugg — Sun, 02 Nov 2008 23:06:00 GMT

Here are the examples I used during my LINQ to Entities presentation. They show how to use the EntityClient, ObjectQuery, and LINQ to Entities queries. All examples are built using a 1:1 mapping to the Adventure Works database that had been slightly modified. The Object Services with Lazy Loading Example shows some how to debug these queries.

Entity Client Example

// Entity Client & Entity SQL
using (EntityConnection conn = 
       new EntityConnection("Name=AdventureWorksEntities")) {
    conn.Open();
    EntityCommand cmd = conn.CreateCommand();
    cmd.CommandText = "SELECT VALUE c FROM 
           AdventureWorksEntities.Customer AS 
            c WHERE c.State = @state";
    cmd.Parameters.AddWithValue("state", "UT");

    DbDataReader rdr = cmd.ExecuteReader(
          CommandBehavior.SequentialAccess);
    while (rdr.Read()) {
        Console.WriteLine(string.Format("Company Name: 
              {0}\tCompany City: {1}", 
              rdr["CompanyName"], rdr["City"]));
    }
}

Object Services Query Example

// Object Services & Entity SQL
using (AdventureWorksEntities data = 
     new AdventureWorksEntities()) {
    ObjectQuery<Customer> custs = data.CreateQuery<Customer>(
        "SELECT VALUE c FROM Customer AS c WHERE c.Address.City = @city", 
        new ObjectParameter("city", "Salt Lake City"));

    foreach (Customer cust in custs) {
        Console.WriteLine("Company: " + cust.CompanyName);
    }
}

Object Services Query with Eager Loading Example

// Eager Loading with Object Services
using (AdventureWorksEntities data = new AdventureWorksEntities()) {
    ObjectQuery<Customer> custs = data.CreateQuery<Customer>(
        "SELECT VALUE c FROM Customer AS c WHERE c.State = @state",
        new ObjectParameter("state", "UT")).Include("SalesOrderHeader");


    foreach (Customer cust in custs) {
        SalesOrderHeader sales = cust.SalesOrderHeader.FirstOrDefault();
        string str = (sales == null) ? "none" : sales.OrderDate
             .ToShortDateString();
        Console.WriteLine(
            string.Format("Company: {0}\tOrder: {1}", 
                 cust.CompanyName, str));
    }
}

Object Services Query with Lazy Loading Example

// Lazy Loading with Object Services
using (AdventureWorksEntities data = new AdventureWorksEntities()) {
    ObjectQuery<Customer> custs = data.CreateQuery<Customer>(
        "SELECT VALUE c FROM Customer AS c WHERE c.State = @state",
        new ObjectParameter("state", "UT"));

    Console.WriteLine("DEBUG: " + custs.ToTraceString());

    foreach (Customer cust in custs) {
        if (!cust.SalesOrderHeader.IsLoaded)
            cust.SalesOrderHeader.Load();

        SalesOrderHeader sales = cust.SalesOrderHeader.FirstOrDefault();
        string str = (sales == null) ? "none" : sales.OrderDate
               .ToShortDateString();
        Console.WriteLine(
            string.Format("Company: {0}\tOrder: {1}", 
            cust.CompanyName, str));
    }
}

LINQ to Entities Query Example

// LINQ to ENTIES (Lazy Loading)
using (AdventureWorksEntities data = new AdventureWorksEntities()) {

    var custquery = from d in data.Customer
                where d.State == "UT"
                select d;

    foreach (Customer cust in custquery) {
        if ( !cust.SalesOrderHeader.IsLoaded )
            cust.SalesOrderHeader.Load();
        SalesOrderHeader sales = cust.SalesOrderHeader
                .FirstOrDefault();
        string str = (sales == null) ? "none" : sales.OrderDate
               .ToShortDateString();
        Console.WriteLine(
            string.Format("Company: {0}\tOrder: {1}", 
             cust.CompanyName, str));
    }
}

The presentation slides are available here.

Fall 2008 Utah Code Camp Announcement

NathanZaugg — Tue, 07 Oct 2008 22:57:33 GMT

Another six months have come and gone and it's time for another Utah Code Camp! I can't believe how quickly this sneaks up on me every time! For those in the area Code Camp is a high quality, free training event! The topics range greatly from Microsoft, Java, Ruby, XBOX & Wii Development, Agile, Project Management, etc.. These presentations are by developers for developers and allows you to catch up on the sea of new technology that continually floods us. More on the Code Camp Manifesto can be found here.

Before I share the details I would appreciate any feedback on a good topic to present. I haven't replied with a topic yet and I'll need to get one soon so I can get started on the presentation. Previously I have presented on .NET 3.5 / VS 2008, WPF, and Silverlight 2. A big topic in MSDN magazine these days seems to be parrallism, but that topic feels rather dry to me. Other ideas I have had were LINQ in Depth, DSL Tools, F# (though I hope someone else does this one), or WPF for Newbs.

Here are the specifics:

When: Saturday November 1, 2008
Where: Neumont University, Building 2, 2nd Floor (directions)

We are also always looking for sponsors. It takes a lot to put on this event and contributions help a lot! For more information about sponsorship, please visit http://www.utcodecamp.com

XAML Cheat Sheet

NathanZaugg — Thu, 29 May 2008 04:33:05 GMT

A few weeks ago I gave a presentation on Silverlight at the Utah Code Camp. I was really impressed by a presentation I saw last time on Ruby and everyone really liked the cheat sheet that was provided. For my presentation this year I created an XAML Cheat Sheet. For those who are learning XAML it is a pretty good resource but it's most helpful for me when I know how to do something but I can't remember the syntax. This is a work in progress so keep on checking back. It can be downloaded in the Media section of this site or by clicking here.

Please drop me a line if you think you have something useful to add or you want to thank me for the hard work it took to put this thing together!

Nathan Zaugg

Utah Code Camp :: Spring 2008 Announcement

admin — Tue, 22 Apr 2008 19:07:00 GMT

I have been doing Code Camp for over a year now (that may not seem like a lot but this will be my 3rd time presenting there). Code Camp is awesome! It's a full day of free training in a verity of topics that most developers find interesting.

Topics Include:

Silverlight 2.0
Building websites with the ASP.NET MVC framework
C# 3.0
Writing Manageable Services in .NET
Database Performance tuning Part 1
IronRuby + C# = Awesomeness
Game Development in XNA for the Xbox360
Introduction to Mac OS X programming using Cocoa and Objective C
Developing For Windows Vista
T-Sql Querying
Why C# Namespaces are not the same as Java Packages
An Introduction to CakePHP

You can visit http://www.utcodecamp.com for more information (Yes, I know I put the Microsoft technologies first -- I'm an unpaid unofficial self-proclaimed Microsoft Technologies Evangelist!). Wither you are just starting out in your career or have been doing this stuff for years you will get something out of Code Camp! It's not one of those Microsoft "For developers" class sessions where it's just a giant power point and you didn't get any real substance! In fact, that is part of the Code Camp Manifesto (http://blogs.msdn.com/trobbins/archive/2004/12/12/280181.aspx)

Information:

Date: April 26, 2008 (This Saturday)
Time: 9:00AM - 5:00PM
Please register here.

I will be doing the Silverlight 2.0 presentation so please come!!

Thanks!
Nathan Zaugg