Build an OLAP Cube in SSAS using an ADO.NET Data Provider

SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]

SQL Server From .Net: Reading SQL Server Metadata in ADO.Net

A basic introduction for developers (or anyone) about reading the metadata of a SQL Server database from a .Net application.

SQL Server From .Net: Building a DataSet with Code

A basic introduction for developers about working with the DataSet object in ADO.Net to represent objects in a SQL Server database, and some of the options available.

The Case for Specifying Data Types and Query Performance

Performance penalties for omitting SQL data types when using ADO.Net or light weight ORMs.

ADO.NET Entity Framework - SQL Server 2008

Implementing a Generic Data Access Layer in ADO.NET Part 1

In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.

Implementing a Generic Data Access Layer in ADO.NET Part 3

The 3rd and final of the 3 Part Series discussing the implementation of a provider independent Data Access Layer in ADO.NET.

Implementing a Generic Data Access Layer in ADO.NET Part 2

In Part 2 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.

Implementing a Generic Data Access Layer in ADO.NET Part 1

In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.

Designing an Entity Data Model

The Entity Framework is an exciting new technology being developed for ADO.NET. It allows developers to view data using a logical model instead of a physical model, offering more flexibility.