Showing posts with label Silverlight 2. Show all posts
Showing posts with label Silverlight 2. Show all posts

Monday, June 15, 2009

LINQ and Entity Framework Posts for 6/8/2009+

Note: This post is updated daily or more frequently, depending on the availability of new articles.

• Updated 6/15/2009: Missing MSDN Magazine articles about EF in the June issue.

Entity Framework and Entity Data Model (EF/EDM)

• Danny Simmons’ “Antipatterns To Avoid In N-Tier Applications” article in the June 2009 issue of MSDN Magazine begins:

As a member of the Entity Framework team, I frequently talk to customers about building applications that use the Entity Framework. Probably the topic I get asked about more than anything else is designing n-tier applications. In this article, I will try to set a foundation on which you can build for success in this part of your applications. The majority of the article is devoted to design anti-patterns for n-tier, which are usually the most important issues that I find. This is a topic where there are a lot of options and many issues to consider, so it is important to understand the overall space before making decisions for your particular application. In future articles, I will examine n-tier patterns for success and some of the key APIs and issues specific to the Entity Framework, and provide a sneak peak at features coming in the Microsoft .NET Framework 4 that should make n-tier significantly easier.

Topics include:

    • Understanding n-tier
    • Don't distribute your objects!
    • Custom service or RESTful service?
    • Some n-tier anti-patterns

Contents:

    • Understanding N-tier
    • Anti-Pattern #1: Tight Coupling
    • Anti-Pattern #2: Assuming Static Requirements
    • Anti-Pattern #3: Mishandled Concurrency
    • Anti-Pattern #4: Stateful Services
    • Anti-Pattern #5: Two Tiers Pretending to be Three
    • Anti-Pattern #6: Undervaluing Simplicity

• Jeremy Miller’s Patterns & Practices column, “The Unit Of Work Pattern And Persistence Ignorance,” in MSDN Magazine’s June 2009 issue begins:

In the April 2009 issue of MSDN Magazine ("Persistence Patterns") I presented some common patterns that you will encounter when using some sort of Object/Relational Mapping (O/RM) technology to persist business entity objects. I think it's unlikely that you or your team will be writing your own O/RM tooling from scratch, but these patterns are important to know to effectively use (or even just to choose) existing tooling.

In this article, I would like to continue the discussion of persistence patterns with the Unit of Work design pattern and examine the issues around persistence ignorance. Throughout most of this article, I will be using a generic invoicing system as the example problem domain.

Contents:

    • The Unit of Work Pattern
    • Using the Unit of Work
    • Persistence Ignorance
    • Can the Business Logic Run Independently of the Database?
    • Can I Design My Domain Model Independently from the Database Model?
    • How Does My Persistence Strategy Affect My Business Logic?
    • More Units of Work

Matthieu Mezil describes a second extension method for to get entities with a composite key in his Entity Framework v2 : How to get only one entity easier with EF4 post of 6/12/2009.

Gil Fink gives Julie Lerman’s book the thumbs-up in his Programming Entity Framework Book Review post of 6/11/2009.

Alex James’ Tip 25 – How to Get Entities by key the easy way of 6/11/2009 provides a general-purpose (but not typesafe) method for getting entities by key that uses the GetCSpaceEntityType<T>() extension method I wrote in Tip 13, to get the EntityType for T.”

Jaroslav Kowalski describes two EF extensions (wrapping providers) that plug into the ADO.NET provider interface in his Tracing and Caching for Entity Framework available on MSDN Code Gallery post of 6/11/2009:

    • EFTracingProvider – which adds the ability to log all SQL commands that are executed (similar to LINQ to SQL’s DataContext.Log

    • EFCachingProvider – which adds transparent query results cache to EF

Here’s Jarek’s diagram for his EF wrapping providers:

image

You can download the source code for the two providers from the Tracing and Caching Provider Wrappers for Entity Framework section of the MSDN Code Gallery.

Jaroslav Kowalski updates the Entity Framework Toolkits & Extensions wiki in his UPDATED WIKI: Home post of 6/11/2009. EdmGen2.exe TPT Inheritance with LINQ to SQL are flagged New!

Matthieu Mezil adds two extension methods, BeginGroupOfUndoActions and EndGroupOfUndoActions, to his first Undo Redo POC version in Entity Framework: Undo Redo v2 of 6/10/2009.

Danny Simmons announces the first release of his new EF DPMud project to the MSDN Code Gallery in his D3: Release 0.0010 post of 6/10/2009. Danny discusses “a few decisions that came up along the way” and then “dig[s] into some specific code areas.”

Lynn Erikson analyzes EFv2’s CodeOnly feature in his Entity Framework ‘Code Only’? If you take the red pill … post of 6/10/2009.

Alex James’ Code Only post of 6/10/2009 begins:

There are currently two ways to get Entity Framework apps up and running, we call these Database First and Model First respectively.

Database First has been with us since .NET 3.5 SP1, and involves reverse engineering an Entity Data Model from an existing database.

Model First is new to Visual Studio 2010/.NET 4.0 and allows you to create an Entity Data Model from scratch and then generate a database and mapping for it.

However many developers view their Code as their model.

Ideally these developers just want to write some Domain classes and without ever touching a designer or a piece of XML be able to use those classes with the Entity Framework.
Basically they want to write ‘Code Only’.

We are pleased to announce that we’ll be shipping a preview of “Code Only” on top of the .NET Framework 4.0 Beta 1 (more on that in the coming days).

Alex goes on to describe how “Code Only” works in EF v2.

LINQ to SQL

Peter Kellner uncovers an Interesting LINQ side affect, Pass in empty List<int> using Contains and Get Where 0 == 1. Hmm in this 6/14/2009 post.

Shahzad’s Multi tier architecture for Linq to Sql post of 6/13/2009 begins:

This resource shows an approach for using Linq to Sql within a multi tier Asp.Net application, and particularly how it can be made to work well with ObjectDataSources. It is here as a discussion piece as well as a usable bit of code.

The key features are a Request-scoped datacontext and entity repository classes which provide easy to use Create, Retrieve, Update and Delete (CRUD) operations implemented with Generics. Also included is a T4 template for auto generation of repositories from a dbml file.

Alvin Ashcraft gives PLINQO a test drive in his Checking Out PLINQO to Generate LINQ to SQL Code with CodeSmith post of 6/10/2009.

Peter Kellner’s 780 Requests Per Second Verses 110, You Really Need to Compile your LINQ to SQL (LINQ2SQL) Queries post of 6/8/2009 begins:

So, I’ve been on kind of a rant lately about how slow LINQ2SQL is if you don’t compile your queries before executing them.  To be fair, if you are doing Windows Forms Programming, WPF or Silverlight it really does not have much impact.  The reason is that a very complex LINQ query may take 50 milliseconds (1/20th of a second).  No big deal if you just have a dozen or so of them to do.  The story changes though if you are using LINQ2SQL in a web environment that has limited CPU resources.  That is, unless you have unlimited money, if it takes more than one web server to handle your load, your throwing away money by using uncompiled LINQ2SQL.

LINQ to Objects, LINQ to XML, et al.

Fryan Valdez shows you how to Combine two sequences using LINQ Zip Operator with .NET 4.0 in this 6/13/2009 post.

OmegaMan’s Linq vs. DataReader; Visual Examples Showing That Linq Does the Same in Less Lines of Code post of 6/10/2009 describes how to handle DbNull values with INullable<T> when using the SqlDataReader.

ADO.NET Data Services (Astoria)

Phani Raju describes how to use the Silverlight toolkit with ADO.NET Data services for Drill-down Charts using Astoria in this 6/10/2009 post.

Phani Raju describes how to use the Silverlight toolkit with ADO.NET Data services for Master-Details with Accordion in this 6/10/2009 post.

Faisal Mohamood’s POCO in the Entity Framework : Part 3 – Change Tracking with POCO post of 6/10/2009 covers:

    • Snapshot based Change Tracking (pure POCO without proxies)
    • Notification based Change Tracking with Proxies
    • Keeping the State Manager in Sync without using Proxies
    • New Overloads for SaveChanges

ASP.NET Dynamic Data (DD)

No significant posts as of 6/14/2009.

Miscellaneous (WPF, WCF, MVC, Silverlight, etc.)

Phani Raju describes how to use the Silverlight toolkit with ADO.NET Data services for Drill-down Charts using Astoria in this 6/10/2009 post. (Repeated from the ADO.NET Data Services (Astoria) section.)

Phani Raju describes how to use the Silverlight toolkit with ADO.NET Data services for Master-Details with Accordion in this 6/10/2009 post. (Repeated from the ADO.NET Data Services (Astoria) section.)

Wednesday, February 04, 2009

LINQ and Entity Framework Posts for 1/26/2009+

Note: This post is updated daily or more frequently, depending on the availability of new articles.

• Updated 1/28/2009 5:00 PM PST: Additions
•• Updated 2/4/2009 5:00 PM PST: Substantial additions

Entity Framework and Entity Data Model (EF/EDM)

Julie Lerman alerts readers on 2/2/2009: Dear Rough Cuts Readers: Safari PDF for Programming Entity Framework is still the Rough Cuts version (as of Feb 2).

•• Diego Vega’s EntityDataSource and Bind: What are those square brackets? post of 2/2/2009 explains that:

[T]he design time component of ASP.NET will catch property names that contain dots, and it will try to escape them by surrounding them with square brackets (leading to a Bind expression of the form “[Categories.CategoryID]”).

Unfortunately, the rest of the ASP.NET components which need to evaluate the binding expression are actually not capable of parsing the square brackets escaping notation (i.e. for DataBinder.Eval() the brackets actually indicate that a lookup in an indexed property is necessary, and there is no indexed property in this case).

The workaround is to delete the square brackets.

•• My Free Huagati DBML/EDMX Professional Tools License for 10 Purchasers of my LINQ and Entity Framework Book post of 1/29/2009 explains how purchasers of my new book can get a free Huagati DBML/EDMX Tools (Professional edition) license.

•• Matthieu Mezil’s EDM can save your hair :-) post of 1/29/2009 explains how to deal in the EDM Designer and CSDL file with a database that has the following characteristics:

  • an asbtract entity type Base (mapped on Bases)
  • an entity type Entity which inherits Base and which is mapped on Inheriteds
  • an entity Description
  • an 1 -> * association between Base and Description

