Database Articles

CSharp-Online.NET:Articles

.NET Articles ASP.NET Articles C# Articles Database Articles Java Articles Visual Studio Articles Windows Articles

edit

Database Articles are submitted by our contributors and cover database topics including ADO.NET, LINQ—Language-Integrated Query, MySQL, and SQL Server.

Contents 1 Database Articles 1.1 ADO.NET 1.2 Language INtegrated Query (LINQ) 1.3 SQL Server

Database Articles

• Introducing LINQ - learn to use the new, .NET, general purpose, query capability called LINQ—Language-Integrated Query.

• Relational Databases 101 - learn the fundamentals of Relational Database Management Systems (RDBMS).

ADO.NET

• Connecting to Data with ADO.NET - Learn how to connect to a variety of data sources from ADO.NET; how to handle security-related issues including storing connection strings and using different authentication methods; and how to set up, monitor, and optimize connection pooling.

• Data Components in Visual Studio .NET - learn to use ADO.NET data components in Visual Studio .NET at design-time to create database applications.

• DataViews and Data Binding - learn to use the ADO.NET controls—DataView, DataViewManager.

• LINQ to ADO.NET - Learn to map LINQ—Language-Integrated Query to databases using classes, properties, and attributes; to manage the DataContext class which supports LINQ ORM functionality; to take advantage of advanced database features—concurrency, stored procedure calls, transactions, etc.; employ Visual Studio support for LINQ to SQL, including IntelliSense and debugging; use LINQ to SQL integrated into ADO.NET with DataSet objects.

• Working with Data - learn SQL, data binding, ADO.NET Datasets, and how to connect to SQL Server and Microsoft Access databases. Also, learn to build your own SQL Query program that works with Access databases.

• XML and ADO.NET - learn to leverage the XML features built into SQL Server and examine the new XML data type in SQL Server 2005.

Language INtegrated Query (LINQ)

• C# 3.0 Language Enhancements for LINQ - learn about the C# enhancements which make LINQ—Language-Integrated Query integrate seamlessly with the C# language.

• Introducing LINQ - learn to use the new, .NET, general purpose, query capability called LINQ—Language-Integrated Query.

• LINQ to ADO.NET - Learn to map LINQ—Language-Integrated Query to databases using classes, properties, and attributes; to manage the DataContext class which supports LINQ ORM functionality; to take advantage of advanced database features—concurrency, stored procedure calls, transactions, etc.; employ Visual Studio support for LINQ to SQL, including IntelliSense and debugging; use LINQ to SQL integrated into ADO.NET with DataSet objects.

SQL Server

• Building Reports in SQL Server 2005 - learn to use the SQL Server Report Wizard and to write reports from scratch.

• Data Mining with SQL Server 2005 - learn how to mine your data for information with SQL Server 2005.

• In-Process Data Access in SQL Server 2005 - learn that the .NET Framework 2.0 version of SqlClient contains code to encapsulate differences when you’re programming inside SQL Server and how to optimize the in-server programming environment.

• Notification Services - learn to use SQL Server 2005 Notification Services—a programming framework based on T-SQL and XML.

• Reporting Services Architecture - find out what's new in SQL Server Reporting Services (SSRS) 2005 and take a quick look at its architecure in SQL Server 2005.

• SQL Server Management Objects - learn to script database objects with SQL Server Management Objects (SMO).