Zubair.NET!

Last week I co-presented a session titled “Creating Cutting Edge Websites for Phones, Slates and Beyond” at Microsoft Web Camp in Dubai with Ronald Widha.

• Opening Address, Michael Mansour
  
• Development on Internet Explorer 9, Shaymaa Al-Terkait
  
• Building an eCommerce Site in 13 Minutes with Web Matrix, Asli Bilgin
  
• Creating Cutting Edge Websites for Phones, Slates and Beyond with WebMatrix and VS2010, Ronald Widha and Zubair Ahmed
  
• Q&A with Pizza Dinner and drawing for a free Windows Phone 7!

From Microsoft Web Camp in Dubai

Ronald Widha talked about the challenge facing today’s designer and developers to build User interfaces that fit on desktop and phones alike, he discussed the Responsive UI design pattern and showed how Html5, CSS Media Queries and Fluid Images and can help solve this issue to some extent. Get Ronald’s slides

I then showed some goodness from Microsoft Web Stack of Love and took Ron’s user interface markup to the new CSHTML page type in Web Matrix and changed it to get the content from a SQL Compact Edition database using the Razor view syntax and launched the same solution in Visual Studio from Web Matrix then added Entity Framework and WCF Data Services to the mix.

You can download all the tools using Web PI and get my code.

Labels: .NET 4.0, ASP.NET, Entity Framework, VS 2010, WCF Data Service, Web Matrix

# posted by Zubair.NET! @ 9:24 PM 0 comments

Update: Its an honor to have ScottGu and Scott Hanselman retweet this post and link from the "Gu" blog and also big thanks to Alvin Ashcraft & Chris Alcock for links to this post and offcourse thanks everyone else for RT-ing it on twitter. If you like this post then please visit back & dont forget to follow me on twitter @zubairdotnet

While playing with Visual Studio 2010 I discovered that the Ultimate (and Premium) edition ship with SQL Data and Schema Compare tools out of the box, so I decided to give a whirl.

I made two databases, SourceDB & TargetDB with only one table Customer. Here’s how the data looked like.

Source	Target

The Wizard

Next I selected the Compare Data options on the source table from Server Explorer

This brought up the interface where I chose the target database and hit Next, I decided to leave the other options checked.

Next screen showed the tables and views that I wanted to compare, in my case the only table Customer.

---

The Result

Now the interesting part,

The changed records are off course highlighted.

In addition to the above ones that need to be updated, notice that there is only 1 record in the source table that the target needs to add and 1 identical that will remain unchanged,let’s look at them.

The Update

but this doesn’t end here, off course I could update my target database right from VS, for that I had two options, I could generate the script or have VS2010 do it for me.

Since I was playing, I thought let’s see both so I right-clicked and selected,

That brought up the generated Sql script in the editor that I could then use to update my target database,that looked like.

Let’s look a bit deeper,hmm VS disables FK constraints,performs the operation and then restores it back, pretty good.

Since I was a bit lazy so thought I will have VS do it for me, all I had to do was…right-click and select..

VS 2010 then presented a confirm dialog, I knew what I was doing so I hit OK and the changes were pushed to the target table.

Labels: sql data compare, VS 2010

# posted by Zubair.NET! @ 9:20 PM 13 comments

I attended this session of TechiesUAE presented by Rolf Eleveld. First he took us through the installation and configuration steps required to run Team Foundation Server 2010 and Visual Studio 2010 beta 2.

Rolf then showed some of the new features in TFS 2010 version control and its integration with VS2010 including the web interface of TFS.

Also during the session, one of the interesting tool that he showed us is the new Problem Steps Recorder (or PSR) that ships with Windows 7.

This tool can help developers and IT Pros know the steps required to reproduce any problem to resolve it more quickly. For more info on it watch this video

During the session we also discussed the use of Entity Framework & Linq to Entities in the enterprise and also saw the demo of the interesting new Lab management capabilities introduced in VSTS 2010. This helps testers test the software in a virtual environment and raise any bugs, the developers can then launch the virtual machine from the IDE and find all the rich information along with the check point link included in the bug, for more info on this read this post on Soma’s blog.

The session lasted more than 3 hours.

Update. Dec 3,2009
Read Rolf's detailed notes from the event on the TechiesLeaders blog

Labels: .NET 4.0, TechiesUAE, VS 2010

# posted by Zubair.NET! @ 1:57 PM 0 comments

I just watched a video over at Channel9 which explains how to leverage some of the UI Testing capabilities that are going to be introduced with VS 2010 beta 1 expected next week.

Visual Studio had testing capabilities for C# code for a long but now I’m glad to see for the first time an integrated UI testing built right into VS 2010 IDE. In particular I like the option to store the tests in the database and be able to run them automatically.

See it for yourself, there is also a Mix09 video here

Labels: .NET 4.0, UI Testing, VS 2010

# posted by Zubair.NET! @ 4:55 PM 0 comments