For those that don't have the correct browser or OS watch a video clip here : GoogleHTMLDemo.wmv (3.41 mb)

This week I hope to upload the w5 video series.  This is the placeholder for that.

What is w5?  w5 stands for What Why When Where Who, it will be a video series describing topics I educate adults on.

w5 Videos include:

• Silverlight
• Career Guiding / Career Planning
• AJAX
• ASP.NET
• LINQ
• Windows Communication Foundation
• Windows Presentation Foundation
• Windows Workflow Foundation
• XML
• ADO.NET

Career Guiding from Brian Lockwood on Vimeo.

Consuming a weather service in an ASP.NET Web Application from Brian Lockwood on Vimeo.

UI Design Patterns: http://ui-patterns.com

Peter Morville's Findability: http://www.flickr.com/photos/morville/collections/72157603785835882/

Brian Christiansen's collection of patterns:
http://www.flickr.com/photos/factoryjoe/collections/72157600001823120/

Barbara Ballard/Little Springs Design mobile patterns wiki:
http://patterns.design4mobile.com/index.php/Main_Page

Janko has a great post on Table UI patterns:
http://www.jankoatwarpspeed.com/post/2010/02/26/table-ui-patterns.aspx

Mephobox is a series of pattern collections but this one's more for inspiration and less about good patterns with usability in mind:
http://box.mepholio.com/ By Jasmin Phua

After literally years of working on Ask A Prayer (http://www.askaprayer.com) we are making progress in implementing the application in churches across america.

During this time many enhancements have been made and there is one that has caused problems.  Using textbox with the AJAX Control Toolkit, every time I persisted data it would add a comma.  Probably the most frustrating bug I've ever come across.  Well apparently it exists in all builds of the AJAX Control Toolkit from May 2009 onwards.  This is a little disturbing that it remains a bug but I am releaved to have solved the problem.

I have reverted the AJAX Control Toolkit dll to the May 2009 revision and the problem is now solved. Good thing I'm not using some of the new controls because this could be frustrating.

CustomerManagement.bak (980.50 kb)

Typically I'd keep all my posts related to programming topics.  Unfortunately something this cool I can't pass up.  Think of this as a metaphor in your life.

Found this great posting on why to use the entity framework.  Here is a snippet:

Entity Framework vs. traditional ADO.Net
All of the standard ORM arguments apply here.  The highlights are that you can write code against the Entity Framework and the system will automatically produce objects for you as well as track changes on those objects and simplify the process of updating the database.  The EF can therefore replace a large chunk of code you would otherwise have to write and maintain yourself.  Further, because the mapping between your objects and your database is specified declaratively instead of in code, if you need to change your database schema, you can minimize the impact on the code you have to modify in your applications--so the system provides a level of abstraction which helps isolate the app from the database.  Finally, the queries and other operations you write into your code are specified in a syntax that is not specific to any particular database vendor--in ado.net prior to the EF, ado.net provided a common syntax for creating connections, executing queries and processing results, but there was no common language for the queries themselves; ado.net just passed a string from your program down to the provider without manipulating that string at all, and if you wanted to move an app from Oracle to SQL Server, you would have to change a number of the queries.  With the EF, the queries are written in LINQ or Entity SQL and then translated at runtime by the providers to the particular back-end query syntax for that database.

Entity Framework vs. LINQ to SQL
The first big difference between the Entity Framework and LINQ to SQL is that the EF has a full provider model which means that as providers come online (and there are several in beta now and many which have committed to release within 3 months of the EF RTM), you will be able to use the EF against not only SQL Server and SQL CE but also Oracle, DB2, Informix, MySQL, Postgres, etc.

Next there is the fact that LINQ to SQL provides very limited mapping capabilities.  For the most part L2S classes must be one-to-one with the database (with the exception of one form of inheritance where there is a single table for all of the entity types in a hierarchy and a discriminator column which indicates which type a particular row represents).  In the case of the EF, there is a client-side view engine which can transform queries and updates made to the conceptual model into equivalent operations against the database.  The mapping system will produce those views for a variety of transformations.

You can apply a variety of inheritance strategies: Assume you have an inheritance model with animal, dog:animal & cat:animal.  You can not only do what L2S does and create a single table with all the properties from animal, dog & cat plus a column that indicates if a particular row is just a generic animal or a dog or a cat, but you can also have 3 tables where each table has all of the properties of that particular type (the dog table has not only dog-specific columns but also all the same columns as animal), or 3 tables such that the dog and cat tables have only the key plus those properties specific to their type of animal and retrieving a dog object would involve a join between the animal table and the dog table.  And you can further combine these strategies so some parts of a hierarchy might live in one table and some parts in separate tables.

In addition you can do what we call "entity splitting" where a single type has properties which are drawn from two separate tables, and you can model complex types where there is a type which is nested within a larger entity and which doesn't have its own separate identity--it just groups some properties together.  The best example of this is something like address where the street, city, state and zip properties go together logically, but they don't have independent identity.  The address is only interesting as a set of properties that are part of a customer or whatever.  As you have noticed, for v1 you can't create complex types with the designer in the EF--you have to code them by hand in the XML files.

Found at: http://blogs.msdn.com/b/dsimmons/archive/2008/05/17/why-use-the-entity-framework.aspx