Explore the powerful and versatile data access capabilities offered by the .NET Framework. This section provides comprehensive documentation on APIs designed to connect to, retrieve, manipulate, and store data from various sources.
ADO.NET
ADO.NET is a set of classes that expose data access services, enabling you to consume data from data sources like SQL Server and XML, and data services that consume data from sources outside a relational database. It provides a balanced set of tools for working with data, from basic data retrieval to advanced data manipulation.
Key Components:
Entity Framework Core
Entity Framework Core (EF Core) is a modern, cross-platform, and extensible version of the object-relational mapper (ORM) for .NET. It enables developers to work with databases using .NET objects, abstracting away much of the underlying SQL.
LINQ to SQL
LINQ to SQL is a component of the .NET Framework that provides a run-time infrastructure for managing data from relational databases as objects. It translates SQL queries into object-oriented syntax in .NET languages.
Data Access Technologies
A comprehensive overview of different data access strategies and technologies available within the .NET ecosystem, including considerations for performance, scalability, and maintainability.