ORM (eng. Object-Relational Mapping, eng. object-relational mapping) — a programming technique that links databases to the concepts of object-oriented programming languages, creating a «virtual object database». There are both proprietary and free implementations of this technology.
Task. You need to work with the data in terms of classes instead of tables of data and conversely, to transform the terms and the data classes in the data suitable for storage in the DBMS. It is also necessary to provide an interface for CRUD operations on the data. In General, it is necessary to eliminate the need to write SQL code to interact in a DBMS
Language Integrated Query (LINQ) project to add Microsoft syntax query language reminiscent of SQL to the programming languages of the platform .NET Framework. Was previously implemented in languages C# and Visual Basic .NET. Many concepts that introduces LINQ, initially tested in a research project of Microsoft.
ADO.NET is a set of classes that provide data access services programmers who use the platform .NET Framework. ADO.NET has a rich set of components for creating distributed, data-sharing applications. It is an integral part of the platform .NET Framework, which provides access to relational, XML and application data. ADO.NET meets various needs of developers, including the creation of client applications, databases, and business objects intermediate level used by applications, tools, languages, and browsers.
Links to materials for the study
- ORM libraries
- Language-Integrated Query (LINQ) (C#)
- Overview ADO.NET
- Overview of the Entity Framework
- Introduction to Entity Framework
- LINQ - language integrated query
- Platform ADO.NET and Entity Framework
- Working with databases in .NET Framework
- Microsoft Visual Studio
- MonoDevelop (Cross platform IDE for C#, F# and more)
- LINQPad (The .NET Programmer’s Playground)
- dotPeek (Free .NET Decompiler and Assembly Browser)