• Muhammad Mosa (a.k.a. Moses of Egypt)’s First Steps toward Test Driven Design\Development post of 1/28/2009 describes his efforts to apply TDD with EF and promises to “show how to follow TDD while working with Entity Framework and being independent of it” while implementing the guidelines quoted in this post, which “where like magic words to me. Keep tuned.”

Stefan Cruysberghs’ Sharing source code between .NET and Silverlight post of 1/27/2009 observes:

A common problem when developing Silverlight applications is how to share classes and especially (Entity Framework) entities which are compiled for the full .NET framework in a Silverlight application. Silverlight is a browser plugin and a subset of the full .NET framework. Therefore Visual Studio does not allow referencing .NET assemblies from your Silverlight application.

Fortunately there is a very simple technique to share source code. In this article I will try to demonstrate this technique with several real world examples and I will give you some handy tips.

My “Professional ADO.NET 3.5 with LINQ and the Entity Framework” Is in Stock at Amazon post of 1/23/2009 alerts LINQ and EF aficianados to the availability of my latest book. (Repeated from last week’s post.)

Julie Lerman announces in Entity Framework at Philly.NET followed by a Hands on Lab Tomorrow night (1/27) that Bill Wolff (the user group leader) and Rob Keiser are leading a Entity Framework hands-on-lab on 1/27/2009 from 6:00 - 8:30 PM at Fort Washington, PA. More details are available on Philly.NET's home page.

David Sceppa’s Entity Framework-Enabled Providers Lists post of 1/26/2009 lists released providers here and released and all publicly available providers, including pre-release (beta) providers here.

LINQ to SQL

•• Andrei Rinea reports and works around a LINQ to SQL NullReferenceException gotcha on 1/30/2009. (The comments are in Romanian.)

• Joel Cunningham’s Regenerate Linq to Sql Classes post of 1/28/2008 shows how to “call a replace.vbs script after creating the dbml file” … “to change the DataContext from being public to internal which is not possible to do using sqlmetal.”

• LinqMaster describes How to Use Compiled Queries in Linq to Sql for High Demand ASP.NET Websites in his 1/28/2009 post.

Stan Naspinski’s open-source Slick-Ticket Trouble Ticketing/Help Desk System uses LINQ to SQL rather than Entity Framework for the reasons Stan outlines in his Why I decided to stick with Linq-to-SQL over Linq-to-Entities post of 1/17/2009. You can download the Slick-Ticket C# project from CodePlex; it’s licensed under the GNU General Public License version 2 (GPLv2). Here’s the new ticket screen (click for full-size image):

LINQ to Objects, LINQ to XML, et al.

•• Barry Dahlberg’s LINQ to NHibernate, IEnumerable<T> vs IQueryable<T> post of 2/1/2009 explains that NHibernate’s session.Linq<Foo>().WithId(123).Single() returns an IQueryable<Foo> which doesn’t touch the database. Barry shows an extension method that returns the desired <Foo> instance.

•• Maarten Balliauw’s PHPLinq 0.4.0 released on CodePlex! describes PHPLinq (a.k.a. LINQ to PHP) and the new features in version 0.4. About PHPLinq, he writes:

PHPLinq is a class library for PHP, based on the idea of Microsoft’s LINQ technology. LINQ is short for language integrated query, a component in the .NET framework which enables you to perform queries on a variety of data sources like arrays, XML, SQL server, ... These queries are defined using a syntax which is very similar to SQL.

Using PHPLinq, the same functionality is created in PHP. Since regular LINQ applies to enumerators, SQL, datasets, XML, ..., I decided PHPLinq should provide the same infrastructure.

• Eric White describes an approach and presents code for normalizing LINQ to XML trees in his Equality Semantics of LINQ to XML Trees post of 1/27/2008. Eric writes:

In certain scenarios, it is important to be able to compare two XML trees for equivalence. For example, if you are writing a web service that serves results of queries, and you want to cache query results so that duplicate queries use previously cached results instead of always accessing the underlying database. However, the senders of those queries may potentially be using a variety of tools to generate the queries, and these tools may introduce trivial differences into the XML. The intent of the queries may be identical, but XNode.DeepEquals returns false if you compare the XML that contains semantically equivalent, but trivially different queries.

• Mike Taulty takes on Anonymous Methods, Lambdas, Confusion in this 1/28/2009 post. Mike writes:

Not surprisingly, not everyone out there is on .NET Framework V3.5 Service Pack 1 and not everyone is yet writing LINQ queries and using Lambdas and so on and so there’s still a need to try and catch up with some of what’s been going on.

This is going to be particularly true in the VB world where some of the language features are not present until Visual Studio 2010 ships.

I thought I’d try and write a “potted history” of what’s been going on in with all these lambdas and anonymous methods and so on to see if that’s of any help.

Dan Whalin’s Free Webinar – Increase Productivity with .NET and LINQ post of 1/25/2009 announces that Dan will present a 00:50:00 Webinar about LINQ to Objects, LINQ to XML, LINQ to SQL, and LINQ to Entities on February 5, 2009 at 1:00 P.M. EST (10:00 AM PST). According to the abstract:

Interested in increasing developer productivity?  This webinar from ROI Training and The Wahlin Group will introduce .NET developers to Microsoft’s Language Integrated Query (LINQ) technology and show how it can be used to minimize code and application maintenance costs.  The webinar is presented by Dan Wahlin who will introduce several LINQ technologies including LINQ to Objects, LINQ to XML, LINQ to SQL and LINQ to Entities.  Learn to query object collections and XML and see how data from a database can be automatically mapped to custom data entity objects with minimal coding.

ADO.NET Data Services (Astoria)

Sebastien Lambla’s How to Fix Microsoft’s Two-Tier Service Application Scenario (REST) post of 1/25/2009 takes Microsoft’s patterns & practices group to task for their Two-Tier Service Application Scenario (REST) post to CodePlex’s patterns & practices: App Arch Guide 2.0 Knowledge Base. Seb’s introduction states:

I’ve had many rants about Microsoft’s attitude towards REST and the marketing branding they put on (some teams being much worse than others by arrogantly or unknowingly putting the word REST on the name of their framework).

This entry is no such rant, but an effort to outreach to the authors. The document has issues, but it is my belief that with the right corrections, it could be made accurate.

ASP.NET Dynamic Data (DD)

Steve Naughton continues his DD rampage with Making Individual Tables Read Only – Dynamic Data of 1/28/2009.

Steve Naughton’s Disallow Navigation on ForeignKey FieldTemplate – Dynamic Data post of 1/26/2009 is based on his response to the A few problems with my dynamic data website thread in the ASP.NET Dynamic Data forum.

SQL Data Services (SDS) and Cloud Computing

This topic moved on 1/3/2009 to Windows Azure and Cloud Computing Posts.

SQL Server Compact (SSCE) 3.5 and Sync Services

Liam Cavanaugh’s What's New with Sync Framework post of 1/26/2009 describes “what [has been] going on … in the Sync Framework team since last November.” Topics include:

  • Sync Framework v2
  • Sync Services for ADO.NET v2
  • Project “Huron”
  • SyncToy 2.0

