ADO.NET Data Services leverages the ADO.NET Entity Framework to build data services for relational data sources. These include support for MySQL, DB2, and Oracle in addition to MS SQL Server. It can also be used with non-relational data using an add-on provider model. With ADO.NET Data Services, the developers can build dynamic internet applications (AJAX, Silverlight, etc) that works across intranets as well as the internet. With this in place data access by applications is made possible using URI Syntax and using HTTP verbs operating on the data.
In this article by Dr. Jayaram Krishnaswamy, you will learn how to create a ADO.NET Data Service from scratch. You will also learn how you may access data using the URI constructs. The backend data for this tutorial comes from a copy of Northwind database named TestNorthwind on a named instance of SQL Server 2008. In order to work through this tutorial you should have Visual Studio 2008 SP1 installed. You also need to have .NET Framework 3.5 installed.Read Data Access with ADO.NET Data Services in full
Primarily, the Microsoft Office Outlook serves as an email application for a wide range of users. In the previous part of the article, we took an Overview of the Outlook object model and its features in VSTO. We saw the extensibility of Microsoft Office Outlook 2007 using the object model. We also learned to customize Microsoft Office Outlook menus and toolbars using VSTO. In the last part, we worked with form regions in Outlook, how to manipulate folders, contact information, and mail items using VSTO programming.
In this article by Vivek Thangaswamy, we will take a look at the following topics:
- Learning the concepts and seeing a demonstration of working with Outlook meetings and appointments
- Working with Ribbons for Outlook 2007
- Outlook applications and the Microsoft SQL Server 2008 database interaction
Ever since Microsoft started working on the ASP.NET MVC framework, one of the primary concerns was the framework's ability to re-use as many features as possible from ASP.NET Webforms. In this article by Maarten Balliauw, we will see how we can mix ASP.NET Webforms and ASP.NET MVC in one application and how data is shared between both these technologies.Read Mixing ASP.NET Webforms and ASP.NET MVC in full
One of the driving goals for the ASP.NET MVC framework has been to create a flexible framework in which every component can be extended or replaced by a custom solution, whether developed by you or obtained from a third-party vendor. In this article by Maarten Balliauw, you will learn how you can customize and extend the ASP.NET MVC framework.Read Customizing and Extending the ASP.NET MVC Framework in full
In this article by Dr. Jayaram Krishnaswamy, the process of programmatically creating the SQL Server Reporting Services (SSRS) tabular report is described. You will be creating a very simple report using the provided code. The approach is to introduce the programming by creating the three parts of a report: connection, dataset, and layout.Read Programmatically Creating SSRS Report in Microsoft SQL Server 2008 in full
In this article by Dr. Jayaram Krishnaswamy, we will learn about migration of data from MS SQL Server 2008 to EnterpriseDB. Migration Studio bundled with the EnterpriseDB download is a collection of tools to migrate automatically the data and business logic into Postgres from a variety of vendor products that include SQL Server, Oracle, MySQL to mention a few. This article shows you step by step how you may migrate a SQL Server 2008 table to Postgres Plus. You can only migrate tables and schemas but not database as a whole.Read Migrating from MS SQL Server 2008 to EnterpriseDB in full
As SharePoint and the underlying .NET Framework developed over the years, more readymade controls have become available for us to use in our applications. Such controls allow us to drop common, and often complex, features into our site. For example, if we would like to add user registration and login features (often referred to as personalization and membership) to our site, it is a chore to build everything we require (registration form with validation, login box, password reminder, change password, etc.) each time we build a site. Microsoft has built these controls for us so that we can easily add them to our site. In this article by Mike Poole, we will examine the use of these controls.
Very occasionally, we find that we are not able to do what we would like to do with the SharePoint configuration that comes "out of the box". A common example of this is using forms authentication in our site. Later on in the article, we will also make some configuration changes to SharePoint and associated products, such as Internet Information Services (IIS), SQL Server, and Visual Studio, to demonstrate how forms authentication can be enabled.Read Using ASP.NET Controls in SharePoint in full
Beginning with programming in Excel 2007 using VSTO 3.0 and proceeding with programming concepts, we are going to learn how to manipulate data inside Excel. Later, you will learn the concepts of workbook manipulation and worksheet manipulation, with code samples. When programming in the Excel 2007, the object model plays an important role. You will learn the most important and widely used objects, with the help of demonstrations.
In this article by Vivek Thangaswamy, we will take a look at the following:
- Excel 2007 in Visual Studio 2008, including how to start an Excel solution in Visual Studio 2008
- Excel 2007 solution: the object model, and the object model functional area
- Data and worksheet manipulation in Excel 2007
- Data processing with Microsoft SQL Server 2008
The Export and Import Wizard is an extremely useful tool for transferring data. In fact it is the simplest tool to copy over data from one database to another and to create data transfer packages that can be persisted. Data can be transferred between SQL Servers (between versions of SQL Servers for example) as well as between even two non-Microsoft databases. Both Microsoft and proprietary data source providers are available to connect to many different database products.
In this article by Dr. Jayaram Krishnaswamy, we will be transferring data from an MS Access database to a database on SQLServer 2008. Both the source of data and the destination database are on the same machine, in this case a computer box running Windows XP Pro. There are two versions of the Import and Export Wizard and in this example the 32 bit version is used.Read Transferring Data from MS Access 2003 to SQL Server 2008 in full