Dean's Development Cube

Troubleshooting Relative URI’s in Silverlight Projects

2011-11-22T16:19:00.001-05:00

My Visual Studio Solution contains a minimum of a project for the Silverlight application and a project for the web page that hosts the Silverlight application. The Silverlight application reads and rights files to the local file system.

The solution is structured similar to this:

mySolution (has a minimum of the following two projects)

MyApplication.Web - the project that hosts the Silverlight xap file (could be a simple index.html page and Silverlight.js javascript page)
MyApplication - the Silverlight application project

When debugging in Visual Studio, the files that the Silverlight application is trying to read from are not necessarily available to the application depending on how you structure the application and which project you put the data files into initially.

While under development, intuition may lead you to believe that if it is the Silverlight application that is actually reading the files, the Data folder should be placed in the Silverlight application project root, not the web project. That would be incorrect.

Example 1

new Uri("/Data/ReadThisFile.xml", UriKind.Relative)

UriKind.Relative with a leading slash (/) in front of the Data folder is relative to the page that is hosting the XAP file. In my solution this is the project root of the web application, not the Silverlight project. The data file would be located at f:\mySolution\myApplication.Web\Data\ReadThisFile.xml

Example 2

new Uri("Data/ReadThisFile.xml", UriKind.Relative)

Without the leading slash in front of the Data folder as in this example, the file is expected to be relative to the Silverlight xap file. In my solution the xap file is in the default location, the ClientBin folder, which is a sub folder of the project root of the web application. The data file in this case would be located at f:\mySolution\myApplication.Web\ClientBin\Data\ReadThisFile.xml

Troubleshooting with Process Monitor

If you are getting File not found exceptions, the file isn’t where your application thought it was supposed to be. A relatively easy way to find out where the application is looking for the file is to use SysInternals Process Monitor.

Once you install and run the Process Monitor, you can set the filters to narrow down the captured events to locate the path to the file. The primary filters I used were “Result is not SUCCESS” and “Path contains ReadThisFile.xml”

The filtered results would look similar to the following, if the the application throws a File not found type of error. (click to enlarge)

Could not load file or assembly System.IdentityModel

2011-11-21T10:21:00.001-05:00

I added functionality to a Silverlight application I created several months ago and when I attempted to run it in debug mode, I received this error:

Could not load file or assembly 'System.IdentityModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'System.IdentityModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.

I found very little evidence of why I was getting this error now. My search results did not turn up much useful information either. I did find this link on Stack Overflow, so on a whim I revised the web.config of the web project that hosts the Silverlight application to a add a clear statement to the assemblies node.

<configuration>

    <system.web>

      <compilation debug="true" targetFramework="4.0" >

        <assemblies>

          <clear/>

        </assemblies>

      </compilation>

    </system.web>

</configuration>

After making that change, the assembly loads without errors. This was on my development workstation. The application did not throw any errors on the production server after publishing it without the clear statement in the web.config.

10 Reasons to Join a PASS or .Net User Group

2011-10-26T10:36:00.001-04:00

I am a member and leader at multiple chapters of technology-based international professional associations, like PASS (Professional Association for SQL Server) and INETA. Through that affiliation, I have experienced many, many benefits that such a small percentage of our industry takes advantage of.

Great people – Attendees, speakers, organizers, volunteers, sponsors, and venue hosts. Attend regularly and I promise you will make life long friends.
A place to talk shop with peers, learn about other organizations and practices, scope out job opportunities, help others with their challenges, and mentor people new to the field.
Great content – free training, new technology previews, and deep dives into specific topics.
Access to experts – speakers almost always provide their contact info and give you permission to ask questions outside of the presentation. Get help on your challenges from other attendees during the social networking time. Sometimes you even get to meet Industry celebrities and national conference presenters, such as Brent Ozar, Brad McGehee, and Scott Guthrie.
Food and beverage
Free swag – books, software (Development software, Operating Systems, 3rd party tools, Xbox games, and more), hardware (keyboards, mice, web cams, etc.), training vouchers, discount coupons, quirky and unusual items (such as Bucky Balls), travel mugs, tote bags, back packs, and the list goes on.
News and announcements about other events and happenings in the industry – training conferences like the PASS Summit and SQL Cruise, all day training opportunities, such as Day of .Net, Codemash, SQL Saturday, virtual training events, contests, free eBooks promotions, Job opportunities.
Save money travelling to regional training or events by carpooling with your fellow user group friends.
Opportunities to present – show off your own proficiency in your craft, get experience to prepare you to speak on regional or national level, establish credibility as a teacher/communicator.
Opportunities to be a board member or volunteer to hone your leadership and logistical skills enhances your career marketability. Also, volunteering or leading a local chapter or regional event is great way to prepare you to become a board member on a national scale, if that is of interest to you.

Really there are few reasons not to attend, join, volunteer, or lead a professional organization. If you’re interested in professional organizations in general, read my popular post about 10 reasons to join a professional association.

What have I missed?

SQL Server Compatibility Level Testing

2011-10-13T16:37:00.001-04:00