Miscellaneous (WPF, WCF, MVC, Silverlight, etc.)

•• John Papa’s Silverlight, Syndicated Feeds, and Isolated Storage post of 2/1/2009 describes his “Data Points” column entitled “Syndicated Data And Isolated Storage In Silverlight” for the February 2009 issue of MSDN Magazine. The article addresses:

•• J Sawyer, a Microsoft Developer Evangelist in Houston, TX, describes Url Routing in ASP.NET in this 1/30/2009 post.

•• Shawn Wildermuth reports that the New Oslo CTP is Live! but doesn’t include the Quadrant tool. Shawn promises more posts about the new CTP shortly.

•• Mike Amundsen raises issue of developers ignoring the full set of HTTP methods in his ASP.NET MVC: so POST == DELETE, eh? post of 1/30/2009. Mike says “no” to use of POST for RESTful PUT and DELETE operations.

•• Shawn Wildermuth’s Building AgiliTrain: Part 1 - Why ASP.NET MVC post of 1/28/2009 explains:

I've spent the better part of six weeks building the new AgiliTrain website and its been quite a lot of fun. Of course if you have been reading this blog for long you know that I usually take a personal project like this as an opportunity to learning something new.  In this case I did three things I haven't done on a personal project before:

  • Use ASP.NET MVC (Beta)
  • Use Oslo's MSchema
  • Use a Designer

I've been thinking a lot about how I would characterize my experience with ASP.NET MVC. I recently was at a talk from Paul Lockwood (at the Atlanta .NET User Group) and he thought that it was two weeks of a steep learning curve then bliss.  That's pretty close to my experience.  I thrashed for a couple of weeks wondering whether going back to WebForms would be faster...but I was patient.

•• Guy Burstein reports the availability of ASP.NET MVC 1.0 RC source code in his Just Released: Source Code for ASP.Net MVC 1.0 RC post of 1/28/2009.

• Ben Hall test drives the ASP.NET MVC 1.0 RC on 1/27/2009 and writes ASP.net MVC RC1 - ViewData.Model becomes Model and ASP.net MVC RC1 – Removing Code Behind files.

Stefan Cruysberghs’ Sharing source code between .NET and Silverlight post of 1/27/2009 observes:

A common problem when developing Silverlight applications is how to share classes and especially (Entity Framework) entities which are compiled for the full .NET framework in a Silverlight application. Silverlight is a browser plugin and a subset of the full .NET framework. Therefore Visual Studio does not allow referencing .NET assemblies from your Silverlight application.

Fortunately there is a very simple technique to share source code. In this article I will try to demonstrate this technique with several real world examples and I will give you some handy tips.

[Copied from the Entity Framework and Entity Data Model (EF/EDM) section]

Scott Guthrie’s ASP.NET MVC 1.0 Release Candidate Now Available post of 1/27/2009 announces the availability of ASP.NET MVC 1.0 RC1 and describes its new and/or improved features:

  • Visual Studio Tooling Improvements
    • Add Controller Command
    • Add View Command
    • Adding and Customizing Scaffold Templates
    • Go To Controller / Go To View
    • MSBuild Task for Compiling Views
    • View Refactoring Support
  • View Improvements
    • Views without Code-Behind Files
    • Model Property
    • Setting the Title
    • Strongly Typed HTML/AJAX Helpers
  • Form Post Improvements
    • ModelBinder API Improvements
    • IDataErrorInfo Support
  • Unit Testing Improvements
    • ControllerContext changed to no longer derive from RequestContext
    • AccountsController Unit Tests
  • Cross Site Request Forgery (CSRF) Protection
  • File Handling Improvements
    • File Uploading Support
  • AJAX Improvements
  • jQuery Intellisense Files included within ASP.NET MVC Project Template
    • Request.IsAjaxRequest Property
    • JavaScriptResult ActionResult and JavaScript() helper method

Monday, January 26, 2009

Azure and Cloud Computing Posts for 1/19/2009

Windows Azure, Azure Data Services, SQL Data Services and related cloud computing topics now appear in this weekly series.

Note: This post is updated daily or more frequently, depending on the availability of new articles.

• Updated 1/22/2009 10:00 AM PST
•• Updated 1/26/2009 10:00 AM PST

Azure Blob, Table and Queue Services

•• Scott Watermasysk explains Azure Table Storage Key Conventions for PartitionKey and RowKey columns in his 1/23/2009 post.

•• George Crump’s Cloud Storage Matures InformationWeek blog post of 1/23/2009 observes that:

[C]ompanies like Bycast, Cleversafe, Amazon and Nirvanix have real customers paying real money to use their products or services. Companies like EMC and HP are bringing legitimacy to the concept and companies to watch like ParaScale are moving through the development cycle. …

[Y]ou can consider other options to the cloud storage wave. While leveraging your backup process should not be considered, (see our article Backup vs. Archive) Disk Archive solutions like those from Permabit and Nexsan are an alternative to consider.

•• Rob Bagby describes how to avoid IIS 7.0’s dreaded “The security certificate presented to this website was issued for a different website’s address” in his Self-Signed Certificates on IIS 7 – the Easy Way and the Most Effective Way post of 1/23/2009.

Note: Clients receive this error if you use the approach recommended by Scott Guthrie in his Tip/Trick: Enabling SSL on IIS 7.0 Using Self-Signed Certificates post of 4/6/2007. Rob demonstrates the workaround.

• Dare Obasanjo concludes in his Cloud Computing Conundrum: Platform as a Service vs. Utility Computing post of 1/22/2009:

As it stands today  platform as a service offerings currently do not satisfy the needs of people who have existing apps that want to "port them to the cloud". Instead this looks like it will remain the domain of utility computing services which just give you a VM and the ability to run any software you damn well please on the your operating system of choice.

Dare cites the lack of a “SQL database in the cloud” and the need to rewrite Windows Azure applications to remove reliance on relational features such as foreign keys, joins, triggers, and stored procedures to be “adoption blockers.” SQL Data Services now emulates joins, but not other RDBMS capabilities. Amazon EC2 running Windows 2003/SQL Server 2005 instances is a partial solution to the “drop in your ASP.NET project” but I’m still not sanguine about the scalability of SQL Server instances with .mdf/.ldf files in the Elastic Block Store.

Note: Dare cites Tim O’Reilly’s Web 2.0 and Cloud Computing post of 10/26/2008, which discusses the thread of a cloud computing infrastructure monopoly, defines key cloud computing models, and predicts that supplying cloud infrastructure will be a low-margin business.

Richard Jones’s Anti-RDBMS: A list of distributed key-value stores post of 1/19/2009 provides a list and Java-centric analysis of today’s distributed key-value persistence stores, such as BigTable and Hadoop. (Azure Table Services and Amazon SimpleDB are distributed key-value stores.) Richard’s post prompted the following Tweet from Dare Obasanjo:

Carnage4Life Reading http://bit.ly/JXtx reminds me that I have to finish my Anti-Anti-RDBMS post. The way I see it BigTable has set us back five years.

The computer science folks at UC Berkeley, such as Joseph Hellerstein, believe BigTable, Hadoop, and MapReduce are a better approach to big data than SQL. UC Berkeley’s EECS department in 2008 replaced relational database systems (RDBMSs) and SQL with Hadoop and MapReduce in the introductory computer science curriculum.

SQL Data Services (SDS)

•• Nic Smith’s Microsoft BI Strategy Update post of 1/23/2009 reports:

Based on customer feedback, we’re announcing today that Microsoft is consolidating the scorecard, dashboard, and analytical capabilities from PerformancePoint Server into SharePoint Server as PerformancePoint Services, making these capabilities available to millions of SharePoint users around the world.

For more information, watch Guy Weismantel’s video. Guy is Director of Microsoft BI.

This move to increase PerformancePoint’s demographics might speed arrival of the promised SQL Business Intelligence Service, as mentioned by Arthur Cole in his Appliances and the Cloud — Two Great Tastes…? post of 1/9/2009 in which he says:

Microsoft in particular seems to be heading toward a cloud/appliance model with the expected development of a new SQL Server-based appliance created from technology acquired from DATAllegro. And if that appliance shows up in the SQL Server Data Services plan as expected, you’ll have the ability to manage vast amounts of data across literally thousands of nodes. [Emphasis added.]

• James Johnson supplements his MSDN Webcast: geekSpeak: SQL Data Services with James Johnson (Level 200) Webcast of 1/14/2009 with three tutorial posts about SDS:

  1. SQL Data Services Adventure - Day 1: Introduction to SDS and the Azure Services Training Kit
  2. SQL Data Services Adventure – Day 2: The ACE model
  3. SQL Data Services Adventure – Day 3: Universal Resource Identifiers (URIs) and security

