# Thursday, November 27, 2008

Change selected cell in DataGridView on right click

I wanted to add a context menu to a DataGridView, allowing the user to perform an action on a specific row. However, right clicking in a DataViewGrid does not change the selected row. This can be achieved by adding the following code to the CellMouseDown event (the name of my grid is dgvWorkflows):

private void dgvWorkflows_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e)
{
    if (e.ColumnIndex >= 0 && e.RowIndex >= 0)
    {
        dgvWorkflows.CurrentCell = dgvWorkflows.Rows[e.RowIndex].Cells[e.ColumnIndex];
    }
}

#    Comments [0] |
# Wednesday, November 12, 2008

Workflow Foundation, fault handlers and self recovering state machines

We had an interesting workflow issue the other day. For some inexplicable reason our state machine workflow was terminated. After digging around in the database trying to reconstruct what might have happened we finally figured it out:

We have a transaction scope activity which sends an update to the database. The update failed and the exception cause the fault handler on the activity to kick in. The fault handler changed the state of the state machine to custom state called 'TechnicalError'. We explicitly modeled this state because it allows our administrators to recover a workflow from a technical error and essentially restart the workflow. In the InitializeState of the 'TechnicalError' state we wanted to update some data in the database. This also failed, since the cause of the original error was that we had lost connectivity to our database.

Next?

Since we had no fault handler on this database action the workflow crashed. Since connectivity to our workflow persistence database was also lost we now have a situation where the workflow in memory is inconsistent with the data in our line of business application database and is also inconsistent with the last persisted state in the workflow persistence database.

Next?

The workflow runtime never crashed several minutes later the workflow persistence database came back online and the in memory state of the workflow (which was terminated) was sync-ed with the workflow persistence database. However, our line of business database was never updated. The timestamp on the updates in the workflow persistence database where minutes apart from the last updates in the line of business database, which made it hard to reconstruct what had happened.

Solution?

We now have a fault handler on the initialize state of the 'TechnicalError' state. If the workflow persistence database OR the line of business application database is unavailable then a delay is introduced. And the workflow retries to transition to the TechnicalError state. This way the workflow will never ever terminate. The only scenario left is where the machine running the workflow is turned off. If this happens then the workflow will recover from it's last save point and life should be good.

#    Comments [0] |

MSDN Roadshow is coming to Augusta

 Roadshow-September-2008_thumb

The Maine Developer Network is proud to announce that the Northeast MSDN Roadshow by Chris Bowen and Jim O'Neil will once again make it as far north as Augusta!

Don't hesitate: sign up today!

 mdn_logo

#    Comments [0] |
# Saturday, November 01, 2008

LINQ to SQL is dead

It would appear that LINQ to SQL is running on a dead end track.

At PDC the announcement was made that no more investments in LINQ to SQL are made and the Entity Framework will absorb any features that LINQ to SQL has and that are worth preserving.

The following message from Tim Mallalieu says it all:

Is LINQ to SQL Dead?

We will continue make some investments in LINQ to SQL based on customer feedback. This post was about making our intentions for future innovation clear and to call out the fact that as of .NET 4.0, LINQ to Entities will be the recommended data access solution for LINQ to relational scenarios. As mentioned, we have been working on this decision for the last few months. When we made the decision, we felt that it was important to immediately to let the community know. We knew that being open about this would result in a lot of feedback from the community, but it was important to be transparent about what we are doing as early as possible.  We want to get this information out to developers so that you know where we’re headed and can factor that in when you’re deciding how to build future applications on .NET.  We also want to get your feedback on the key experiences in LINQ to SQL that we need to add in to LINQ to Entities in order to enable the same simple scenarios that brought you to use LINQ to SQL in the first place.

#    Comments [2] |
# Friday, October 31, 2008

Live Mesh goes to world wide beta

Live Mesh has gone from Tech Preview to official beta status. This also means it has gone world wide!

"Worldwide availability. We’ve removed the limits on what countries are able to sign up to use Live Mesh. We previously had limitations in place so that we could complete our testing with various language and locale settings, and now that work is indeed complete (with the caveat of course that for now the mobile client, as mentioned above, is not actually available worldwide)."

Yesterday I watched Don Gillet's PDC session on building a Mesh Application. It looks very easy.

My main concern with all this data in the cloud is securing my data. I'm thinking I may need to implement some sort of EncryptedDataEntry class which derives from DataEntry. I'll think about it some more...

