...
/Understanding Modern Database and Entity Framework Core
Understanding Modern Database and Entity Framework Core
Learn about modern databases and gain insights into the Entity Framework, Entity Framework Core, and the use of Object-Relational Mapping (ORM).
Two of the most common places to store data are in a Relational Database Management System(RDBMS) such as SQL Server, PostgreSQL, MySQL, and SQLite, or in a NoSQL database such as AzureCosmos DB, Redis, MongoDB, and Apache Cassandra.
Relational database
Relational databases were invented in the 1970s. They are queried with Structured Query Language(SQL). At the time, data storage costs were high, so they reduced data duplication as much as possible. Data is stored in tabular structures with rows and columns that are tricky to refactor once in production. They can be difficult and expensive to scale.
NoSQL
NoSQL databases do not just mean “no SQL”; they can also mean “not only SQL.” They were invented in the 2000s, after the internet and the web had become popular and adopted many of the learnings from that era of software. They are designed for massive scalability, high performance and to make programming easier by providing maximum flexibility and allowing schema changes at any time because they do not enforce a structure.
Understanding legacy Entity Framework
Entity Framework (EF) was first released as part of .NET Framework 3.5 with Service Pack 1 in late 2008. Since then, Entity Framework has ...