• Quantivo’s White Paper: The Case for Sofware-as-a-Service Analytics (requires registration) argues:

In the Business Intelligence and analytics market where expensive and hard to use solutions are frustrating managers and business analysts alike, SaaS solutions offer cheaper, easier to deploy and use alternatives. The Quantivo analytics service combines revolutionary technology with cloud-computing, enabling a fundamentally new approach to delivering customer behavior analytics at scale.

The SDS team continues to mention analytics (and reporting) services as forthcoming Azure SQL Services but the team doesn’t mention an estimated delivery date.

Dave Graham’s Cloud Optimized Storage Solutions: Tiering & Expectations article of 1/20/2009 for Cloud Computing Journal discusses supporting the following Information Lifecycle Management tiers in the cloud:

  1. Tier 0 & 1: Performance & Availability Guaranteed Storage
  2. Tier 2: Availability Guaranteed Storage
  3. Tier 3: Accessibility Guaranteed Storage

Part 1 of the series (1/5/2009) was subtitled Data Storage Has Been Taken for Granted and Part 2 (1/10/2009) is How is Content Stored in the Cloud?

Dave is a Technical Consultant with EMC Corporation.

.NET Services: Access Control, Service Bus and Workflow

• Ryan Dunn’s Azure Issue Tracker Released post of 1/22/2009 describes his new Issue Tracker service:

This sample application is a simple issue tracking service and website that pulls together a couple of the Azure services:  SQL Data Services and .NET Access Control Service.

This demo is meant to show a realistic SaaS scenario.  As such, it features federation, claims-based authorization, and scalable data storage. [Emphasis added.]

His post provides a detailed, illustrated description of the services architecture, implementation, and usage. You can download the sample code from the project’s page on CodePlex.

Sam Gentile’s Enterprise Service Buses (ESBs) Drive SOA Adoption - Part 3 focuses on:

[A] very high level view of the Neuron ESB architecture. This will help lay a solid foundation for the articles to come. This material in this particular article is influenced by both posts and talks with Neuron’s Architect, David Pallmann.

[See reference to David Pallman below.]

Live Windows Azure Apps, Tools and Test Harnesses

•• Alex Golesh reached episode four of his detailed Silverlight in the Mesh and the “Cloud” – Silverlight Mesh Enabled Web Application and Azure Services (Part 4) tutorial on 1/23/2009. These links point to previous parts Part 1, Part 2, Part 3. Part 1 describes his project:

For quite some time I’m investigating the Azure Services and Live Framework. After gaining some experience, I decided to build simple project - Content Store – to share with you how to build the next generation of applications.

My “Cloud Store” project will use Windows Azure Storage Account to persist content at the cloud, will use Windows Azure Hosted Services as business logic provider (submit contents to the store, display the contents and “purchase” it). Also, my project will use Live Framework Mesh Silverlight applications to provide UI for content submitters and content viewers/buyers.

Note: SMEWA is an acronym for Silverlight Mesh-Enabled Web Application.

• Ryan Dunn’s Azure Issue Tracker Released post of 1/22/2009 describes his new Issue Tracker service:

This sample application is a simple issue tracking service and website that pulls together a couple of the Azure services:  SQL Data Services and .NET Access Control Service.

This demo is meant to show a realistic SaaS scenario.  As such, it features federation, claims-based authorization, and scalable data storage.

His post provides a detailed, illustrated description of the services architecture, implementation, and usage. You can download the sample code from the project’s page on CodePlex. [Copied from the “.NET Services: Access Control, Service Bus and Workflow” section.]

• Deni Connor reports in Iron Mountain, Microsoft team for online backup of 1/19/2009 that Iron Mountain and Microsoft inked a deal last week to support organizations with System Center Data Protection Manager (DPM) and back them up to Iron Mountain's CloudRecovery.

I’m surprised that DPM doesn’t back up with Microsoft Azure or at least to Microsoft Data Centers. Are Iron Mountain’s servers more reliable than Microsoft’s?

• Charles Babcock’s How The Cloud Enables A New Set Of Personal Applications post of 1/22/2009 to InformationWeek’s Plug into the Cloud blog describes a mash-up that uses Amazon Mechanical Turk workers to translate iPhone or other images of business cards uploaded to an Amazon EC2 app (Lasso2Go) into a Salesforce lead, an email message, or spreadsheet.

Gus Perez of the Azure Tools team updated his original Windows Azure Links post on 1/19/2009.

David Pallman, the author of the Azure Storage Explorer tool and active participant in the Windows Azure forum, posted Azure Blob Sync on 1/19/2009. According to David:

Azure Blob Sync is a GUI tool that syncs a local file folder to cloud Blob storage or vice-versa. Binaries, sources, and documentation are up on CodePlex. …

To keep the sync fast, simple, and safe, it uses a very simple algorithm: a file or blob is not copied from source to destination if there is already an item of that name on the destination side.

Future plans for AzureBlobSync include a command line version you can use in batch jobs and a means of scheduling automated syncs.

David’s Azure Storage Explorer Updated post of 1/19/2009 notes that the new 0.3 preview version has the following updates:

  1. It's built against the January 2009 Azure CTP.
  2. Blobs in a folder hierarchy (with prefixes)[, including log folders,] now display and can be viewed.
  3. Blobs whose names end in ".xml" (like log files) are auto-formatted as pretty XML with whitespace to make them more readable.

Azure Infrastructure

•• Waiming Mok, a member of the Azure team, posted Servers vs Green (1/24/2009), a chart that  shows the projected contribution to the energy crisis, and consequently the carbon dioxide emission of servers in 2010. One of the suggested solutions:

Migrate to cloud-computing, where virtualization is deployed and the cost of deployment is shifted from CAPX to OPEX, which could made the adoption easier for some businesses.  The following requirements would need be solved:  security, system availability, IT ownership,

Waiming’s More Cores Slow Computing post of 1/25/2009 cites a Sandia National Lab study that shows the current design of multi-core processors with high core count actually slow down the system performance.

•• Matt Penner’s What is the Microsoft Cloud Platform? post of 1/24/2009 critiques Woody Pewitt’s presentation of the same name at the Southern California CodeCamp 2009 and describes the Windows Azure sign-up process:

Woody, and Lynn Langit who is in the audience, just mentioned the sign on process.  It’s a nightmare!  Even some of the internal MS people don’t have keys.  I think with all the talent that’s in MS they could have designed and built out the whole sign-up and beta key process much better.  It’s terrible to put it lightly.  The forums are filled with disgruntled users that can’t log in and have no idea what state their application process is in.  This is one of those examples where a little more time and care up front would have saved hours and hours of support calls/emails/postings and upset and confused users.  OK, that being said check out Lynn’s post on this very subject.

•• Jim Liddle’s The Economics of Cloud post of 1/23/2009 delivers a cost comparison between building and running your own 50,000 node data center (US$ 112.42/node-month), renting a extra-large Amazon EC2 instance with one 4-core CPU (US$ 576/month or $144/node-month) without an operating system. 

Note: The on-premises costs are derived from James Hamilton’s Cost of Power in Large-Scale Data Centers post of 11/28/2008.

GigaSpace subscription cost would be $7,500 per CPU per year for 4 * 4 core servers, which would be equivalent of 8 CPUs or US$ 60,000 per year, or US$ 312.50/node-month.

EC2 running four GigaSpaces 4-core instances costs US$ $55,910.40 per year or US$ 291.20/node-month and requires no up-front outlay. 

Jim is Director, Sales and Operations, UK, Ireland & Benelux at GigaSpaces. GigaSpaces markets the eXtreme Application Platform (XAP), a highly scalable application server. GigaSpaces XAP lets you deploy applications that use Java, .Net, C++, or scripting languages.

•• My Microsoft Postpones Construction of Iowa Data Center post of 1/23/2009 quotes the ms datacenters blog’s Building a Better Mousetrap a.k.a. Optimizing for Maximum Efficiency in an Economic Downturn post of 1/23/2009 by Arne Josefsberg and Mike Manos:

[W]e’re postponing construction of the data center in Iowa that we recently purchased land for. We are still continuing construction of our facilities in Chicago and Dublin, and are planning to open them as customer demand warrants. [Emphasis added]

•• Cloud Computing Journal writes Cisco's David Bernstein to Present at Cloud Computing Conference in NYC. Bernstein is

VP and General Manager of Network Applications Infrastructure for Cisco Systems, Inc, where he directs product and research efforts around application aware networking and distributed computing. He serves on several industry boards including the IEEE Computer Society Advanced Technology Executive Board.

