zzz projects Entity Framework 6 EF 6
Home EF Core 5 Articles Knowledge Base Online Examples
  • Home
  • EF Core 5
  • Articles
  • Knowledge Base
  • Online Examples

Articles

2 results for:

Raw SQL Queries

Raw SQL Queries...Why Raw SQL Queries?...Entity Framework allows you to query using LINQ with your entity classes, but sometimes you want to run queries using raw SQL directly against the database. You will need raw SQL queries where you cannot use LINQ to represent the query, for example;...If the generated SQL is not efficient enough....If you want to make use of existing stored procedures...If you just prefer to write your queries in SQL....DbSet.SqlQuery...The ...DbSet.SqlQuery... method ena...
query raw-sql

Stored Procedure

Stored Procedure...What is Stored Procedure?...A stored procedure a SQL code that you can save so that the code can be reused over and over again....If you have an SQL query that you write over and over again, save it as a stored procedure, and then call it to execute it....You can also pass parameters to a stored procedure so that the stored procedure can act based on the parameter value(s) that is passed....Stored Procedure in Entity Framework...The Entity Framework allows you to use stored pr...
query stored-procedure raw-sql

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

Try for free now