#    Comments [0] |
# Tuesday, October 28, 2008

Windows Live ID Becomes OpenID Provider

In the past I looked at the OpenID standard in relation to Cardspace and AOL. Now Microsoft has committed to making Windows Live ID (previously known as Microsoft Passport) support the OpenID initiative.

"Beginning today, Windows Live ID is publicly committing to support the OpenID digital identity framework with the announcement of the public availability of a Community Technology Preview (CTP) of the Windows Live ID OpenID Provider."

The Live Services page does not mention Cardspace in relation to OpenID, but it stands to reason that as an OpenID provider Microsoft will somehow offer Cardspace support as well, just like www.myopenid.com.

#    Comments [0] |
# Monday, October 27, 2008

Microsoft Cloud Platform

Windows Azure is the name Microsoft has given to the cloud based platform. If you're not at PDC (like me) then go here for more information: http://www.microsoft.com/azure/services.mspx.

"The Azure™ Services Platform (Azure) is an internet-scale cloud services platform hosted in Microsoft data centers, which provides an operating system and a set of developer services that can be used individually or together. Azure’s flexible and interoperable platform can be used to build new applications to run from the cloud or enhance existing applications with cloud-based capabilities. Its open architecture gives developers the choice to build web applications, applications running on connected devices, PCs, servers, or hybrid solutions offering the best of online and on-premises."

The Cloud Computing and Services Platform Diagram

Looks like my personal point of interest, Live Mesh, is part of this platform:

"Live Services includes Mesh technologies for synchronizing user’s data and extending web applications across multiple devices."

#    Comments [0] |
# Sunday, October 26, 2008

LINQ to SQL cross database queries

After discovering that the LINQ to SQL Designer will only support tables from a single data source I set out to manually implement a cross database query using two data contexts.

The result is the following query which joins orders in the OrderDB to products in the VideoGameStoreDB.

public List<Order> FindOrders( string typename )

{

    try

    {

        var productdb = new VideoGameStoreDBDataContext();

        var orderdb = new OrderDBDataContext();

 

        var query  = from o in orderdb.Orders

                     join p in productdb.Products on o.ProductID equals p.ProductID

                     where p.ProductType.ProductTypeName.Contains( typename )

                     select o;

 

 

        return query.ToList();

    }

    catch ( Exception exception )

    {

        Trace.WriteLine( exception );

        throw;

    }

}

 

LINQ to SQL is unable to resolve this query, even though both databases sit on the same server. The compiler will however not warn you not to do this, instead a runtime exception with message 'The query contains references to items defined on a different data context.' occurs.

In a scenario like this the only solution appears to be to write a stored procedure which can perform the cross database query and use that stored procedure from a data context.

#    Comments [1] |

LINQ to SQL Designer supports just one connection

The LINQ to SQL Designer supports just one connection, which makes sense since a LINQ DataContext is scoped to one connection. The designer does offer to change the connection string for you, but I guess making cross database queries is not possible using the designer.

The following message is what you get when dragging a table from a second data source onto the design surface.

image

#    Comments [0] |

LINQ to SQL does not support UDT's

I just discovered that the LINQ to SQL Designer does not support User Defined Types.

The following message appears when I try and add a table from my database to my design surface. The Customer table in question has a UDT named 'Point' to specify the GPS location of the business.

image

#    Comments [0] |

Daylight Savings

Daylight savings for Europe started today. The United States does not switch to daylight savings until the first Sunday in November (this year: Nov. 2nd 2008). Between now and then the time difference between the States and Europe is one hour less.

#    Comments [0] |

Extreme Makeovers: a new .NET logo!

At PDC this week Microsoft is announcing a new logo for .NET.

Looks very refreshing!

newdotnetlogo

NET_v_rgb_2[1]

NET_h_rgb_2[1]

#    Comments [0] |
# Saturday, October 25, 2008

LINQ to SQL external mapping file

With LINQ to SQL you can choose to use an external mapping file, allowing you to map SQL statements to CLR objects (also referred to as POCO, Plain Old CLR Objects). Doing so means you do not need to adorn your classes with attributes.
Here's a little sample of how to do this.

public class Supplier
{
    public int ID { get; set; }
    public string Name { get; set; }
}
 