Bernstein's team runs Cisco's internal Cloud Computing platform and so has first-hand experience in this emerging category. 25 years in software and systems in Silicon Valley in companies including Cisco, Siebel, and AT&T provide him with a deep perspective on applications infrastructure

• Roger Smith reports on 1/22/2009 from the Cloud Connect unconference that Panelists Say Legacy Apps In The Cloud Are A Roll Of The Dice. Roger writes:

The premise of the Thursday morning panel discussion at the Cloud Connect event at the Computer History Museum in Mountain View, Calif., was that it's possible to have the best of both worlds: your legacy applications and the cloud. By the end of the hour-long discussion, many of the 200 or so attendees seemed to have come to the conclusion that enterprise and Web-scale development were worlds apart and moving further away from each other at something approaching the speed of light. …

Asked if Microsoft was "coming out of its cave" on cloud computing, [director of research, Directions on Microsoft Rob] Helm said from his experience that Microsoft has three approaches to the cloud:

  1. The Microsoft Consumer cloud, with products like MS Live;
  2. The Microsoft Business cloud, with Microsoft online, Microsoft hosting of packaged apps, such as the 500,000 seats on MS Exchange e-mail, and Microsoft's Dynamic CRM;
  3. MS Windows Azure. Helm said that Azure isn't strictly your Microsoft apps running in the cloud. Azure will have new apps built with ASP.NET. to run on the Azure hosted Web platform. Currently in beta, Azure apps will run in a tight security "sandbox" to keep from crashing other Azure apps. Helm said it would be necessary to port your current .Net apps to Azure, they can't be run natively on the Azure cloud.

Note: According to Mary Jo Foley’s Microsoft to merge Windows Live and Office Live post of 1/22/2009, the Microsoft Consumer and Business clouds will merge.

• Silicon Valley’s SDForum’s Cloud Services & SOA SIG (formerly the Web-Services SIG) will sponsor a Services in the Cloud Demo Night from 6:30 PM to 9:00 PM on January 27, 2009 at Tibco Software Inc., 3301 Hillview Avenue, Building #2, Palo Alto, CA. Presenters are:

  • Mashery: Clay Loveless, Co-founder & Chief Architect
  • 2 Others TBD

Mashery offers an on-demand API infrastructure.

• Mike Walker promotes the Microsoft's Generation 4 Data Center Vision - the Architects' Perspective post of 12/8/2008 to the DataCenter Blog. In his post of the same name on 1/20/2009 Mike writes:

The goal of Gen 4 is to modularize not only the server and storage components, which a number of companies are already doing, but also to modularize the infrastructure, namely the electrical and mechanical systems.  The real innovation is around the commonality, manufacturing, supply chain and integration of these modules to provide a plug-and-play infrastructure along with modularized server environments.  In addition, it is focused on scaling the infrastructure with the business demands, smoothing capital investment, and driving costs down

• Christopher Hoff’s What To Do When Your "Core" Infrastructure Services Aren't In Your "Core?" post of 1/21/2009 discusses issues surrounding “Infrastructure 2.0” that purports to "...enable greater levels of integration between the disparate layers of infrastructure: network, application, the endpoint, and IP address management, necessary to achieve interconnectedness."

• Lori MacVittie, one of Infrastructure 2.0’s thought leaders who works for F5, posted Cloud Computing: Location is important, but not the way you think on 1/21/2009. She writes:

Location is, in fact, important to cloud computing, but probably not in the way most people are thinking right now. While everyone is concentrating on defining cloud computing based on whether it's local or remote, folks have lost sight that location is important for other reasons.

It is the location of data centers that is important to cloud computing. After all, a poor choice in physical location can incur additional risk for enterprises trusting their applications to a cloud computing provider. Enterprises residing physically in high risk areas - those prone to natural disasters, primarily - understand this and often try to mitigate that risk by building out a secondary data center in a less risky location, just in case. …

So choose your provider carefully, based not only on matching your business and technological needs to the model they support but on the physical location and distribution of their data centers.

• Dana Gardner advocates “cloud-computing neutrality” in his Services consumers and developers must now mount pressure for cloud computing neutrality ZDNet post of 1/21/2009.

• Robert Perry’s Obama Tech Teams Touts Cloud Computing post of 1/21/2009 hosts an Obama transition-team video that Perry describes as follows:

On the eve of his inauguration, President-elect Barack Obama’s transition team released a new video that touts the benefits of cloud computing and government transparency.

The Obama team is “attempting to make government institutions more effective,” Beth Noveck, a law professor and a member of Obama’s Technology, Innovation, and Government Reform team, said on the video posted to change.gov.

Cloud computing, which allows consumers and institutions to access their files and projects anywhere via the Internet “is an important change for the federal government because it is dramatically cheaper than the old fashioned way of doing computing infrastructure,” said team member Andrew McLaughlin, head of global public policy and government affairs for Google, a longtime supporter of cloud services.

• Stephen Walther’s Why ASP.NET Developers Should Care about Windows Azure post of 1/11/2009 explains the potential impact of the Azure Services Platform on building scalable ASP.NET Web sites.

• Jonathan Sapir cautions Don't start from scratch with cloud-based business applications in this 12/30/2008 post and recommends starting out with a hosted vertical software-as-a-service (SaaS) solution such as Salesforce.com.

Pete Cashmore’s Mindblowing Numbers From the Obama Inauguration post of 1/20/2009 demonstrates the need for massive scalability when committing to serve live video streams of important and very popular public events.

The Microsoft Hosting Days team presents The Microsoft Hosting Days 2008 Webcast Series for Pure Play Hosters, Telcos, Independent Software Vendors (ISVs), Resellers (VARs), or System Integrators who weren’t able to attend one of the live North American presentations during January through March 2008. The Webcast series is about:

  • Leveraging the Windows Server 2008 for next-generation Windows-Based Hosting Solutions

  • Turning the growing opportunities for SaaS on Windows technology into business advantage

  • Capitalizing on the wide range of business opportunities available with Microsoft Windows-based Hosting Solutions, including Windows-based Hosting for Applications, Hosted Messaging & Collaboration, Hosted CRM, and Hosted Dynamics

  • Aligning your business with Microsoft’s product roadmap to maximize benefits from the planned testing, release and availability of Microsoft products and services, especially with SharePoint 3.0 and IIS 7.0

  • Selling Business-Class Email to small- and medium-sized businesses (SMBs) using Exchange and the Hosted Messaging and Collaboration (HMC) solution.

Following are the topics covered by one-hour sessions in two tracks:

  • Business Track:
    • Next Generation Hosting
    • Licensing under the Service Provider License Agreement (SPLA)
    • Selling Business E-mail to Small Business (HMC and Exchange)
    • Software + Services - Marketing Best Practices - New!
    • Hosting Opportunities with CRM 4.0
  • Technical Track:
    • IIS 7 for Hosters
    • Hosted Exchange
    • Silverlight for Hosters
    • Windows Server Virtualization
    • Windows Server 2008 - Technical Features and Benefits
    • PHP on Windows

Although not directly related to Windows Azure many of the topics overlap Azure Platform Services and Amazon EC2 running Windows 2003 R2 and SQL Server 2005. (RightScale’s Windows! SLA! Beta bye-bye! All on Amazon EC2 today! post of 10/23/2008 says “Windows Server 2008 is apparently on the  roadmap but not available at present and it’s apparently against the T&C’s to upgrade on your own.”)

The Web Host Industry Review’s When to Choose an Application Service Provider post of 12/19/2004, while a bit dated, remains a good guide to making the move to third-party SaaS, S+S or Web hosting services.

James Urquhart contends that private clouds are to cloud computing as intranet is to Internet in his The argument for private clouds post of 1/19/2009. He writes:

Rich Miller of Data Center Knowledge noted an excellent response by my former Cassatt colleague, Jay Fry to Andrew Conry-Murray of InformationWeek and Eric Knorr of InfoWorld, who contend that there is no such thing as a Private Cloud.

Jay's response is excellent and I absolutely concur. However, I get so frustrated with these "its gotta be off-premises" arguments, that for some time now, I've been trying to figure out a quick and dirty response I can fire off whenever such "puritanism" comes into play.

James’ standard answer to the “no private clouds” argument is:

Internet has Intranet. Cloud Computing has Private Clouds. Similar disruption, localized scale.

I agree.

David Burela has started an Australian Azure Mailing List (ozazure) to which you can subscribe by sending an empty e-mail message to ozazure-subscribe@lists.codify.com and replying to the response.

Patrick Marshall’s Datacenter Managers Doing More with Less article of 1/14/2009 for Redmond Developer News cites Symantec Corp.'s 2008 State of the Data Center study, about which Patrick says:

The study also found that while many datacenter managers are pursuing green IT initiatives, the primary driver for those efforts is cost reduction. Reducing electricity consumption was a goal cited by 54 percent of respondents, followed by reducing cooling costs (51 percent) and a sense of responsibility to the environment (42 percent). …

The Symantec report examined data from a survey in late 2008 of 1,600 datacenter managers in large private- and public-sector institutions located in 21 countries.

Looming IT budget constraints in CY 2009 and possibly 2010 promise that CIOs will take the cloud computing alternative seriously.

Other Cloud Computing Platforms and Services

•• Alin Irimie describes Symantec’s new GoEverywhere “cloud workspace” (beta version) in his Your Cloud Workspace - Symantec GoEverywhere post of 1/26/2009 as

A secure SaaS-based workspace that allows users to access their preferred third party web-based email, IM, office and other online applications from one central online location.

•• Lew Tucker, Sun Microsystem’s CTO for Cloud Computing, trades “The Network is the Computer” for “Your Data Center is Your Computer” in this Sun Cloud CTO: 'Your Data Center Is Your Computer' post of 1/22/2009 by InformationWeek’s Roger Smith.

• James Urquhart asks Is Google App Engine successful? on 1/22/2009 from the Cloud Connect conference that’s being held at the Computer History Museum in Mountain View, Calif. He contrasts Google App Engine (GAE) with Amazon Web Services (AWS) and finds:

Since its announcement in July 2002, the various services contained under the AWS umbrella have received a steady stream of press and accolades. Much of that is due to marketing (and the phenomenal technology evangelism program Amazon put into place), but part of it as well are successful start-ups passing on their own success stories independent of Amazon.

However, [he] spent the day yesterday at the Cloud Connect conference, hosted at the Computer History Museum in Mountain View, CA. Google was much more visible here (in part because they were a Platinum Sponsor), and perhaps more importantly, the "how to" sessions they hosted Wednesday afternoon were packed by interested developers and technologists.

Click for #cloudconnect tweets. Good reportage!

• John Furrier rings in from Cloud Connect with “Build It Because They Are There” - The Real Meaning of Cloud Connect - It’s About Getting Apps Up and Running of 1/22/2009 that describes how Paul Buchheit and his GMail group built GMail “literally in a day.” John writes:

What we have here is a real time web waiting for real time code.  All of the discussion about cloud computing is really about rapid development,provisioning of resources..etc. - in the end a better product for users (hopefully).  Paul talks about this in his post -Gmail turned out pretty good.

Cloud computing allows developers the ability to get “stuff” up fast.  Speed and feedback is critical to success and more important than having some “hardened app” that no one wants.  This is only way to develop in the web today.  Success is about speed and product acceptance is dependent on that speed which drives relevance.  Build a great product and it will work.

• Geva Perry’s Upcoming Cloud-Related Events post of 1/22/2009 lists world-wide cloud-related events from 1/20/2009 to 6/25/2009. He’s also added a permanent events page at http://gevaperry.typepad.com/main/upcoming-cloud-computingrelated-events.html. Included are six Cloud Camp events.

• Alex Iskold explains How and Why Glue is Using Amazon SimpleDB instead of a Relational Database in this 1/21/2009 post. SimpleDB and Azure Table Services share many characteristics, so the post and its references are valuable for Azure developers.

• John Foley’s Cloud Connect: Tackling The Issue Of Cloud Interoperability post of 1/21/2009 describes the recently formed Cloud Computing Interoperability Forum (Twitter: cloudforum; LinkedIn: CCIF Group) whose mission statement, discussion threads, and contact information for the 449 group’s members as of 1/21/2009 is in this Google Group.

• Mindscape now offers an Amazon SimpleDB Management Tools add-in for VS 2008 that enables the firm’s LightSpeed drag-and-drop object/relational mapping (O/RM) tool to use SimpleDB as a data provider. Thanks to David Hayden for the heads-up.

Mike Brittain describes How We Built a Web Hosting Infrastructure on EC2 for video Web site Heavy.com and related sites in this detailed 1/19/2009 post. Mike automated addition of additional capacity so:

[W]e can add new servers to our production pool in under 20 minutes, from the time we call the “run instance” API at EC2, to the time when public traffic begins hitting the new server.  This includes machine startup time, adding custom server config files and cron jobs, rolling out application code, running smoke tests, and adding the machine to public DNS.

It will be interesting to hear whether the Azure team was able to add instances this quickly to any of their large-scale sample sites.

Krishnan Subramanian’s It Is Not A Bloodbath In The Clouds post of 1/19/2009 contradicts Steve Rubel’s Bloodbath in the Clouds Continues as RSS Email Service Shutters post about the demise of RSS FWD, a service that forwards RSS/Atom feeds as e-mail or SMS messages. Krishnan’s point is that cloud computing is closely related to Web 2.0 Software as a Service (SaaS) activities, which are resilient as a whole to recession and likely to survive the current economic downturn. Further, shutdown of a single service doesn’t constitute a bloodbath. Krishnan concludes by pointing out that it is a good policy to investigate the background and analyze the future stability of the SaaS vendors you rely one.

• Update 1/21/2009: I was able to sign up for RSS FWD’s “realtime” notification service, but it didn’t send me a message when I added a new post to the OakLeaf Systems blog today.

Broad Group’s Powered by the Cloud conference will be held in the Lewis Media Centre, Millbank Tower, London on February 2 – 3, 2009. Simone Brunozzi, Amazon Web Service Evangelist for Europe, will participate in the fourth of the following seven panel discussions:

  1. Making Money from Cloud Computing
    Successful business models for providers in the industry
  2. Corporate IT & Cloud Computing
    Opportunities and threats to large corporate technology
  3. Finance, Investors & Cloud Computing
    What are the key opportunities for investors?
  4. Technologies & Cloud Computing
    Obstacles to rollout and the innovations that will overcome them
  5. Consumers & Cloud Computing
    Software, web services and the PC industry: what will change?
  6. Infrastructure and Cloud Computing
    The coming transformation of internet service providers, data centres and the Internet backbone.
  7. Privacy, Regulation, Security and Cloud Computing
    How the industry will maintain the integrity of customer information and the role government will play

Alin Irimie’s Weekly Cloud Application: Eucalyptus post of 1/19/2009 describes the Elastic Utility Computing Architecture for Linking Your Programs To Useful Systems (Eucalyptus) for implementing cloud services on computer clusters. Eucalyptus lets you build cloud services on Amazon EC2.

IBM announced the availability of the LotusLive Engage Beta collaborative cloud-computing service on 1/19/2009, presumably to counter Microsoft’s Windows Live offerings. Following are highlights from the About page:

  • Join the LotusLive Engage Beta
  • Work outside the corporate firewall
  • Connect with companies relevant to your business needs
  • Integrated online Web conferencing with essential online business tools
  • Online social networking and collaboration service designed for business, without intrusive advertisements

IBM claims that LotusLive Connections (Web collaboration services) and LotusLive iNotes (Web-based messaging services) are “coming soon”, but LotusLive Meetings (a.k.a., IBM Lotus Sametime Unyte Meeting) is available to Buy or Try and LotusLive Events (a.k.a., IBM Lotus Sametime Unyte Events) is available to Try.

It appears to me that IBM has much catch-up to do before LotusLive is ready to compete with Windows Live services on a feature-to-feature basis. As Krishnan Subramanian puts it: IBM Inches Further Towards Cloud Computing.

Saturday, October 25, 2008

LINQ and Entity Framework Posts for 10/20/2008+

Note: This post is updated daily or more frequently, depending on the availability of new articles.

••• Updated 10/25/2008 3:30 PM PDT: Minor additions
•• Updated 10/23/2008 9:00 AM PDT: Amazon EC3 (big news), EF, LINQ to SQL, LINQ, Astoria, and SSDS/Cloud Computing additions
• Updated 10/22/2008 3:00 PM PDT: Several additions

••• Links to Streaming PDC 2008 Keynotes from Guy Burstein:

Monday: 10/27
8:30 a.m. - 10:30 a.m.
100 kbps | 300 kbps | 750 kbps

Tuesday: 10/28
8:30 a.m. - 10:30 a.m.
100 kbps | 300 kbps | 750 kbps

Entity Framework and Entity Data Model (EF/EDM)

••• Jarek Kowalski provides a detailed step-by-step guide for Using EF Oracle Sample Provider with EDM Designer on 10/24/2008. Jarek says:

Many people are asking if it is possible to use EFOracleProvider with EDM Designer in Visual Studio 2008 SP1. The answer is yes, but because the sample doesn't include a DDEX provider required for VS integration, there are certain steps that have to be run manually.

Jarek’s guide has 15 steps.