I stumbled on interesting version compatibility issues while working with a database in SQL Server 2008R2. The database was originally developed in SQL Server 2000. It was upgraded to MSSQL 2008R2 as a part of a virtualization initiative, however, the Compatibility Level was still set to 80 (MSSQL 2000).

After seeing columns of type VARCHAR(MAX), it got me wondering about compatibility issues since there was no VARCHAR(MAX) in 2000.

Anomaly #1

Doing some research I found this post with a script for Testing all procs before upgrading to Compatibility Level 90. I ran it on the database (while still set to Compatibility Level 80) and it reported a stored procedure that had a syntax error that was not caught by the syntax checker in MSSQL 2000, 2005, or 2008R2. The SQL is below:

SELECT     ChangeLogID

    , CourseID

    , RecordID

    , RecordTable

    , ChangeType

    , ModifiedDateTime

    , ModifiedByEmpNo

    , CASE RecordTable

        WHEN 'Course' THEN

        ( SELECT CourseName

          FROM Course

          WHERE CourseID = cl.CourseID)

        WHEN 'Lesson' THEN

        ( SELECT LessonName

          FROM Lesson

          WHERE LessonID = cl.LessonID)

         WHEN 'Content' THEN

        ( SELECT ContentName

          FROM Content

          WHERE ContentID = cl.ContentID)

        ELSE "None"

    END AS RecordName

FROM         ChangeLog cl

WHERE     (CourseID = @CourseID)

The error message was: Invalid column name 'None'. Note the quotation marks around “None” after the ELSE. Strangely, the stored procedure executes without error. It only detects the syntax error on CREATE, not when I ALTER the stored procedure.

Anomaly #2

Using the same database described above, the compatibility error detection script I used (while still having a Compatibility Level of 80) did not detect the error:

Msg 8127, Level 16, State 1, Procedure GetNextLessonForLessonNo, Line 49
Column "Lesson.LessonNo" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.

The SQL generating this error is:

SELECT     TOP 1 MIN(L.LessonNo) AS LessonNo

    , L.LessonID

    , L.CourseID

    , L.LessonName

    , L.LessonDesc

    , COUNT(Content.ContentID) AS NContentPages

FROM     Course C

         INNER JOIN Lesson L

            ON C.CourseID = L.CourseID

         LEFT OUTER JOIN Content

            ON L.LessonID = Content.LessonID

WHERE     (L.LessonNo > @LessonNo

       AND L.CourseID = @CourseID)

GROUP BY L.LessonID

    , L.CourseID

    , L.LessonName

    , L.LessonDesc

ORDER BY L.LessonNo

This error is not detected in SSMS (in a query window, or by running the detection script) until the Database Compatibility Level is changed from 80 (MSSQL 2000) to 100 (MSSQL 2008). The issue can be resolved in SQL Server 2008 by adding L.LessonNo to the GROUP BY clause.

photo credit: somegeekintn / CC BY 2.0

Image button link options in ASP.Net MVC3

2011-09-27T13:07:00.001-04:00

There are several ways to skin this cat, but below are a couple options for using an image, in lieu of text, as a link to content. There are other overloads for the Url.Action and the Html.ActionLink, but in this example I was linking to a different controller passing in the integer id of the item to display a list of child records. The "STEPS” image is displayed if the parent record has child records.

Url.Action method

<a href='@Url.Action("ActionName", "ControllerName", new {Id = item.ID}) '><img src='@Url.Content("~/Content/Images/buttonimage.gif") ' alt="View Detail" border="0"  /></a>

Html.ActionLink method

@Html.ActionLink(" ", "ActionName", "ControllerName", new { Id = item.ID }, new { @class = "steps-button", alt = "View Detail", title = "View Detail" })

Note that the first parameter in the action link is a space (because I didn’t want any text to show over the button background image) and the first argument cannot be null or empty.

In the site CSS layout I added the following steps-button class that adds the image to the link as a background image.

a.steps-button

    background: url(../Content/Images/buttonimage.gif) no-repeat top left;

    width: 14px;

    height: 44px;

    display: block;

Using jQuery datepicker with MVC3 textboxes

2011-09-14T12:26:00.001-04:00

This post addresses two issues:

Using the built-in ASP.NET Development Server vs. IIS to render the datepicker. If you are using IIS, skip to the second section.
Dependencies necessary to get the jquery ui datepicker to work in an MVC3 project.

ASP.NET Development Server

I repeatedly have issues with AJAX controls (like the ModalPopup control) rendering with the correct styles using the ASP.NET Development Server vs. IIS. The jquery datepicker is no exception, but this time it surfaces as the following error “Microsoft JScript runtime error: Object doesn't support this property or method” in the jquery-1.5.1.min.js, which isn’t very helpful for troubleshooting.

On a hunch, I decided to configure the project as an application in IIS and access it via localhost/appname instead of the dynamically addressed port of the ASP.NET Development Server - giving me a more meaningful error to troubleshoot.

jQuery UI dependencies

Using the IIS served application, I received the tiny warning triangle in the lower left corner of IE that indicates a javascript error, “Message: Object doesn't support this property or method”. The offending line of code was $("#EstDateStarted").datepicker();.

