Demo: Using Entity Framework to Create and Query a SQL Azure Database In Less Than 10 Minutes

[This article was contributed by the SQL Azure team.] As we were developing this week’s posts on utilizing Entity Framework with SQL Azure we had an opportunity to sit down and talk with Faisal Mohamood, Senior Program Manager of the Entity Framework team.  As we’ve shared in earlier posts this week, one of the beautiful…


Model First For SQL Azure

[This article was contributed by the SQL Azure team.] One of the great uses for ADO.NET Entity Framework 4.0 that ships with .NET Framework 4.0 is to use the model first approach to design your SQL Azure database. Model first means that the first thing you design is the entity model using Visual Studio and…


Why use the Entity Framework with SQL Azure?

[This article was contributed by the SQL Azure team.] This week I’ll be spending some time diving into using Entity Framework with SQL Azure. The Entity Framework provides the glue between your object oriented code and the SQL Azure relational database in a framework that is fully compatible with your skills and development tools. Integrated…


Developing Applications for the Cloud on Azure

[This article was contributed by the SQL Azure team.] The Microsoft Patterns & Practices group has published the second free online book volume about Developing Applications for the Cloud on the Microsoft Windows Azure Platform. This book demonstrates how you can create a multi-tenant, Software as a Service (SaaS) application to run in the cloud…


Creating Tables with Project Houston

[This article was contributed by the SQL Azure team.] This is the second post in a series about getting started with Microsoft Project Code-Named “Houston” (Houston) (Part 1). In part 1 we covered the basics, logging in and navigation. In this post we will cover how to use the table designer in Project Houston. As…


Hi, I’m Steve

[This article was contributed by the SQL Azure team.] Hi everyone.  I’m Steve Yi, technical product manager for SQL Azure. You’ll start seeing posts from me on the SQL Azure blog so I wanted to start off by saying hi and introducing myself.   I work closely with the engineering teams on listening to customer feedback…


New Web Site for SQL Azure

[This article was contributed by the SQL Azure team.] We are pleased to announce the launch of the new SQL Azure web site — bookmark this now! www.microsoft.com/sqlazure. This new site has an improved customer experience with faster discovery of relevant and richer information on SQL Azure. Highlights of the new SQL Azure site: Easy…


Create a Numbers Table in SQL Azure

[This article was contributed by the SQL Azure team.] Often you may require number table for various purposes like parsing a CSV file into a table, string manipulation, or finding missing identities (see example below), etc. Numbers tables are used to increase performance (by avoiding cursors) and simplify queries. Because SQL Azure requires all tables…


Securing Your Connection String in Windows Azure: Part 4

[This article was contributed by the SQL Azure team.] This is the fourth part in a multi-part blog series about securing your connection string in Windows Azure. In the first blog post (found here) a technique was discussed for creating a public/private key pair, using the Windows Azure Certificate Store to store and decrypt the…