public List<Supplier> GetSupplier( string name )
{
    SqlConnection conn = new SqlConnection( cConnectionString );
 
    XmlMappingSource xms = XmlMappingSource.FromUrl( @"mapping.xml" );
 
    var db = new DataContext( conn, xms );
 
    Table<Supplier> Suppliers = db.GetTable<Supplier>();
 
    var query = from s in Suppliers
                where s.Name == name
                select s;
 
    return query.ToList();
}
 
 

The XML can be as simple as:

<?xml version="1.0" encoding="utf-8"?>
<Database Name="VideoGameStoreDB"
          xmlns="http://schemas.microsoft.com/linqtosql/mapping/2007">
  <Table Name="dbo.Supplier" Member="Supplier">
    <Type Name="Supplier">
      <Column Name="SupplierID" Member="ID" />
      <Column Name="SupplierName" Member="Name"  />
    </Type>
  </Table>
</Database>
 

You can use SQLMetal (a command line tool included with Visual Studio) to generate a mapping file.

#    Comments [0] |
# Wednesday, October 15, 2008

SDN Conference 2008

The SDN Conference 2008 was a great success, thanks to all the speakers and attendees for making it so!

Beth Massi has a great write up on the day after the conference, the traditional Holland Tour: http://blogs.msdn.com/bethmassi/archive/2008/10/14/holland-tour.aspx.

Time to start working on SDN Conference 2009 :-)

#    Comments [0] |
# Monday, September 29, 2008

Visual Studio Team System Developer & DBPRO Edition become one

Microsoft has put up a page to inform us about the next version of Visual Studio,  it is called Visual Studio Team System 2010.

Part of the new deal is a change in licensing, the fun part is: the licensing change takes effect on October 1st 2008!!!

Those of you who subscribe to MSDN and will now have access to both the Developer and DBPro edition of VSTS:

Better Together – Visual Studio Team System Development Edition and Database Edition
In recognition of the increased need to integrate more of the lifecycle members together, we will provide a unified Development and Database product in Visual Studio Team System 2010. Beginning October 1, 2008 Development Edition and Database Edition MSDN subscribers will have access to both products.

#    Comments [0] |
# Saturday, September 27, 2008

Promoting DiscountASP.NET

I just answered an email asking for a referral to a good hosting place, thought I'd blog about my experience with my hosting provider.

I've been running my blog and website with DiscountASP.NET for the last 3 years and never had an incident. They offer ASP.NET 3.5 hosting and usually offer options to test beta versions of ASP.NET or SQL Server as well, which is something I like. They're not the cheapest, but in my opinion, worth the money.

Click the banner to go to their site.

In the spirit of transparency: The link contains a referral code which will generate a kickback for me :-)

#    Comments [0] |

Maine Developer Network & MSDN Roadshow

The Maine Developer Network is helping out the MSDN Roadshow. Thanks to Shawn we're able to have the MSDN Roadshow come as far north as Augusta, ME. On October 3rd the Developer Evangelists for the New England region: Chris, Bob and Jim will be up (or down) in Augusta to present the latest and greatest .NET technologies. A full day of FREE training, open to everyone!

Sign up here: http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032387795&culture=en-US

Topics are:

  • Understanding the ADO.NET Entity Framework
  • Discovering Dynamic Data
  • Exploring Internet Explorer 8
  • RoboLunch
  • UI, UX, U Confused?
  • A RESTed Development
  • Befriending Unit Testing

Location:

Riverview Psychiatric Center
250 Arsenal Drive
Sebago Room Augusta Maine 04332-0011
United States

There will be give aways and ofcourse plenty of fun people to meet!

#    Comments [0] |
# Saturday, September 06, 2008

Strive to improve

Here is a good reason to always keep improving:

:-)

#    Comments [1] |
# Wednesday, September 03, 2008

SDN Conference 2008

Registration for the SDN Conference 2008 is open. Visit: www.sdc.nl

SDN Conference

#    Comments [1] |
# Saturday, August 30, 2008

Workflow designer faster in SP1

According to Matt Winkle some performance enhancements have been made to the Workflow designer in Visual Studio 2008 SP1. Strangely enough no mention of these improvements is made in the release notes. I wonder if they made it in.

Matt Winkle: "In .NET 3.5 SP1, there are no features introduced, but there have been a number of internal improvements made, including some substantial perf gains in the WF designer (for certain scenarios)."

#    Comments [0] |