••• Steve Lasker offers a tutorial for delivering SQL Server Compact (SSCE) with EF client applications in his Privately Deploying SQL Server Compact with the ADO.NET Entity Provider post of 10/21/2008. The highly detailed process covers SSCE installations on locked-down computers whose users don’t have Administrator accounts.

•• Bill Vaughn’s Is Microsoft Listening or Open for Output Only? post of 10/22/2008 proposes that Microsoft add semi-mandatory WHERE clauses and remove SELECT * options from SQL-generating wizards.

He also states that devs using the Entity Framework must process schema changes manually. I noted in a comment that “the Entity Data Model Designer has an Update from Database context menu command that opens a tabbed dialog that regenerates the entity classes automatically.”

• Saaid Kahn, a Program Manager on the Visual Studio Pro Tools team, describes how to create an n-tier database application  using ADO.NET Data Services (Astoria) and an Entity Data Model, in this Channel 9 Interview: ADO.NET Data Services in Visual Studio 2008 SP1 of 10/21/2008 by Beth Massi. (Copied from Astoria.)

David Sceppa announced on 10/21/2008 that Sybase's SQL Anywhere ADO.NET Provider Supports the ADO.NET Entity Framework!

Julie Lerman’s Best approach for teaching first exposure to Entity Framework post of 10/20/2008 discusses her choice between “teaching EF from the top down (EDM, LINQ to Entities, Object Query then EntityClient) or bottom up (EDM, EntityClient, ObjectQuery then LINQ to Entities).”

LINQ to SQL

••• Anders Janmyr’s TDD and LINQ to SQL post of 10/25/2008 describes two interfaces, IUnitOfWork and ITable<T>, two classes LinqToSqlUnitOfWork and LinqToSqTable<T> and for testing purposes two additional classes InMemoryUnitOfWork and InMemoryTable<T>, which make it “easy to mock out the Persistence Layer when using LINQ to SQL.”

This is another interesting example of the third-party efforts devoted to improving the testability of LINQ to SQL.

••• Jon Skeet asks What other Enumerable extension methods would you like to see? on 10/23/2008. So far, comments have requested a number of candidates.

•• Michael Minutillo describes an abstraction of LINQ to SQL for his MvcSupportFacility for ADO.NET MVC that uses the Unity Inversion of Control (IoC) container in his detailed Linq Repositories, Lifetime Manaqement and Unity post of 23 October 2008.

• Scott Hanselman’s Informal .NET Subsystem Survey shows use of LINQ to SQL is within about 5% of ADO.NET DataSets (1,734 to 1,887) among the 4,899 responses that comprise his Survey RESULTS: What .NET Framework features do you use? post of 10/22/2008.

• Matt Hunter is close to releasing his base class that supports n-tier, disconnected operation of LINQ to SQL. The LINQ to SQL Entity Base Release Candidate 3 post includes links to LINQ to SQL Entity Base - Disconnected LINQ Version 1.0 Release Candidate 3 of 10/22/2008. The project’s CodePlex home page explains its features.

This release features bidirectional serialization with the DataContractSerializer and the IsReference attribute for many:one associations. It requires a licensed version of VS 2008 SP1, not the Express edition.

• Jim Wooley’s Updated source for ThinqLinq now available post of 19/21/2008 offers 18 months of accumulated updates to his LINQ-based blogging application.

 Cirilo Meggiolaro Tip of the day #3 - Getting details of a LINQ change conflict exception explains an “easy way to get a list of tables and columns that have thrown the exception. The [sample] code … catches the exception and loop through conflict objects to generate a full report.”

LINQ to Objects, LINQ to XML, et al.

Agnes Molnar (Aghy) reports on 10/25/2008 that Linq4SP - RC2 is available to download! from here. Her post includes a list of RC1 bugs fixed in RC2.

•• LinqMaster’s How to Get a List of Installed Applications with LINQ post of 10/22/2008 shows you how to reduce the number of lines of C# 2.0 code in half with LINQ to Objects.

• Jay Sawyer conducts a series of performance tests against LINQ to Objects and observes some unexpected results in these two recent posts:

Part II includes comparisons with DataViews, filtered DataSets, LINQ to Objects, and LINQ to SQL.

Eric White’s Creating Data-Bound Content Controls using the Open XML SDK and LINQ to XML explains how to “take a document that has un-bound content controls, generate a custom XML part automatically (inferring the elements of the custom XML from the content controls), and then bind the content controls to the custom XML part.”

Bart De Smet “The C# Programming Language Third Edition” and thoughts on language evolution is a lengthy essay on the history of C# 2.0/3.0 features and features to be expected in C# 4.0.

In his LINQ to Anything – Channel 9 interview and a few more thoughts, Bart expands on Channel9’s announcement with links to related blog posts. He also “elaborate[s] a bit on fan-in and fan-out and [his] statement on the square infinity possibilities of LINQ, and take[s] a look at the following slides from a recent presentation [he] delivered on the topic” of LINQ to ∞ Squared “Proof Obligation” and “Function Composition.”

Jim Wooley’s LINQ is not an excuse for sloppy code post of 10/20/2008 warns developers to limit the number of elements returned to LINQ to SQL projects by LINQ queries by always including a Where predicate or Skip/Take function pairs.

ADO.NET Data Services (Astoria)

••• Pablo Castro mentioned but refused to describe an unlisted PDC 2008 stealth session in Channel 9’s Astoria Design Walkthrough: No design... just plugging our PDC talks! video of 10/24/2008. The session turns out to be ES07 Modeling Data for Efficient Access at Scale (Wed 10/29 | 1:15 PM-2:30 PM | 403AB):

Learn how to model data for cloud services. Topics include: mapping common data idioms to tables, tuning data models for common access patterns, and creating efficient queries.

The interview also includes uninspired descriptions of Pablo’s TL08 Offline-Enabled Data Services and Desktop Applications (Wed 10/29 | 3:00 PM-4:15 PM | 408) and Mike Flasko’s TL07 Developing Applications Using Data Services (Tue 10/28 | 1:45 PM-3:00 PM | 151) published presentations.

••• Phani Raju takes on one:many associations in his Working with associations in ADO.NET Data Services , Part 2 tutorial of 10/23/2008. Part 1 of the series, Working with Associations in ADO.NET Data Services, of July 2, 2008 covered one:one associations.

•• Pablo Castro describes several first-priority scenarios for “Astoria Online” in his Astoria futures: offline-enabled data services post of 10/22/2008:

  • Outlook-style 1-tier applications that connect to a local data store (presumably SQL Server Compact v3.5 SP1) and synchronize with an online data store such as SQL Server Data Services (SSDS), SQL Server 2008 running under Windows Server 2008 on Amazon EC2 or from a Microsoft data center.
  • Independent clients and servers in a synchronization relationship, such as a service that’s available for Web-based synchronization only.
  • Local replicas of cloud-stored data, such as SSDS entities stored locally on SSCE.
  • Data consolidation by synchronizing slices of data from multiple cloud-stored sources.

Pablo’s Astoria Design Walkthrough: Thinking of a future with sync & offline video is a preview of his Offline-Enabled Data Services and Desktop Applications session at PDC 2008 (Wed 10/29 | 3:00 PM-4:15 PM | 408A).

• Scott Hanselman’s Informal .NET Subsystem Survey shows use of ADO.NET Data Services is substantially greater than that of Entity Framework based on the 4,899 responses that comprise his Survey RESULTS: What .NET Framework features do you use? post of 10/22/2008.

Question: Did the respondents simultaneously select a LINQ to SQL or Entity Framework data source for Astoria? Doesn’t look like it to me from the data.

• Saaid Kahn, a Program Manager on the Visual Studio Pro Tools team, describes how to create an n-tier database application  using ADO.NET Data Services (Astoria) and an Entity Data Model, in this Channel 9 Interview: ADO.NET Data Services in Visual Studio 2008 SP1 of 10/21/2008 by Beth Massi. (Copied from EF.)

Phani Raju’s Accessing Cross-Domain ADO.NET Data Services from the Silverlight Client Library of 10/20/2008 discusses guidelines for cross-domain access using the Silverlight Client Library

Gil Fink describes Building an Ajax Client for ADO.NET Data Services to complement his previous Astoria posts:

Roy T. Fielding’s REST APIs must be hypertext-driven post of 10/20/2008 takes the following position on the rules a REST API should follow:

  1. A REST API should not be dependent on any single communication protocol, though its successful mapping to a given protocol may be dependent on the availability of metadata, choice of methods, etc. …
  2. A REST API should not contain any changes to the communication protocols aside from filling-out or fixing the details of underspecified bits of standard protocols, such as HTTP’s PATCH method or Link header field. …
  3. A REST API should spend almost all of its descriptive effort in defining the media type(s) used for representing resources and driving application state, or in defining extended relation names and/or hypertext-enabled mark-up for existing standard media types. …
  4. A REST API must not define fixed resource names or hierarchies (an obvious coupling of client and server). Servers must have the freedom to control their own namespace. …
  5. A REST API should never have “typed” resources that are significant to the client. Specification authors may use resource types for describing server implementation behind the interface, but those types must be irrelevant and invisible to the client. …
  6. A REST API should be entered with no prior knowledge beyond the initial URI (bookmark) and set of standardized media types that are appropriate for the intended audience (i.e., expected to be understood by any client that might use the API). …

The way I read the full version of Fielding’s six rules, Astoria isn’t a RESTful API. Perhaps Pablo Castro would care to contest my conclusion or, for that matter, Fielding’s criteria.

ASP.NET Dynamic Data (DD)

••• Rob Conery’s ASP.NET MVC Storefront Part 23: WebForms and Dynamic Data of 10/24/2008 announces the start of a new Commerce Starter Kit v3.0 that’s uses “components and business logic based on the same components and business logic used for MVC Storefront but with a traditional WebForms UI” that will use LINQ, support full localization, and other new features described in J Sawyer‘s Commerce Starter Kit 3.0 – CSK Reprise post of the same date. The project will include an administrative site based on DD and LINQ to SQL.

You can watch this 15:00 video with Rob and J that describes the project. Support for CSK 3.0 will be part of J’s job description as a Microsoft developer evangelist.

••• Steve Naughton continues his DD posts with a question from the Dynamic Data forum in his Dynamic Data - Hiding Tables on the Default.aspx page post of 10/24/2008.

Steve Naughton’s Dynamic Data - Hiding Columns in selected PageTemplates of 10/20/2008 returns to IAutoFieldGenrators, attempts to specify the page template on which to hide columns.

SQL Server Data Services (SSDS) and Cloud Computing

••• David Robinson of the SSDS team says in his 2 Days to PDC2008!!!!!!!!!!!!! post of 10/24/2008:

We have some really super, pimped out, mack daddy, completely awesome stuff coming. Both in the teams presentations and in new features for Sprint 5. I just sent out the new features list to some internal softies for "Word Smithing" which you all should see in a few days, and the list is long and chock full o' goodies.

PS - I promise much more posting after Monday.

Promises, promises???

••• Ludwig Siegele analyzes the trend to mobile datacenters (Microsoft), virtualization (VMWare), and cloud computing (Amazon Web Services and Google App Engine) in his Where the cloud meets the ground: Data centres are quickly evolving into service factories special report for the 10/23/2008 issue of the Economist.

••• Roger Jennings reports another spurious attempt to register a trademark on “Cloud Something” in Arista Networks Claims “Cloud Networking” As Its Trademark of 10/24/2008.

••• Alan Williamson will conduct a one-day, hands-on Cloud Computing Bootcamp on 11/29/2008 in conjunction with Sys-Con’s Cloud Computing Expo at San Jose’s Fairmont Hotel. The (pricey) registration fee rises from $1,695 to $1,795 tomorrow. (List price is $1,995.)

•• Jeff Barr reports the following about Amazon EC2, Windows 2003 Server, and SQL Server 2005 in his Big Day for Amazon EC2: Production, SLA, Windows, and 4 New Capabilities post of 10/23/2008:

  • Amazon EC2 is now in full production. The beta label is gone.
  • There's now an SLA (Service Level Agreement) for EC2.
  • Microsoft Windows Server 2003 is now available in beta form on EC2.
  • Microsoft SQL Server 2005 is now available in beta form on EC2.
  • We plan to release an interactive AWS management console.
  • We plan to release new load balancing, automatic scaling, and cloud monitoring services.

It will be interesting to see whether Microsoft’s corresponding offering (or SSDS) will be price-competitive and when it will go online with an SLA.

It’s curious that Amazon is hosting non-current versions of Windows Server and SQL Server, which isn’t well-advertised on the AWS site. Perhaps Microsoft’s licensing terms were better than those for the 2008 versions.

Mary Jo Foley chimes in with Amazon battens down the hatches before Microsoft’s cloud launch next week and Werner Vogels posts Using the Cloud to build highly-efficient systems.

It wasn’t such a big day for Amazon stock: Down as much as 13% today (Thursday).

For a synopsis of pricing, see my Amazon Web Services Announces SLA Plus Windows Server and SQL Server Betas for EC2 post. That post hit Techmeme at 3:05 PM EDT

•• Jake Sorofman’s The Cloud Computing Adoption Model post of 10/23/2008 is a “context for thinking strategically about cloud computing” that’s “[l]oosely modeled after the Capability Maturity Model (CMM) from the Software Engineering Institute (SEI) at Carnegie Mellon University.” Note that CMM has been superceded by CMM-Integration (CMMI).

• Frank Gens predicts the Cloud Computing market will grow from $16 billion in 2008 to 42 billion in 2012, an annual compounded growth rate of 27% in IDC’s IT Cloud Services Forecast - 2008, 2012: A Key Driver of New Growth of 10/8/2008. IDC includes business applications, application development/deployment, system infrastructure software, storage, and servers expenditures in the estimates.

You can watch a three-minute video summary of the prediction and download slides at Cloud Computing |Preparing for the Next 20 Years of IT.

SSDS Team: Update Announcement Coming at PDC 2008 (10/20/2008)

The following message hit my inbox on 10/20/2008:

On October 27, 2008 we will be announcing, the next upgrade of SSDS at the PDC2008 conference in Los Angeles. In order to support this announcement, at that time we will update the documentation on the SSDS DevCenter site to include the new features in this upgrade. We will follow up on our PDC announcements, on the first day of the conference. …

The SSDS upgrade to be announced at PDC will be made available to you in early November.

Thank You,

The SSDS Team

Frank Gens’ IDC on “the Cloud”: Table of Contents post of 9/23/2008 offers links to recent IDC research on Cloud Computing:

SQL Server Compact (SSCE) 3.5 and Sync Services

••• Steve Lasker offers a tutorial for delivering SQL Server Compact (SSCE) with EF client applications in his Privately Deploying SQL Server Compact with the ADO.NET Entity Provider post of 10/21/2008. The highly detailed process covers SSCE installations on locked-down computers whose users don’t have Administrator accounts. (Copied from EF.)

Liam Cavanagh reports on 10/20/2008 that the updated RTM1 version of the Sync Framework download reported in last week’s LINQ and Entity Framework Posts for 10/13/2008+ item is Not an Updated Version of Microsoft Sync Framework.

Anthony Carrabino’s SQL Server 2008 Feature Pack Released post of 10/18/2008, which first appeared 10/21/2008 in the Data Platform Insider blog, notes that the Feature Pack includes SQL Server Compact SP1 and the Microsoft Sync Framework.

And, for what it’s worth, Euan Garden reports that SQL Server 2008, Reportbuilder RTMs on 10/20/2008 (but it’s not in the Feature Pack).

Miscellaneous (WPF, WCF, MVC, Silverlight, etc.)

••• Aaron Skonnard delivers on 10/26/2008 two new episodes of his endpoints.tv WCF Screencast series on Channel9:

••• Mike Taulty posted on 10/24/2008 detailed code samples for the first two of the three following questions that arose at his MSDN “Roadshow Rerun” in London

  1. Can ObservableCollection<T> cope with a particular element being replaced? Not Added. Not Deleted. Replaced.
  2. How to work with lookup fields in a database and data-bind to them?
  3. How to take action when an ItemsControl creates an item and get hold of the item's UI elements?

••• John Papa’s Day of Silverlight 2 Recap post of 10/24/2008 has a link to the slide deck for his Day of Silverlight 2.0 presentation in Tampa, FL. Not surprisingly, his

3.5-hour presentation [focused] on Silverlight 2 data binding, development techniques, using it with SOAP, ASMX, WCF, REST, 3rd party services, cross domain policies, debugging tips, and ADO.NET Data Services.

The slides are quite informative but sample code would be even more so. So I’ve requested in a comment that John post the demo source.

•• Microsoft has assembled a new SOA & Business Process site that, at least so far, consists primarily of agitprop for and links to existing Microsoft products and services. Hopefully, the site will gain some developer-oriented content after PDC 2008.

Rob Conery, Scott Hanselman and Phil Haack are writing Professional ASP.NET MVC for WROX/Wiley, scheduled to hit the shelves in February 2009, according to Rob’s ASP.NET MVC DropDownList and HTML Attributes post of 10/21/2008.

Mike Ormond’s ASP.NET MVC and Scottish Developers (Demo) post of 10/20/2008 includes a link to his demo code for the recent Scottish Developers User Group meeting.