Code first: EF Core allows developers to create a database from code, which enables a more agile and test-driven development workflow. LINQ support: EF Core supports LINQ, a powerful and expressive query language, which allows developers to write efficient and readable queries using C# or Visual Basic.
EF core is a mature database framework that is based on entity framework, however since EF6 entity framework is no longer supported.
read more
There are other ways to access a database, like mini Orm like dapper, or plain old stored procedures, and ado .net.