Need advice about which tool to choose?Ask the StackShare community!

Entity Framework Core

271
197
+ 1
16
SQLAlchemy

823
443
+ 1
5
Add tool

SQLAlchemy vs Entity Framework Core: What are the differences?

Developers describe SQLAlchemy as "The Python SQL Toolkit and Object Relational Mapper". SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. On the other hand, Entity Framework Core is detailed as "*Lightweight and cross-platform version of the popular Entity Framework *". 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.

SQLAlchemy and Entity Framework Core can be categorized as "Object Relational Mapper (ORM)" tools.

SQLAlchemy and Entity Framework Core are both open source tools. Entity Framework Core with 8.01K GitHub stars and 2.05K forks on GitHub appears to be more popular than SQLAlchemy with 3.37K GitHub stars and 890 GitHub forks.

Pinnovate, WakaTime, and YOU-app are some of the popular companies that use SQLAlchemy, whereas Entity Framework Core is used by Heimdal Security, InnoCellence, and accuRx. SQLAlchemy has a broader approval, being mentioned in 46 company stacks & 122 developers stacks; compared to Entity Framework Core, which is listed in 3 company stacks and 13 developer stacks.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Entity Framework Core
Pros of SQLAlchemy
  • 7
    Fits very well with Microsoft technologies
  • 4
    Fast
  • 2
    Linq
  • 1
    OpenSource
  • 1
    Multiple Database provider
  • 1
    Easy to use
  • 5
    Open Source

Sign up to add or upvote prosMake informed product decisions

Cons of Entity Framework Core
Cons of SQLAlchemy
  • 1
    Dbcontext
    Be the first to leave a con

    Sign up to add or upvote consMake informed product decisions

    What is 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.

    What is SQLAlchemy?

    SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.

    Need advice about which tool to choose?Ask the StackShare community!

    Jobs that mention Entity Framework Core and SQLAlchemy as a desired skillset
    CBRE
    United States of America Massachusetts Boston
    What companies use Entity Framework Core?
    What companies use SQLAlchemy?
    See which teams inside your own company are using Entity Framework Core or SQLAlchemy.
    Sign up for StackShare EnterpriseLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with Entity Framework Core?
    What tools integrate with SQLAlchemy?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to Entity Framework Core and SQLAlchemy?
    Entity Framework
    It is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.
    NHibernate
    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.
    Hibernate
    Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.
    Sequelize
    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.
    Dapper
    It is an object-relational mapping product for the Microsoft.NET platform: it provides a framework for mapping an object-oriented domain model to a traditional relational database.
    See all alternatives