My project was based on the standard Visual Studio 2010 MVC3 project template which included only the jquery-1.5.1.min.js in the _Layout.cshtml file using the Razor rendering engine. The .datepicker function is not located in that javascript file it is in the jquery-ui-1.8.11.min.js file. All I needed do to enable that functionality and resolve the error was to add the following reference to the head of the _Layout.cshtml file, which includes it on all the pages of the app:

photo credit: augapfel / CC BY-SA 2.0

New App Hub Features Still Need Work

2011-07-28T08:11:00.001-04:00

The July 18 Marketplace updates look like they still need some tweaking. I updated one of my apps and set the publish status to “hide” after certification. After app certification approval, for some reason, it showed an update to the app on my phone (doesn’t seem hidden to me). I updated the app to the new version, and the splash screen was updated, but the icons were not updated and the application just showed a “My Application” header at the top of the page with no app content at all.

I thought maybe that was the result of the “Hide” status. So I un-hid the app in the marketplace. It didn’t prompt another update so I uninstalled the app from my phone. When I searched in the marketplace for my app to reinstall, it could not be found.

In order to reinstall the app, I had to navigate to my Lean Bites website on my phone and click the Zune Marketplace deep link in the right column of the website. After following that procedure, the app installed and is working correctly again with the new updated version.

I hope Microsoft gets these issues worked out before the consumer frustration gets to a new high and it doesn’t make my app look like it’s the problem. With so much riding on the new Windows Phone platform, it is unfortunate to see them stumbling over issues that probably should have surfaced in beta testing.

EF “Code-First” Table Mappings for Existing Database

2011-07-22T11:10:00.001-04:00

If you are using the MvcScaffolding package to scaffold the tables from an existing database and it throws an exception on the following line of the index.cshtml page. (The exception would show up in a different location on other data access pages).

