Tag Archives: LINQ

SCREENCAST: Saving Virtual Earth Polygons to SQL Server 2008

In this screencast, I show you how to draw a polygon on a Virtual Earth map and save it using ASP.NET AJAX, Windows Communication Foundation (WCF), LINQ to SQL, and the new geography data type in SQL Server 2008.

Screencast:

https://channel9.msdn.com/posts/keydet/Saving-Virtual-Earth-Polygons-to-SQL-Server-2008/

Code:

http://cid-1f72da7294089597.skydrive.live.com/embedrow.aspx/Public/Virtual%20Earth/VeWcfSql08

FOLLOW UP: Public Sector Developer Conference (Nashville, TN)

Thanks to everyone who attended.  Sorry about the overflow into the hallways.  There was much less dropoff between registration and attendance than we normally see.  Some of the content isn’t published yet.  Once it is, we’ll make sure to update this post with the appropriate links.

Building Rich Internet Applications Using Microsoft Silverlight 2

Building WPF Applications in Visual Studio 2008 and Expression Blenddeck, code

Data Access with Language Integrated Query

Overview of the .NET Framework 3.5 SP1 & ASP.NET MVC – deck, code

We also mentioned some downloadable tools that folks were interested in using.  Here are the ones I remember:

Visual LINQ (to SQL) Query Builder

LINQPad

If I forgot one, please let me know by posting a comment and I will update the post.  Thanks!

Marc

FOLLOW UP: Public Sector Developer Conference (Downers Grove, IL)

Thanks to everyone who attended!  Here are the links to the decks and code for the sessions.  I don’t have the content from the LINQ & VSTO sessions yet, but will update this post when I get them.  However, I did promise to have a post up this morning.

How Visual Studio Team System 2008 will benefit your organization?deck

Language Integrated Query (LINQ)

Overview of the .NET Framework 3.5 SP1 & ASP.NET MVCdeck, resources, code (links to a post explaining how to get the code I based me demos on)

Office Development with VSTO  and Office Open XML Format

If you are interested in other content, I have a list of recorded webcasts in My Recorded Webcasts list.  There is a session similar to Joel’s LINQ session that covers LINQ to SQL in a little more detail as well as other topics which might interest you.  You might want to check out My Screencasts as well. 

Free training on .NET 3.5 SP1

I just came across this update to the .NET 3.5 Enhancements Training Kit from Jonathan Carter.  If you’ve seen my ASP.NET 3.5 Extensions Preview webcast and are looking for the code, then you will want to download the kit.  I used the kit as the starting point for my demos.  I do a few things differently here and there, but most of it is because I didn’t have time to show everything in 90 minutes.  As far as I can tell, everything that was in the extensions preview is in 3.5 SP1 except ASP.NET MVC which will be shipped separately.  The training kit offers a great way to get your hands dirty with the new stuff in 3.5 SP1.  Go get it!  Oh yea, I have also updated the deck from my webcast to reflect the changes.  I have also added a couple slides about what’s new in WPF & WCF.  You can download my new 3.5 SP1 deck here.

WPF for Line of Business applications

I’m a big believer that WPF is a great UI technology for LOB applications.  Yes, there are some shortcomings in the designer experience if you compare the WPF designer to the Windows Forms designer in Visual Studio 2008.  Yes, WPF is missing some controls that people expect like a DataGrid and DatePicker, but there are solutions.  For example:

I’ve updated my WPF Resources list with these links and more.

Personally, I think the benefits of the WPF programming model outweigh the shortcomings of the WPF designer in Visual Studio 2008.   Some of the customers I have worked with have told me that once they get over the initial "shock" around the designer (compared to Windows Forms) and the lack of certain controls, they quickly find that they are more productive overall because they are using WPF.  This will get better as the Cider team continues to improve the WPF Designer in Visual Studio.  Remember that the Windows Forms designer has been around since the release of .NET 1.0!  They’ve had a little more time to get all those feature in:).

One of the things I have been chatting about with some of my teammates is that there aren’t enough good samples demonstrating the use of WPF for LOB apps.  I’ve been doing some research to see what’s out there.  One example is the WPF sample that ships with the CSLA framework from Rockford Lhotka.  I used CSLA back in the days of my life as a VB6 developer.  Over the years, Rocky has evolved his framework as the .NET Framework has evolved.  CSLA is primarily a Business Object framework, but it ships with example user interfaces (including Windows Forms, ASP.NET, and now WPF).   The latest version has a WPF sample LOB app.  I also came across Karl Shifflet.  Karl’s blog has a ton of great info in it about WPF LOB apps including an 11 part series he’s started on the topic:

WPF Business Application Series Part 1 of n – Application Structure, Skinning & Custom ToolBar Button Control

WPF Business Application Series Part 2 – Form Notification Control That Binds To IDataErrorInfo.Error Property

WPF Business Application Series Part 3 of n – Business Object Declarative Programming; How To Implement Object Validation & Logging

