What is Entity Framework and what are its top alternatives?
Top Alternatives to Entity Framework
It is a mature, open source object-relational mapper for the .NET framework. It's actively developed, fully featured and used in thousands of successful projects. ...
Entity Framework Core
It is a lightweight, extensible, open source and cross-platform version of the popular Entity Framework data access technology. It can serve as an object-relational mapper (O/RM), enabling .NET developers to work with a database using .NET objects, and eliminating the need for most of the data-access code they usually need to write. ...
Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper. ...
Sequelize is a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL, MariaDB, SQLite and MSSQL and features solid transaction support, relations, read replication and more. ...
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. ...
Doctrine 2 sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL. ...
It is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings. It eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results. It can use simple XML or Annotations for configuration and map primitives, Map interfaces and Java POJOs (Plain Old Java Objects) to database records. ...
It is a fantastic ORM library for Golang, aims to be developer friendly. It is an ORM library for dealing with relational databases. This library is developed on top of database/sql package. ...
Entity Framework alternatives & related posts
- DDD friendly3
related NHibernate posts
- Fits very well with Microsoft technologies4
related Entity Framework Core posts
- Easy ORM13
- Easy transaction definition7
- Is integrated with spring jpa1
- Can't control proxy associations when entity graph used3
related Hibernate posts
- Good ORM for node.js29
- Easy setup22
- Support MySQL & MariaDB, PostgreSQL, MSSQL, Sqlite12
- Open source9
- Promise Based6
- Atrocious documentation, buggy, issues closed by bots2
- Recommend for mongoose users1
- Docs are awful20
- Relations can be confusing3
related Sequelize posts
What is the best way to increase your income as a freelancer in 2019? What frameworks should be the best to learn? React Node.js Docker Kubernetes Sequelize Mongoose MongoDB ExpressJS hapi Based on trends I've picked up a JS full stack. If you need to work under startups you may replace React with Vue.js . If you want to work in outsourcing Angular 2+ may be better.
What is your opinion?
On backend, ExpressJS is a good place to start. Learn how to build semantic REST APIs that pull data from a database. MongoDB is fine, but I would suggest using Mongoose along with it to avoid nesting objects too much. You could alternatively use a SQL database like PostgreSQL, with an ORM like Sequelize to manage the data.
- Open Source3
related SQLAlchemy posts
Merging Django ORM with SQLAlchemy for Easier Data Analysis (Video Inside)
Development of products with Django framework is usually easy and straightforward; great documentation, many tools out of the box, plenty of open source libraries and big community. Django ORM takes full control about SQL layer protecting you from mistakes, and underlying details of queries so you can spend more time on designing and building your application structure in Python code. However, sometimes such behavior may hurt - for example, when you’re building a project related to data analysis. Building advanced queries with Django is not very easy; it’s hard to read (in Python) and hard to understand what’s going on in SQL-level without logging or printing generated SQL queries somewhere. Moreover, such queries could not be efficient enough, so this will hit you back when you load more data into DB to play with. In one moment, you can find yourself doing too much raw SQL through Django cursor, and this is the moment when you should do a break and take a look on another interesting tool, which is placed right between ORM layer and the layer of raw SQL queries.
- Great abstraction, easy to use, good docs13
- Easy setup5
related Doctrine 2 posts
- Easy to use4
- Integrated with Spring2
- Data-first support1