Articles

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

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