EF Core n?o ¨¦ lento vou te provar!
?Download as PPTX, PDF?
0 likes?141 views
This document discusses Entity Framework Core, including that it was rewritten from scratch, the supported database providers and engines, comparisons to Entity Framework 6 and Dapper, and demonstrations of GroupBy queries and performance comparisons between EF Core and Dapper. Key points include EF Core supporting many database engines like SQL Server, SQLite, PostgreSQL and more via NuGet packages, differences between EF Core and EF 6, and demonstrations of EF Core and Dapper queries and performance.
![EXEMPLOGROUPBY¨C
INACREDIT?VEL
#VSSUMMIT
SELECT [p].[Descricao] FROM [Eventos] AS [p]](https://image.slidesharecdn.com/vssummit2018v1-180604000144/85/EF-Core-nao-e-lento-vou-te-provar-6-320.jpg)
![EXEMPLOGROUPBY¨C CORRETO
#VSSUMMIT
SELECT [p].[Descricao],
COUNT(*) AS [Total]
FROM [Eventos] AS [p]
GROUP BY [p].[Descricao]](https://image.slidesharecdn.com/vssummit2018v1-180604000144/85/EF-Core-nao-e-lento-vou-te-provar-7-320.jpg)
EF Core n?o ¨¦ lento vou te provar!
- 1. RAFAEL ALMEIDA VISUAL STUDIO AND DEVELOPMENT TECHNOLOGIES RALMS@RALMS.NET EF CORE N?O ? LENTO VOU TE PROVAR! #VSSUMMIT
- 2. CONSTRU??ODOENTITY FRAMEWORKCORE #VSSUMMIT Por que ele foi reescrito do ZERO?
- 3. BANCOSSUPORTADOS/PROVIDERS DISPON?VEIS #VSSUMMIT NuGet Package Supported database engines Maintainer / Vendor Microsoft.EntityFrameworkCore.SqlServer SQL Server 2008 onwards EF Core Project (Microsoft) Microsoft.EntityFrameworkCore.Sqlite SQLite 3.7 onwards EF Core Project (Microsoft) Microsoft.EntityFrameworkCore.InMemory EF Core in-memory database EF Core Project (Microsoft) Npgsql.EntityFrameworkCore.PostgreSQL PostgreSQL Npgsql Development Team Pomelo.EntityFrameworkCore.MySql MySQL, MariaDB Pomelo Foundation Project Pomelo.EntityFrameworkCore.MyCat MyCAT Server Pomelo Foundation Project EntityFrameworkCore.SqlServerCompact40 SQL Server Compact 4.0 Erik Ejlskov Jensen EntityFrameworkCore.SqlServerCompact35 SQL Server Compact 3.5 Erik Ejlskov Jensen MySql.Data.EntityFrameworkCore MySQL MySQL project (Oracle) FirebirdSql.EntityFrameworkCore.Firebird Firebird 2.5 and 3.x Ji?¨ª ?in?ura EntityFrameworkCore.FirebirdSql Firebird 2.5 and 3.x Rafael Almeida IBM.EntityFrameworkCore Db2, Informix IBM IBM.EntityFrameworkCore-lnx Db2, Informix IBM IBM.EntityFrameworkCore-osx Db2, Informix IBM Devart.Data.Oracle.EFCore Oracle 9.2.0.4 onwards DevArt Devart.Data.PostgreSql.EFCore PostgreSQL 8.0 onwards DevArt Devart.Data.SQLite.EFCore SQLite 3 onwards DevArt Devart.Data.MySql.EFCore MySQL 5 onwards DevArt EntityFrameworkCore.Jet Microsoft Access files Bubi FONTE: https://docs.microsoft.com/en-us/ef/core/providers/
- 4. ENTITYFRAMEWORK6 VSENTITY FRAMEWORKCORE2.X #VSSUMMIT ? N?O ? COMPATIVEL COM .NET CORE (AINDA) ? PERFORMANCE E PROJE??O DE CONSULTAS ? AFAIK: N?O FAZ INSER??O EM MASSA
- 6. EXEMPLOGROUPBY¨C INACREDIT?VEL #VSSUMMIT SELECT [p].[Descricao] FROM [Eventos] AS [p]
- 7. EXEMPLOGROUPBY¨C CORRETO #VSSUMMIT SELECT [p].[Descricao], COUNT(*) AS [Total] FROM [Eventos] AS [p] GROUP BY [p].[Descricao]
- 9. ENTITYFRAMEWORKCORE2.X #VSSUMMIT ? DEMO DAPPER ? DEMO EF CORE + EXTENS?O