@foreach (var item in Model) {

If the exception is of type System.Data.EntityCommandExecutionException where the inner exception is something to the effect of “Invalid object name ‘dbo.Ranks” where the actual database table name is the singular form like dbo.Rank, you probably need to explicitly define the table schema mappings in the OnModelCreating event of the context class because the existing database table names don’t match the default Entity Framework Convention over Configuration settings.

namespace LPM.Models

    public class LPMContext : DbContext

        public DbSet<LPM.Status> Status { get; set; }

        public DbSet<LPM.Rank> Ranks { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)

            modelBuilder.Entity<Rank>().ToTable("Rank");

If you use SQL Profiler to trace the T-SQL statement issued by the application, you can see it was attempting to retrieve data from the [dbo].[Ranks] table which doesn’t exist. In my database it is [dbo].[Rank].

SELECT
[Extent1].[ID] AS [ID],
[Extent1].[RankNo] AS [RankNo],
[Extent1].[RankDescription] AS [RankDescription]
FROM [dbo].[Ranks] AS [Extent1]

This stumped me initially because the first table I used as a test was the “Status” table which by convention has the same name in the singular and plural form. So no exceptions where thrown and I could list, insert, update, and delete the records. After I updated the model from the database and added the Rank table, exceptions started flying until I added the modelBuilder.Entity<Rank>().ToTable(“Rank”) line in the OnModelCreating event.

Scott Guthrie’s Entity Framework 4 “Code-First”: Custom Database Schema Mapping has additional examples with more complex mapping scenarios.

photo credit: aaron13251 / CC BY 2.0

MvcScaffolding uses SQL Express by Default

2011-07-21T11:50:00.001-04:00

The fact that the MvcScaffolding package uses SQL Express by default can be both good and deceiving at the same time.

Using an Existing Database (not Code-First)

I used the package on a MVC3 project to scaffold the repository models and controllers for an existing SQL Server Standard database (not SQL Express) that had an existing Ado.Net Entity Framework model. The EF connection string obviously pointed to the existing database. However when running the application, the Index pages didn’t list any of the existing data from my database.

If this looks like the same problem you are having, feel free to skip to the bottom for the solution (convention over configuration).

Where’s the data?

I could add records, but they didn’t show up in the existing database. There was no Express database .mdf file in the application’s App_Data folder. There were no additional connection strings (other than the EF connection to the existing database) in the web.config files or any of the dbcontext class files. I profiled the existing database with SQL Profiler and the existing database was completely untouched. I even added a <remove name=”LPMEntities” /> line before the EF connection string to make sure any default connection from the server root or machine.config was taken out of the inheritance tree (similar to what you would do for the aspnetdb membership database if you are using a full SQL Server instance).

The new data was being stored somewhere, but where? In a newly created SQL Express database.

How do I See the Data?

Open your SQL Server Management Studio (SSMS) or the version of SSMS for SQL Express. In the Object Explorer window, click Connect. Use .\sqlexpress as the server to connect to using Windows Authentication and voila the new mysterious “hidden” database.

I hope this helps to clarify for other people attempting to use the MvcScaffoling in a Database-First scenario.

The Solution – Understand the Convention over Configuration

It took me a while to find a small subtle, yet crucial, detail in Scott Guthrie’s Using EF “Code First” with an Existing Database.

The following note is stated at the end of Step 5 – Configuring our Database Connection String:

EF “code first” uses a convention where context classes by default look for a connection-string that has the same name as the context class. Because our context class is called “Northwind” it by default looks for a “Northwind” connection-string to use. Above our Northwind connection-string is configured to use a local SQL Express database. You can alternatively point it at a remote SQL Server.

In my case the Entity Framework connection string in the web.config was named “LPMEntities”. The class implementing the DbContext is named LPMContext as shown below.

namespace LPM.Models

    public class LPMContext : DbContext

        public DbSet<LPM.Type> Types { get; set; }

        additional stuff here...

Since LPMEntities is not the context class name, the EF generates a local SQL Express database.

I just added a connection string to the web.config with a name of LPMContext (same name as the context class) and my MVC forms are populated from the existing database.

Victory!

photo credit: Si1very / CC BY-SA 2.0

Error using MvcScaffolding with EF4.0

2011-07-15T15:06:00.001-04:00

If you are just starting out with the MvcScaffolding Nuget package to scaffold your basic CRUD operations on an MVC3 project, you should know that it requires EF 4.1 to run correctly without the following error.

The type 'LPM.Project' was not mapped. Check that the type has not been explicitly excluded by using the Ignore method or NotMappedAttribute data annotation. Verify that the type was defined as a class, is not primitive, nested or generic, and does not inherit from EntityObject

If you already ran the scaffolding via the Package Manager Console using syntax similar to the following, PM>scaffold controller <table> –Repository –Force, to resolve the error, I needed to:

Delete the scaffolded controller files and view files from the project.
Install the Entity Framework 4.1
Re-Generate the Database From Model (assuming that is how you created the Entities to begin with)
Right click on the .edmx Design surface, click Add Code Generation Item.
Click the Code link in the Installed Templates tree. Select ADO.Net DbContext Generator. Name the code generation template, it ends with a .tt extension.
Rebuild the project.
Re-scaffold the tables.
Run the project

Steps 4 & 5 above were the key to getting it to work after installing the Entity Framework 4.1 and with all my combinations of re-scaffolding, re-generating the model, re-creating the model, etc. That important bit of information came from MVC 3 Scaffolding issue with Entity Framework.

If you look at the Model.designer.cs (or .vb) code prior to adding the ADO.Net DbContext Generator, you will see that the Model entities do inherit from the EntityObject (which is noted in the error message as a potential cause of the exception). Adding the ADO.Net DbContext Generator disables the default code generation and inherits from the DbContext instead.

more information:

Scaffold your ASP.NET MVC 3 project with the MvcScaffolding package
Entity Framework Scaffolding: The type is not mapped issue
A word of Advice. Don't get EF 4.1 via NuGet
EF 4.1 Code First Walkthrough – I already had a database so this wasn’t really applicable to my situation.

Physical to Virtual using SysInternals Disk2VHD

2011-07-08T13:55:00.001-04:00

The hard drive controller was regularly failing on my source control server. What to do? The server was due for an upgrade soon as its hardware was more or less obsolete and the performance was less than satisfactory. While the controller was still mostly working, I used SysInternals Disk2VHD to create a virtual copy of the physical server. In the interim while waiting on the new Hyper-V server to permanently place it on, I can temporarily run the server in VirtualPC 2007 and with three times more RAM than was available on the physical server.

The process was simple, fast, and seamless. I just had to re-activate the OS after the conversion. Just make sure you activate it before the expiration date which I believe was only 3 days on my copy or it will brick your ability to manage the server from the terminal.

While waiting for copying and converting processes to finish I ran across a few related posts that I thought I might want to reference in the future.

Are VHD's Compatible between Hyper-V and Virtual Server and Virtual PC
Vittorio Pavesi's post to Convert VHD from Hyper-V to Virtual PC which describes how to overcome the compatibility limitation that prevents using a Hyper-V created VHD in Virtual PC.

Database Primary Key Naming Conventions

2011-07-06T17:17:00.001-04:00

This post specifically deals with the two naming conventions of a primary key for example “Id” or “<tablename>Id".

Using the convention including the tablename prepended to “Id” makes creating and reading SQL query joins more intuitively readable as in:

SELECT a.AuthorId

    , a.AuthorName

    , b.BookId

    , b.BookName

FROM Author a

   INNER JOIN Book b

   ON b.AuthorId = a.AuthorId

Versus the alternative using a standard key name, such as “Id" for all tables, as in the following:

SELECT a.Id AS AuthorId

    , a.AuthorName

    , b.Id AS BookId

    , b.BookName

FROM Author a

   INNER JOIN Book b

   ON b.AuthorId = a.Id

However it adds additional abstraction/mapping complexity when using a generic Repository pattern* that uses a standard primary key property name for the Repository base classes and interfaces.

*The design is possibly more correctly labeled as a DAO pattern depending on the specific implementation.

photo courtesy: amboo who? / CC BY-SA 2.0

Circumventing the uriMappings in Silverlight

2011-06-08T17:15:00.001-04:00

I created a Silverlight application with the Silverlight Navigation project template that needed to open a link to a PDF file located in a subfolder of the host web application directory. The project has a convenient uriMapping process defined in the MainPage.xaml XAML to provide search engine friendly links to the various Silverlight pages. It is located in the Windows.System.Navigation namespace. It looks something like this:

<uriMapper:UriMapper>

   <uriMapper:UriMapping Uri="" MappedUri="/Views/Home.xaml"/>

   <uriMapper:UriMapping Uri="/{pageName}" MappedUri="/Views/{pageName}.xaml"/>

</uriMapper:UriMapper>

I needed to link to an absolute Url, not a uri relative to the Silverlight app, like http://www.deanwillson.com/downloads/Continuous-Improvement-professional-Org-1st-Edition.pdf, but if the uriMapper catches that link it attempts to re-map it to a resource that doesn’t exist which generates the following error:

“Content for the URI cannot be loaded. The URI may be Invalid”

Solution

In order to accomplish linking outside of the defined uriMappings, I added the link in the XAML of the HyperlinkButton NavigateUri.

<HyperlinkButton Name="lnkReport" NavigateUri="http://www.deanwillson.com/downloads/Continuous-Improvement-professional-Org-1st-Edition.pdf" Content="Click here to open your document" TargetName="_blank" Margin="116,11,184,10" Width="200" />

All this probably looks pretty obvious, but it started with me trying to open the pdf report using code-behind in the clicked event handler for the button, which kept throwing the Invalid Uri exception. I even added a special uriMapping that mapped to the same link, which also did not work.

photo credit: eirikref / CC BY 2.0

Creating a Windows Phone 7 app using WCF, and SQL Azure

2011-05-25T12:21:00.001-04:00

Last night I gave a presentation with demos for fwPASS creating a Windows 7 app displaying a list of gymnasts from a SQL Azure database using WCF (Windows Communication Foundation). The WCF service used the Entity Framework and the .Net Membership provider.

Windows phone 7, WCF, and SQL Azure

View more presentations from Dean Willson

The application was surprisingly easy to create despite the fact that were a lot of moving pieces with integration between all the different components.

The presentation covered the following tools:

Windows Phone Marketplace App Hub
Visual Studio IDE
SQL Server Management Studio (SSMS)
Windows Azure Platform Management Portal
SQL Azure Migration Wizard
Windows Phone 7 Emulator

All that in 70 minutes. Yes, I talk fast. This was a first time presentation. Below is the demo script I used:

Marketplace

1. Preview App Hub http://create.msdn.com

· Show app details text, iconography

Database

1. SSMS – show local ChalkChimp database

· Show script for creating additional users?

2. http://windows.azure.com SQL management interface

· No query designer

3. SQL Azure Migration tool

· Scripts out db

· Shows unsupported features

· deploys

4. Azure limitations in SSMS

· No query designer

· Admin account (other users don’t have access to the master database)

WCF

1. Create new project WCF Application

· Highlight Framework version 3.5

· Change binding to basicHTTPBinding

2. New Item à ADO.Net Entity

· Azure connection

3. Switch to finished project

4. Modify Iservice.cs, modify Service.cs implementation

5. Show .Net membership bits in web.config

6. View in browser (copy url)

WP7 client

1. Open Visual Studio (another)

2. New Project à Windows Phone 7 application

3. New item à Phone portrait page

4. Add Service reference

· Show service methods

· Advanced show generate async methods

5. Switch to finished project

· Show xaml bindings

· Show async methods and completed event handlers

· switch device to emulator

6. Run it

Optional

· Show property pages and iconography

Technorati Tags: Windows Phone 7,WP7,WCF,Silverlight,SQL Azure

Download for WP7 Badges

2011-05-20T09:49:00.001-04:00

Since I never seem to remember where to find the official "Download for Windows Phone 7" Badge and Logos, here is my reminder http://go.microsoft.com/fwlink/?LinkID=202116.

Do You Have Control of Your Database?

2011-05-18T15:31:00.001-04:00

I prepared the following talking points to facilitate a round table discussion on Database Source Control titled “Do you have [source] control of your database” with a local chapter of Professional Association for SQL Server.

Most software developers use some form of source control for their software code, but it seems less common to take the same precautions with their databases.

Database Source Control

View more presentations from Dean Willson

Submitting an AppMakr app to the Windows Phone 7 Marketplace

2011-05-17T10:37:00.001-04:00

I made a Windows Phone 7 app using AppMakr for reading Lean-related content from prominent Lean bloggers. That was easy, but there didn’t appear to be any instructions for how to get the app added to the App Hub. So here they are.

Log into your AppMakr account. There are a number of ways to get to your build. Either click the “App Builds” link in the top navigation or click the “Builds” button on one of your applications (as shown in the image below).

Pick the latest build that you want to submit to the marketplace and click the Download App button.

You will be presented with a dialog to open or save the zip file. Choose to save it to a location on your PC.

Important: Rename the file extension from .zip to .xap (which is the Silverlight application package deployment file). You will have to create the necessary Windows Phone 7 iconography (icons and screenshots needed for submitting to the app hub). You may be able to use some of the ones you used to create the application in AppMakr.

You will need an App Hub Developer account to submit applications to the Windows Marketplace ($99/year). After you have that, log in and from the “my dashboard” navigation link, select “Windows Phone”.

Click the “submit new app” button.

Fill out the form fields. Click inside the Application package box with the Plus (+) sign. A file open dialog will appear. Select the .xap file that you renamed after downloading from AppMakr earlier.

Continue through the process of providing an application description and uploading the necessary icon images. After you finish, sit back and wait for your app to go through the testing and certification process.

Technorati Tags: Windows Phone 7,WP7,AppMakr

Switching to C#

2011-05-09T15:12:00.001-04:00

After more than 7 years of VB.Net development, I have made the conscious decision to split my development into primarily VB.Net for most of my ASP.Net projects and C# for my Windows Phone 7, Silverlight, and WPF work. This transition was due to three primary driving forces:

Early Windows Phone 7 development (pre-RTM) was limited to C# due to the lack of availability for VB.Net support on the WP7 platform.
There appears to be a larger codebase of Silverlight and WP7 utilities, samples, and tutorials in C# to learn from.
I have had an easier time finding advanced Linq syntax examples in C#.

The syntax differences are not much different. I was already used to the most common syntactic differences, such as parenthesis, squiggly brackets, and semi-colons from my earlier work in PHP and Java. I would have started in C# if it were not for the Classic ASP and VB.Net applications I was supporting years ago in my .Net 1.1 beginnings.

Of course, the language selection is always trumped by complying with my clients’ corporate development standards and selecting the appropriate language for the job where the differences are relevant.

photo credit: avlxyz / CC BY-SA 2.0

Career Transitions Presentation to Ball State University

2011-04-15T09:27:00.002-04:00

I was asked to speak to the Six Sigma Student Organization in the Whitinger Business Building about the transitions a person may fear while changing roles of a student to professional as well as transitions that may take place while a person is pursuing their career. The talking points from my presentation are below.

Career Transitions - Ball State University, Six Sigma Speakers Series

View more presentations from Dean Willson

SQL Saturday #67 Chicago

2011-04-13T15:05:00.001-04:00

Most of the sessions I attended involved improving performance. Whether it was proactive (design for performance) or reactive (troubleshooting), most sessions included some coverage of indexes. Surprisingly there very little duplication of content by the different speakers. Because of the quality and relevance of the all sessions offered, it was difficult to decide which sessions to attend. Below is a brief recap of the ones I chose.

Sessions

Performance Tuning Made Easy with Thomas LaRock

Being a certified Six Sigma Black Belt, I appreciated the way Tom (blog|twitter) described a simple systematic process for performance tuning based on the Six Sigma DMAIC (Design, Measure, Analyze, Improve, Control) approach.

The Optimizer, Statistics, and Indexes with Grant Fritchey

Grant (blog|twitter) gave a great primer to the internals of the Relational Engine, the components of which have really cool names like Query Parser, Algebrizer, and Optimizer. He also spent more time discussing the Statistics histogram, which appeals to my six sigma senses, than I generally see in an hour long presentation.

WIT (Women in Technology) Panel: Energizing the Next Generation

This session seemed to have a balanced number of men and women in attendance. It was nice to hear the perspective of multiple women with different backgrounds sharing their experiences in the field. I’m really happy that most of their experiences sounded positive even in the face of adversity.

Refactoring SQL with Jeremiah Peschka

Jeremiah (blog|twitter) really highlighted the importance of using consistent naming conventions and common alias names. He touched on SQL unit testing and some open source test frameworks. He also showed refactoring examples such as, re-writing where clauses to move functions from the left side of the operator to the right side for performance gains.

Database Design Contentious Issues with Karen Lopez

This was one of my favorite sessions. It was interactive as the participants had to walk to the front of the room and anonymously vote (via post-it note) on a scale of 1 to 5 on our opinion/view of two issues which people often passionately argue about, such as, surrogate keys vs. natural keys. People that admitted to voting on the extremes (one or five) were asked to explain why they voted the way they did and open the topic for group discussion. Karen liberally made effective use of Canadian SWAG (like ketchup flavored Pringles) to persuade the edge-case voters to plead their case in the face of possible peer criticism. Karen (blog|twitter) expertly moderated the discussion and provided great pro/con examples on both sides even where it conflicted with her own views. It was both fun and educational.

Index Internals for Mere Mortals with Michelle Ufford

At a lightning quick pace, Michelle (blog|twitter) brought a great deal of insight to index internals. She showed actual representations of index pages and pointed out key elements of it, including the “uniqueifier”. She covered a great deal of information in the short one hour, but it was very clear, understandable, and educational.

Lunch

The lunch was provided by Meaty Balls. It was plenty of tasty meat and mushrooms for the price.

Check-in

The organizers offered a “Speed Pass” option where I printed my name tag, lunch ticket, and raffle tickets off in advance which meant I could sleep in a little before heading to Chicago.

Venue

The conference was hosted at the DeVry University Addison Campus which had great classroom spaces. There were ample power outlets available on the table tops for each attendee to plug in, if desired. I wish I had remembered to bring the AC adapter for my GPS for the trip home since my car lighter adapter stopped working before the trip.

Networking

I was within a SWAG keychain throw of several SQL Celebrities like Kevin Kline (blog | twitter) and Brent Ozar (blog|twitter). Brent was sitting behind me in three out of five sessions I attended - and no, I’m not a SQL Stalker.

I finally got to meet Wendy Pastrick face-to-face after several email and twitter conversations over the last year.

Credit-worthy

I’ve been running the fwPASS User Group for a few years and to do just an average job takes a surprising amount of time and effort. See my case study on continuous improvement in a professional association for more information. The organizers did an exceptional job that deserves more thanks than I can provide. I’m not sure if this is inclusive of all the organizers (which I copied from Doug Lane’s blog), but THANK YOU:

IIS is Missing XAP Mime Type for Silverlight Application

2011-04-07T11:51:00.001-04:00

Upon navigating to the web page hosting a newly deployed Silverlight application, I received the following error:

Error: Unhandled Error in Silverlight Application
Code: 2104
Category: InitializeError
Message: Could not download the Silverlight application. Check web server settings

Thanks, but which server settings? In my case the MIME type for the .xap extension was missing in IIS7. I’m not sure why it was missing since .xaml and .xbap were already defined. I simply added the “.xap” extension and it’s corresponding MIME Type “application/x-silverlight-app” and all was well.

photo credit: e v a . p é b a r / CC BY 2.0

File URI invalid for WCF HTTP Endpoint

2011-04-07T11:29:00.001-04:00

System.ArgumentException: The provided URI scheme 'file' is invalid; expected 'http'.

The error occurred when debugging a Silverlight app that uses Windows Communication Foundation (WCF). When running the debugger, the IDE was launching the html file hosting the Silverlight application, but it was launching it in the browser using a file path, F:\Projects\MyLOBApp\Bin\Debug\TestPage.html, not through IIS as http://localhost/MyLOBApp/TestPage.html. The application was using the following code in a global application class to set the URL to the WCF service.

public static string WebServiceUrlPath

get

        Uri uri = new Uri(Application.Current.Host.Source, "../AppDataService.svc");

        return uri.AbsolutePath.ToString();

My solution consists of two projects:

The Silverlight application project
The WCF service project

Upon closer inspection of the file path, Visual Studio was launching the test page from the Silverlight project when it should have been launching the test html page from the WCF project. The simple solution was to set the WCF project as the StartUp Project. That should have been more obvious especially in light of the following message box that popped up before the debugger started, but it was initially overlooked because of the similar project names and html page filenames in the two projects.

photo credit: satemkemet / CC BY-SA 2.0

Javascript Deserialization Error Converting Ajax JSON in ASP.Net Web Service

2011-04-01T11:06:00.001-04:00

The .Net framework makes it very easy to do fast lightweight AJAX calls to an ASP.Net web service using jQuery or other frameworks using json (JavaScript Object Notation) and XMLHTTPRequest (MUCH faster and lighter weight than the UpdatePanel).

Because the data in json is delimited by apostrophe’s, having them within the text (as the data itself) can throw a deserializing error when ASP.Net parses the json text body into the web service method parameters. A simple way to prevent is to wrap your javascript variable with the escape() method. It will convert an apostrophe to %u2019. On the server side within your web method before you pass the data to the database, you can wrap it with Server.UrlDecode() to convert it back to an apostrophe.

Javascript jQuery Ajax call

Below is an example of a typical jQuery asynchronous call to a web service. Note the webservice name is AppWebService.asmx. UpdateComments is the web method being called. The UpdateComments web method takes two parameters an integer RecordID and a string RecordComments. Note the use of escape(RecordComments) to encode the RecordComments field in the event that it contains apostrophes (or other special characters).

var options = {

    type: "POST",

    url: "/Application/AppWebService.asmx/UpdateComments",

    data: "{'RecordID':" + RecordID + ", 'RecordComments':'"

        + escape(RecordComments) + "'}",

    contentType: "application/json; charset=utf-8",

    dataType: "json",

    success: function (response) {

        if (response.d == "") {

            jQuery('#saving').hide();

    }, //end success

    error: function (response) {

        alert("Sorry, the update failed. \n\n Details follow: "

    + response.responseText);

    } //end error

};

//Call the Web service

jQuery.ajax(options);

Raw Request Captured in Fiddler

The text below is the contents of the HTTP request that is sent to the web service. In this case the actual data is much smaller than the request header information. You can see how much less data is being sent back to the server for processing compared with a complete page postback or even an ASP.Net AJAX UpdatePanel. The json data itself is:

{'RecordID':10629, 'RecordComments':'cat%u2019s%20meow'}

The RecordComments text is an encoded version of “cat’s meow” (without the quotes).

POST http://domain/Application/AppWebService.asmx/UpdateComments HTTP/1.1
x-requested-with: XMLHttpRequest
Accept-Language: en-us
Referer: http://domain/Application/RecordMaintenance.aspx
Accept: application/json, text/javascript, */*
Content-Type: application/json; charset=utf-8
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0
Host: kestrel
Content-Length: 148
Connection: Keep-Alive
Pragma: no-cache

{'RecordID':10629, 'RecordComments':'cat%u2019s%20meow'}

Web Method accepts json

Behind the scenes ASP.Net parses the json data and uses it to populate the web method parameters. If there was an apostrophe in the json text body as shown below:

{'RecordID':10629, 'RecordComments':'cat's meow'}

ASP.Net would not correctly parse the data correctly, because it would be expecting a closing bracket } immediately after 'cat'. Since we escaped the data, it is parsed correctly using the following web method. Note the use of Server.URLDecode to convert the RecordComment from “cat%u2019s%20meow” back to “cat's meow” before passing it to the helper method as a parameter for a stored procedure.

<WebMethod()> _

<ScriptMethod()> _

Public Function UpdateComments(ByVal RecordID As Integer, ByVal RecordComments As String) As String

    Dim result As String = String.Empty

Try

        CommonSQL.ExecuteNonQuery("sproc_name", _

           RecordID, _

           Server.UrlDecode(RecordComments))

    Catch ex As Exception

        Return ex.ToString

    End Try

    Return result

End Function

photo credit (wave runner): db2r / cc BY-SA 2.0

Lessons Learned in the Windows Phone 7 Marketplace

2011-03-16T15:25:00.001-04:00

The following are a few of the things I learned during the development process and submitting a first application to the Windows Phone Market Place. Hopefully they can be of some help to others.

Application Name

If your application name is more than about 15 characters, the whole application name may be truncated on the various WP7 screens. This is also true in the thumbnail view in the Market Place. Note how the text fades to white toward the right side of the name in the screenshot below.

Iconography

Graphic design in the consumer market space is a necessity. Your icons are displayed immediately adjacent to other professional designs - regardless of app quality.

Application Icons

Initially I created a 31px application icon. I think that was the size used during the RC or beta version of Visual Studio Express for Windows Phone 7. The following are the default icon sizes for Windows Phone 7 application certification:

ApplicationIcon.png 62px (transparency allowed)
Background.png* 173px (transparent allowed)

* Tip: don’t put the application name in this image (or any important cosmetic detail at the bottom) as the Application title text from the Visual Studio property page will be rendered on top of the 173px icon near the bottom of the image (see the “Start Screen” in the screen shot below).

The following is a composite image containing multiple screen shots:

Phone Windows menu screen (left)
Visual Studio project properties, application tab (center)
Phone Start screen (right)

Note in the image where the text is displayed and which images are used on the various app screens. Click the image for full size.

Market Place Icons

The following square icons (without transparency) are required for display in the Market Place:

99px
173px
200px

WP7 application screen shots can be uploaded to showcase key functionality.

480 x 800px screenshots
vertical orientation for upload
set zoom level on emulator to 100% for correct screenshot resolution (need a high enough resolution monitor to capture the screenshots. 1024X768 is not good enough)

Marketplace Detailed description

I copied my description from a website where the application is described. I’m not sure I would do that in the future as it did not display properly on the app hub submission page (note the incorrect text wrapping at the end of the lines. There doesn’t appear to be an option to edit the description without re-submitting the application.

I was pleasantly surprised the text looked correct when my application was certified as approved, but I don’t know if the person testing the app corrected the description text formatting during prior to approval/publishing.

Another developer had the misfortune of an unfortunate example using a bullet list format.

Submission and Certification

I submitted my application to the App Hub on a Sunday evening and it was certified by the following Wednesday morning. It was accepted on the first submission, but the feature set (and graphic design) was kept intentionally simple in the first version.

Windows Phone 7 Testing a Date Change in the Emulator

2011-03-10T12:48:00.001-05:00

I wrote a WP7 application that stores a bit of data based on today’s date. Tomorrow when the date changes, yesterday’s data gets cleared out to start fresh. Before submitting the app to the App Hub I needed to test whether it would work as expected when the date changes. At the time, I didn’t have an actual Windows Phone 7 for testing so I used the Emulator. The testing process didn’t work out quite as I expected.

Happy Path

Load Emulator
Deploy app to the emulator
Run app
Click some buttons that store today’s data
Change the date on the development box (assuming that is where the emulator gets its current date)
Click the windows key to unload the app
Return to app (which should have a different date since I changed the date on the development box)
The app data should be empty because it is a new day

Fail

There were a few misconception to the above.

It appears that the emulator loads today’s date when the emulator starts up, because it didn’t change when I changed the date in my development environment.
When you click the back button it unloads the application and you lose the data stored in Isolated Storage.

Fix

Replace steps 5 & 6 in the above “Happy Path” with the following steps to effectively test the date change:

Click to the System Settings page in the Emulator
Click “date & time”
Toggle the “set automatically” slider to Off
Click on the date in the date field
Change the date to a different day
Click the windows key and left arrow icon to see the app in the menu.