<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-8201635463774174647</id><updated>2011-07-08T17:49:42.968+01:00</updated><title type='text'>Where(I =&gt; I.CanFindTime)</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://sunevnuahs.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8201635463774174647/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://sunevnuahs.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>sunevnuahs</name><uri>http://www.blogger.com/profile/11397530056764476288</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='31' height='32' src='http://3.bp.blogspot.com/_EtZzhegccLk/S3LNCSCp7JI/AAAAAAAAAWQ/v9tmA9bDfqQ/S220/IMG_0223.JPG'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>4</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-8201635463774174647.post-8066712966684864946</id><published>2010-02-19T11:59:00.003Z</published><updated>2010-02-19T19:32:08.537Z</updated><title type='text'>Silverlight 3, RIA and Fluent NHibernate</title><content type='html'>&lt;span style="font-family: Verdana, sans-serif;"&gt;After working through some of the nice examples with Silverlight 4 and RIA Services I had to get back to the reality of the moment and look a RIA with SL3; this is something I had hoped not to do but it has been an interesting time.&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;I found a few bits and pieces on the web and some samples, none of which worked when opened in Visual Studio - all those version differences and breaking changes take their toll on such samples.&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;One such example was provided by Shane Kercheval at &lt;/span&gt;&lt;a href="http://www.shanekercheval.com/?p=66"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;http://www.shanekercheval.com/?p=66&lt;/span&gt;&lt;/a&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;.&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;Like the others however, this would not build for me and I spent some time getting things up to date for the latest version of RIA and working through those breaking changes; changes such as removing the HttpHandlers and replacing with HttpModules for the RIA Domain Services, using WebContext instead of RiaContext (one that caused me much wasted time when first looking at RIA samples and wondering why they would not work for me).&amp;nbsp; &lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;A great help on this front was found here &lt;/span&gt;&lt;a href="http://www.whycantyoucode.com/2009/11/verbose-steps-to-migrate-a-silverlight-application-from-net-ria-services-july-09-to-wcf-ria-services-pdc-09/"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;http://www.whycantyoucode.com/2009/11/verbose-steps-to-migrate-a-silverlight-application-from-net-ria-services-july-09-to-wcf-ria-services-pdc-09/&lt;/span&gt;&lt;/a&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;I also had to update a hardcoded database path (in NHibernateSessionFactory.cs, you will too if you want to run the code - unless by some fluke you have matching paths).&amp;nbsp; It is a sample after all so I can accept that (my plan is to use SQL Server for the PoC work).&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;Once I had eventually got things building the app would not run for me (note: I did not attempt to sort the Region / Country issue mentioned in the comments of Shane's post - I commented the validation code out as that was not pressing for me just now).&amp;nbsp; &lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;Another waste of time?&amp;nbsp; Not this time - I was determined to get this one up and running as my primary goal for the&amp;nbsp;evening was to have a working sample of SL3, RIA Services and Fluent NHibernate.&amp;nbsp; The code was building, just not running.&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;The services were returning 'Not Found' errors on the GetRegions and GetContacts methods.&amp;nbsp; Of course, right now RIA returns this error for any server side error, so I used Fiddler and found it was actually a 500 error coming back.&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;Checking the event log I found an&amp;nbsp;error that gave me my exception:&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: x-small;"&gt;&lt;exception&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: x-small;"&gt;&lt;exceptiontype&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;System.NullReferenceException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089&lt;/exceptiontype&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: x-small;"&gt;&lt;message&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;Object reference not set to an instance of an object.&lt;/message&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: x-small;"&gt;&lt;stacktrace&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.Web.Ria.Services.DomainServiceVirtualPathProvider.OwnsFile(String virtualPath)&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.Web.Ria.Services.DomainServiceVirtualPathProvider.FileExists(String virtualPath)&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath)&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.HandleRequest()&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.BeginRequest()&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.OnBeginRequest(Object state)&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: x-small;"&gt;&lt;/stacktrace&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: x-small;"&gt;&lt;exceptionstring&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;System.NullReferenceException: Object reference not set to an instance of an object.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.Web.Ria.Services.DomainServiceVirtualPathProvider.OwnsFile(String virtualPath)&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.Web.Ria.Services.DomainServiceVirtualPathProvider.FileExists(String virtualPath)&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath)&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.HandleRequest()&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;span style="font-size: x-small;"&gt;at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.BeginRequest()&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: x-small;"&gt;at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.OnBeginRequest(Object state)&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: x-small;"&gt;&lt;/exceptionstring&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: x-small;"&gt;&lt;/exception&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;This suggested that the virtual path provider was not finding my service, so next I tried something I should have done some time ago, I attempted to hit the services in a browser.&amp;nbsp; The service did not display as expected -&amp;nbsp;you know the usualy screen you see for a WCF service.&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;A little more digging around and I decided to add .svc files for each service (and an associated Host&amp;nbsp;Factory) so that I could prove to myself that the services were there are working.&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;These are quite simple a to add, just add a text file named &lt;namespace&gt;-&lt;domainservice&gt;.svc replacing any "." with "-" (BusinessApp-Web-BusinessAppDomainService.svc in this case) and the file should contain code such as:&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: &amp;quot;Courier New&amp;quot;, Courier, monospace;"&gt;&amp;lt;%@ ServiceHost &lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: &amp;quot;Courier New&amp;quot;, Courier, monospace;"&gt;Service="BusinessApp.Web.BussinessAppDomainService" &lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: &amp;quot;Courier New&amp;quot;, Courier, monospace;"&gt;Factory="System.Web.Ria.BusinessAppDomainServiceHostFactoryEx" &lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: &amp;quot;Courier New&amp;quot;, Courier, monospace;"&gt;%&amp;gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;It worked! Now I finally have a sample working on my machine (I think I made it sound easier than it was here, but was too early in the morning to put all the woes down here).&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;Thanks to Shane and of course Brad A for thier part in putting things together.&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;a href="http://www.tibbit.co.uk/RiaBusinessApp.zip"&gt;Download the updated source here.&lt;/a&gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-family: Verdana;"&gt;(Of course - you might not get it to build 1st time but most of the work&amp;nbsp;has been done for you and it's always a good learning experience to hit and resolve&amp;nbsp;problems!!&amp;nbsp; One thing that is very possible is that you will need to remove and re-add some references - I think this can be due to having 32bit vs 64bit OS on machines)&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8201635463774174647-8066712966684864946?l=sunevnuahs.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://sunevnuahs.blogspot.com/feeds/8066712966684864946/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://sunevnuahs.blogspot.com/2010/02/silverlight-3-ria-and-fluent-nhibernate.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8201635463774174647/posts/default/8066712966684864946'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8201635463774174647/posts/default/8066712966684864946'/><link rel='alternate' type='text/html' href='http://sunevnuahs.blogspot.com/2010/02/silverlight-3-ria-and-fluent-nhibernate.html' title='Silverlight 3, RIA and Fluent NHibernate'/><author><name>sunevnuahs</name><uri>http://www.blogger.com/profile/11397530056764476288</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='31' height='32' src='http://3.bp.blogspot.com/_EtZzhegccLk/S3LNCSCp7JI/AAAAAAAAAWQ/v9tmA9bDfqQ/S220/IMG_0223.JPG'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8201635463774174647.post-2011876782626186524</id><published>2010-02-19T11:56:00.000Z</published><updated>2010-02-19T11:56:54.454Z</updated><title type='text'>Using Fiddler with ASP.NET Web Development Server with Silverlight in IE</title><content type='html'>&lt;span style="font-family: Verdana, sans-serif;"&gt;Whilst trying to debug an issue with Silveright RIA services I wanted to use Fiddler to see what was being returned by the server (as the client told me the service/method was not found - this is not the whole truth it turned out).&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;My first problem was that the ASP.NET Web Development Server (WDS) starts on a URL such as &lt;span style="font-family: &amp;quot;Courier New&amp;quot;, Courier, monospace;"&gt;http://localhost:4567/default.aspx&lt;/span&gt; and when using IE on localhost Fiddler will not capture the traffic.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;What you need to do is use a name other than localhost then Fiddler will capture for you. However, as WDS cannot be (from what I found) changed to start on anything but localhost Fiddler needs to know how to handle this.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;What is needed is Rule in Fidder to handle this, a rule than will take the URL&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: &amp;quot;Courier New&amp;quot;, Courier, monospace;"&gt;http://mydomain:4567/default.aspx&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;and change it to &lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: &amp;quot;Courier New&amp;quot;, Courier, monospace;"&gt;http://127.0.0.1:4567/default.aspx&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;This is pretty simple to setup. CTRL+R in Fidder will bring up the Fidder2 Script Editor in which you can edit your rules.&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;Find the function static function OnBeforeRequest(oSession: Session) and at the end of it add a rule like so:&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: &amp;quot;Courier New&amp;quot;, Courier, monospace;"&gt;oSession.host = oSession.host.replace("mydomain","127.0.0.1");&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;Save you updated rules script and exit.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;Now, when you browse (/debug) your Silverlight app you should do so using &lt;span style="font-family: &amp;quot;Courier New&amp;quot;, Courier, monospace;"&gt;http://mydomain:4567&lt;/span&gt; rather than localhost and traffic will be captured.&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;One minor irritation that I also had to overcome was that when the SL project started (and immediately hit an error) it was doing so on http://localhost:4567/ and so I did not see the traffic. &lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;To get around this problem I added a start page (actually just edited the default.aspx in the SL web project) so that&amp;nbsp;it contains a hyperlink to the Silverlight test page using the required URL such as &lt;/span&gt;&lt;span style="font-family: &amp;quot;Courier New&amp;quot;, Courier, monospace;"&gt;http://mydomain:4567/SLAppTestPage.aspx&lt;/span&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;; this page now having traffic captured by Fiddler and allowing me to see the real reason behind my RIA Service call failures.&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8201635463774174647-2011876782626186524?l=sunevnuahs.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://sunevnuahs.blogspot.com/feeds/2011876782626186524/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://sunevnuahs.blogspot.com/2010/02/using-fiddler-with-aspnet-web.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8201635463774174647/posts/default/2011876782626186524'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8201635463774174647/posts/default/2011876782626186524'/><link rel='alternate' type='text/html' href='http://sunevnuahs.blogspot.com/2010/02/using-fiddler-with-aspnet-web.html' title='Using Fiddler with ASP.NET Web Development Server with Silverlight in IE'/><author><name>sunevnuahs</name><uri>http://www.blogger.com/profile/11397530056764476288</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='31' height='32' src='http://3.bp.blogspot.com/_EtZzhegccLk/S3LNCSCp7JI/AAAAAAAAAWQ/v9tmA9bDfqQ/S220/IMG_0223.JPG'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8201635463774174647.post-8737103068865749302</id><published>2010-02-10T16:14:00.002Z</published><updated>2010-02-10T22:17:30.184Z</updated><title type='text'>Silverlight RIA samples with SQL 2005</title><content type='html'>I have recently been looking at RIA with Silverlight 4 and Visual Studio 2010.&lt;br /&gt;&lt;br /&gt;&lt;a href="http://blogs.msdn.com/brada/archive/tags/RIAServices/default.aspx"&gt;Brad Abrams&lt;/a&gt; has some great posts on all of this and also touched on a subject that I will be looking into a little more - RIA DomainService with NHibernate.&lt;br /&gt;&lt;br /&gt;One thing I found is that the the examples use a modified Northwind database with the SuperEmployee&amp;nbsp;table - this comes with the samples but it is a SQL 2008 database.&amp;nbsp; I needed to have this run off SQL 2005 as my target platform has 2005 and I wanted to be sure all is going to be OK when we put it out there (and one development machine does not yet have SQL 2008 installed on it).&lt;br /&gt;&lt;br /&gt;As there is no 'downgrade' for the database to attach it is SQL 2005 I decided to find use an instance of SQL 2008, attached the MDF supplied with the code for one of Brads posts and then use the SQL Database Publishing Wizard (build into Visual Studio 2008) to script the database and target that script for SQL Server 2005.&lt;br /&gt;&lt;br /&gt;To get the SQL Server 2005 database setup follow these steps:&lt;br /&gt;&lt;br /&gt;&lt;span style="font-family: Arial, Helvetica, sans-serif;"&gt;1. Create a new empty database (I called mine SuperNorthwind)&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-family: Arial, Helvetica, sans-serif;"&gt;2. Execute the SQL script found &lt;/span&gt;&lt;a href="http://www.tibbit.co.uk/SuperNorthwind.zip"&gt;&lt;span style="font-family: Arial, Helvetica, sans-serif;"&gt;here&lt;/span&gt;&lt;/a&gt;&lt;span style="font-family: Arial, Helvetica, sans-serif;"&gt;&amp;nbsp;against your new database&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;You will of course needs to tweak your connection strings accordingly but should be good to go with 2005 for the RIA samples now.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8201635463774174647-8737103068865749302?l=sunevnuahs.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://sunevnuahs.blogspot.com/feeds/8737103068865749302/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://sunevnuahs.blogspot.com/2010/02/silverlight-ria-samples-with-sql-2005.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8201635463774174647/posts/default/8737103068865749302'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8201635463774174647/posts/default/8737103068865749302'/><link rel='alternate' type='text/html' href='http://sunevnuahs.blogspot.com/2010/02/silverlight-ria-samples-with-sql-2005.html' title='Silverlight RIA samples with SQL 2005'/><author><name>sunevnuahs</name><uri>http://www.blogger.com/profile/11397530056764476288</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='31' height='32' src='http://3.bp.blogspot.com/_EtZzhegccLk/S3LNCSCp7JI/AAAAAAAAAWQ/v9tmA9bDfqQ/S220/IMG_0223.JPG'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8201635463774174647.post-4545985286164255367</id><published>2010-02-10T14:49:00.001Z</published><updated>2010-02-11T00:23:27.018Z</updated><title type='text'>SQL Server 2008 installation problem - restart required.</title><content type='html'>Tried to install SQL Server Developer Edition on Windows 7 Ultimate.&lt;br /&gt;&lt;br /&gt;There are 6 initial checks made before installation starts, one of which is "Restart Computer" - this is where I kept getting stuck. I could restart but still nothing doing.&lt;br /&gt;&lt;br /&gt;A few posts suggested that the registry was to blame for my troubles, specifically the "&lt;span style="font-family: courier new;"&gt;PendingFileRenameOperations&lt;/span&gt;" value in "&lt;span style="font-family: courier new;"&gt;HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager&lt;/span&gt;".&lt;br /&gt;&lt;br /&gt;The value stored here was:&lt;br /&gt;&lt;br /&gt;&lt;span style="font-family: courier new;"&gt;\??\C:\Windows\TEMP\logishrd\LVPrcInj03.dll&lt;br /&gt;&lt;br /&gt;\??\C:\Windows\TEMP\logishrd\&lt;br /&gt;&lt;br /&gt;\??\C:\Windows\TEMP\logishrd\LVPrcInj04.dll&lt;br /&gt;&lt;br /&gt;\??\C:\Windows\TEMP\logishrd\&lt;/span&gt;&lt;br /&gt;(These are apparently linked to Logitech and the webcam I have installed).&lt;br /&gt;&lt;br /&gt;I cleared the values and restarted - same thing. Also, the values were back in the registry key.&lt;br /&gt;&lt;br /&gt;So I decided I'd rename "&lt;span style="font-family: courier new;"&gt;PendingFileRenameOperations&lt;/span&gt;" and then tried the install again (without restarting). This did the trick and I was able to install SQL 2008 (then of course I renamed the key to the original name).&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/8201635463774174647-4545985286164255367?l=sunevnuahs.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://sunevnuahs.blogspot.com/feeds/4545985286164255367/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://sunevnuahs.blogspot.com/2010/02/sql-server-2008-installation-problem.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8201635463774174647/posts/default/4545985286164255367'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8201635463774174647/posts/default/4545985286164255367'/><link rel='alternate' type='text/html' href='http://sunevnuahs.blogspot.com/2010/02/sql-server-2008-installation-problem.html' title='SQL Server 2008 installation problem - restart required.'/><author><name>sunevnuahs</name><uri>http://www.blogger.com/profile/11397530056764476288</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='31' height='32' src='http://3.bp.blogspot.com/_EtZzhegccLk/S3LNCSCp7JI/AAAAAAAAAWQ/v9tmA9bDfqQ/S220/IMG_0223.JPG'/></author><thr:total>0</thr:total></entry></feed>
