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.

Discover a different way to look at EditItemTemplate — using which user navigation for editing is reduced and ... it looks very different then regular implementation of GridView.

With more and more computers using a multi-core processor, the free lunch of increased clock speeds and the inherent performance gains are over. Software developers must instead make sure their applications take use of all the cores available in an efficient manner. New features in .NET 4.0 mean that managed code developers too can join the party.

Learn to build a text DSL in MGrammar.

Learn how a DrawItem approach solves the issue of Multi Column Combobox cells in DataGridView of VS8.

Learn modeling and M development with the Oslo CTP SDK.

Walk through examples and see how existing Repository models are constructed using the M language, how the models are stored in a SQL database, and how to query the SQL database for model information.

Discover how to use nullable types when retrieving data from your database.

Developers working at all levels of experience can take advantage of this technique. Discover how to invoke a stored procedure with parameters using the AddWithValue method of the SqlParameterCollection to define SQL parameters in one step.

Learn how to build Unit tests and generate sample data for your database development projects.

Careful registration of information in a Portal can be vitally important to a company, not only internally but also for possible juridical consequences. SharePoint 2007 has the necessary infrastructure to gather and conserve the entries in a secure way.

Store XML data directly in SQL Server. Use the power of the XML data type to store and manipulate XML data efficiently and easily.

Discover how reporting applications can adapt to changing reports by shifting its report-related information into a database.

Many organizations are not fully realizing the power of content types when using SharePoint. Here you will learn how to leverage content types and use them properly through examples.

Control the SQL Server service from your VB code using SQL Management Objects (SMO).

Provide your own comparison algorithm when sorting by implementing the IComparer interface.

Allow your classes to easily be sorted they way you would like by implementing the IComparable interface.

Learn how ADO.NET connection pooling works and how to configure it to suit your performance requirements.

By Jani Järvinen - Learn to nest your ADO.NET 2.0 transactions correctly with the TransactionScope class, and see how this information can be used with SQL Server databases.