Cloud-hosted, grid-based applicationsRunning grid-based web applications in the cloud is a growing trend. The ability to host grid-based applications and scale them as needed is a very common use case can scenario that I plan to cover in this post.DevExpress offers one of the most powerful grids in existence. I've used it for many, many years - across web and thick client applications. They now support many other platforms as well.
This post will cover the whole spectrum of downloading data from a government site, loading it into an on premise SQL Server database, migrating this on premise SQL Server database to SQL database in Windows Azure. Next, we will add the powerful DevExpress ASP.NET Data Grid, which will read the data from the SQL database in the cloud. Next, we will add a to express grid, which will read the data from the SQL database in the cloud. As a final exercise migrate the entire web application into the cloud as well, so that we can provide needed scale.My LearningsI've help the couple of developers get over the hump and I want to share my learnings with you here today.DevExpress and Windows Azure can be used to create solutions that support an almost unlimited number of users.Build or Buy?As a developer, it is crucial to be able to provide a highly functional grid-based user interface to end-users. Ideally, this grid would behave like Excel, since spreadsheets are one of the best understood user interfaces on the planet. Minimal training is required and it can be very productive to use.Not trivial to buildProviding grid-based functionality in a browser is very challenging. Writing your own just doesn't make any sense. It can become very complex extremely quickly. To start, there's the whole technical challenge of supporting multiple browsers. Even for a single browser, there are many different versions to support. second, supporting basic crud operations is it trivial either, as the grid must now support the ability to insert, update and delete data. Third, there is the challenge of good performance and fast scrolling. Imagine a data store that has hundreds of thousands of records that need to be scrolled efficiently. How do you plan to implement paging inefficiently? And fourth, it’s important that grid be able to support touch on mobile devices.
SF Gov Data - Movies Shot in SF
There are a few things to notice about this bulk insert command. First, we can issue this command inside of a query in SQL Server management studio. Also notice that the first row property is set to because we want to skip over the column headings. Since this is a comma delimited file you need to specify that as well. In addition to the newline which acts as terminators for each row.
Not relationalOne thing to note is that the data is not structured well. The data actually does contain one-to-many relationships, but is stored in SQL Server as one big table. Normalizing the data to multiple tables is left as an exercise to the reader. Because the data is not properly normalized, it will prevent optimal behavior of the underlying data grid. Provisioning a database in the cloudBefore we can export the on premise database to the cloud we need to establish a server. A single server can service many databases. You can provision more servers as needed.The Windows Azure portal allows you to provision a server. Notice that in the figure below, we can list all the databases. But what we want is to list the services, because we will migrate a database to the server. We do not need to provision a separate database through the portal you see below. Instead, the tooling will provision this for us using the on premise database.
You can provision new servers as seen at the bottom of the portal. Simply click the add button below.
Once the deployment is complete, you should see the confirmation screen below.
You can obtain the needed connection information to the cloud hosted database directly from the Windows Azure portal. From the bat dashboard section, you will see a selection called, “Show connection strings.”If you click on the SFMovies database from the dashboard section of the portal, you will be able to get a needed connection string.
The project will get created with all the necessary references specified. What we need to do next visit add a blank form and then use the toolbox to drag a grid control to the blank form. From there we will connected to the database and start to set some properties for the grid to meet our functionality requirements.
Click next to “Save the connection.”For the sake of simplicity, we will set up a grid with the minimum of requirements. There is a vast amount of options and capabilities that we will not leverage in this example. What we will do is specify the columns that we are interested in as well as an ordering sequence for the data itself. We will sort that data by release year, as well as by the movie title.
You can see that the wizard will build the SQL statement for you.
Compile the application.
How To Publish a Web App to the Cloud
Why Platform as a Service will rule the world
Thanks a lot for such a article.....