Data & Databases

Wong Shao Voon presents an application that can generate C# methods to call your stored procedure.

Make use of the Repository Pattern to break the dependencies between your application's domain model and data access code.

Learn to work with the SQL Azure web management portal as we walk through how to, set up firewall access rules, create and delete databases and more.

Learn the practice of using projections in your LINQ statements to ensure you are not over retrieving data values from your Entity Framework model.

Learn how to use table-valued parameters, introduced in SQL Server 2008, to boost the performance and scalability of your .NET framework applications. You'll also see an example of how to create and use the user-defined type.

Read along as Arun Karthick illustrates the ADO.NET Data Services features and how to utilize them in your data-centric projects.

Ever since the release of the Object Relational Mapping framework NHibernate, there has been a constant buzz to evaluate its performance and features. With Microsoft joining the battle with ADO.NET Entity Framework, the ever asked question becomes interestingly difficult and that is "to NHibernate or not?" This paper illustrates advantages and disadvantages of using NHibernate. Apart from highlighting pros and cons this paper also evaluates few open source tools related to NHibernate development.

Looking to provide greater flexibility to your data storage for your application and/or websites? Try out MongoDB with C# programming to provide the ability to store, search, update JSON like data in a database.

Learn how to use Microsoft's ADO.NET Entity Framework to connect to, consume and update a Microsoft SQL Server CE (Compact Edition) database.

Leverage the new and enhanced features of the Entity Framework 4.0 to design and implement scalable applications.

Back in the days of classic ASP, if you were building a database-driven web site, your choice was either to invest a lot of money to get a copy of Microsoft SQL Server (or some other enterprise-ready database) or invest a lot of time finding a way to deal with the performance and scalability limitations of Microsoft Access. Luckily these days there's another viable alternative: MySQL.

Learn about N-tier application architecture and realize that developing with multiple layers produces a flexible and reusable application for distribution to any number of client interfaces.

Microsoft SQL Server 2005 now offers great support for and close integration with XML as a data persistence format. In the first article of his series examining this new support, Alex Homer offers an overview of how SQL Server 2005 stores XML documents and schemas, examines how it supports querying and manipulating XML documents, and provides a simple test application that allows you to experiment with XQuery.

In the second part of of his article on using MySQL with ASP.NET, Ziran Sun covers how to add a new MySQL user to the database server, assign the user the appropriate permissions, connect to the database, and build a simple ASP.NET page to perform a query.

Adnan Masood discusses Microsoft's comprehensive integrated business intelligence, data mining, analysis and reporting solution: Microsoft SQL Server Analysis services and Microsoft SQL Server Reporting services.

Wayne Plourde begins his two-part series on creating a robust data access layer in .NET. Before writing any code, it is important to establish goals and setup and secure a database. Part one examines all the ingredients that exist in a professional data access component.

In this article, Matt Duckhouse describes how to connect a Macromedia Flash movie to an Access database using an ASP page as the data-transfer mechanism.

Thom Robbins explains how DataSet object features can be combined with XML to create a new type of object called the typed DataSet, which simplifies the task of data navigation.

The LINQ (Language INtegrated Query) family of technologies is designed to provide a unified approach to accessing data from disparate data sources. This article series will take you from the very basics all the way to performing data access using LINQ. The first installment of the series will focus on the basics of LINQ, introducing the new features of C# 3.0, and how they can be used in conjunction with LINQ.

User-defined functions are a new feature in SQL Server 2000. Karen Gayda shows how UDFs can be used to enhance queries and provide functionality that was previously unavailable.

Adnan Masood concludes his discussion of Microsoft SQL Server Analysis services and Microsoft SQL Server Reporting services. In the final part, he discusses Reporting Server web services and using custom code in reports.

Adnan Masood continues his discussion of Microsoft SQL Server Analysis services and Microsoft SQL Server Reporting services. In this part, he discusses the steps that go into building more advanced reports.

Developers and database administrators have long debated methods for paging recordset results from Microsoft SQL Server, trying to balance ease of use with performance. The simplest methods were less efficient because they retrieved entire datasets from SQL Server before eliminating records which were not to be included, while the best-performing methods handled all paging on the server with more complex scripting. The ROW_NUMBER() function introduced in SQL Server 2005 provides an efficient way to limit results relatively easily.

The first article in this two-part series provides a basic understanding of the theoretical principles of database design and describes some key elements and rules of creating relational databases.