I’ve yet to see a sample app that does everything Karl is planning on doing plus show online/offline capability using:

  • Client Application Services for Authentication / Authorization (which supports offline scenarios)
  • Data Access via a local SQL Compact Edition database using LINQ to SQL or LINQ to Entities
  • ADO.NET Sync Services communicating across the wire using WCF to synchronizes with the server database
    • Caches lookup data and a necessary subset of the server database relative to the user in the local SQLCE database
    • Allows the user to continue working offline, syncing/reconciling changes when they reconnect

I have a bunch of samples that show many of these scenarios, but I have yet to come across a complete solution bringing all of this together in a single app.  Have you seen such an example?  Are you aware of any other work like Karl & Rocky’s for building LOB WPF apps?  Please let me know in the comments section.  Thanks!

Technorati Tags: ,,,

WEBCAST FOLLOW UP: Overview of the Microsoft ASP.NET 3.5 Extensions Preview

Thanks to everyone who attended!  Sorry about the demo hiccups / going over.  As I mentioned in the beginning, I had a hard time trying to get everything I wanted to cover into 90 minutes.  As you can see, there’s quite a bit in the ASP.NET 3.5 Extensions.  Normally, I make all of my code demos available for download.  However, I used a newer build for my demos that’s not publicly available.  Once we release the new bits, I will make my code available.  For now, you can download my ASP.NET 3.5 Extensions deck here.

UPDATE: I just created a list of links on my Windows Live Space called ASP.NET 3.5 Extensions.  This list has links to all the relevant landing pages & forums for the various technologies covered today.  Newer versions of MVC, Dynamic Data, and the Silverlight Controls have been released since the December 2007 release of the ASP.NET 3.5 Extension Preview.  Make sure you read the release notes of each newer package to understand how to get the newer bits working on top of the December 2007 preview.  The ADO.NET Entity Framework and ADO.NET Data Services in the December 2007 release of the ASP.NET 3.5 Extension Preview are the latest releases as of today (04/30/2008).  Stay tuned for a newer release that will reflect the updates you saw today.

WEBCAST: Overview of the Microsoft ASP.NET 3.5 Extensions Preview

The ASP.NET 3.5 Extensions Preview is a new release that provides new functionality being added to ASP.NET 3.5 and ADO.NET in 2008. This release delivers a set of new features that target:

  • Enabling High Productivity Data Scenarios – including MVC, Entity Framework, ADO.NET Data Services and Dynamic Data
  • Supporting Test Driven Development – including a powerful and extensible MVC framework
  • Creating the best server for Rich Clients – including Ajax history support and Silverlight controls for ASP.NET

We will take a lap around all the great capabilities packed into this upcoming release including ASP.NET MVC, ASP.NET Dynamic Data, ASP.NET AJAX, ADO.NET Entity Framework, ADO.NET Data Services, and Silverlight Controls for ASP.NET.

When

Wednesday, April 30, 2008

2:00P-3:30P EST (11:00A-12:30P PST)

Register at this link:

http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032373610&Culture=en-US

SCREENCAST: Exposing/Consuming RSS/ATOM using WCF 3.5 & Silverlight 2

In this screencast, I show you how easy it is to expose RSS and Atom feeds using the new Web Programming Model (REST) features, classes in the new System.ServiceModel.Syndication namespace, and LINQ to SQL in the .NET Framework 3.5.  Then, you will see how you can use classes from the System.ServiceModel.Syndication namespace to consume RSS and Atom feeds using Silverlight 2.

Screencast: Exposing/Consuming RSS/ATOM using WCF 3.5 & Silverlight 2

Source code: WcfSyndicationLinqToSqlSilverlight2.zip

DC Launch Follow Up

Thanks to everyone who stuck around for my "Defy Occasionally-Connected Challenges With Smart Client Applications" session at the DC Launch.  The deck and demo files are available here:

Deck

Workflow Services Demo

Sync Services for ADO.NET Demo

Server Database

The demos require Visual Studio 2008 and depend on a SQL Server 2005 database.  I made the database available for download as well.  You’ll have to attach it to your SQL/SQL Express instance and make sure the connection strings in the project are correct.  You’ll notice that I didn’t include a download for the WPF demo.  That’s because the UI in the Sync demo is the exact same UI from the WPF demo.

I mentioned recorded/upcoming webcasts a few times during the presentation.  You can find a list of all my recorded webcasts at http://devkeydet.com. Here are the recorded webcasts related to the topics I covered:

Introduction to Windows Communication Foundation ***

Introduction to Windows Workflow Foundation ***

Introduction to Windows Presentation Foundation ***

Smart Clients: What’s New in Visual Studio 2008?

Introduction to LINQ + LINQ to SQL

What’s New in the WCF and WF in Visual Studio 2008 & the .NET Framework 3.5

Building Workflow Services (WF+WCF) with Visual Studio 2008

Building WPF Applications in Visual Studio 2008 and Expression Blend

*** These webcasts are fairly old.  They are based on .NET 3.0 / VS 2005.  The core concepts obviously apply, but the developer experience for all of these technologies has greatly improved in Visual Studio 2008.

I also mentioned my webcast on Thursday.  I’ll be presenting a deeper dive into the Microsoft Synchronization Services for ADO.NET.  Details are here.