How do you execute raw SQL queries in Entity Framework?

How do you execute raw SQL queries in Entity Framework?

2025-05-26 19:36:41 - Admin Sarwar

// Execute raw SQL query

var users = context.Users

  .FromSqlRaw("SELECT * FROM Users WHERE Age > {0}", 18)

  .ToList();


// Execute raw SQL command

var rowsAffected = context.Database

  .ExecuteSqlRaw("UPDATE Users SET IsActive = 1 WHERE Age > {0}", 18);


// For stored procedures

var result = context.Users

  .FromSqlRaw("EXEC GetUsersByAge @Age = {0}", 25)

  .ToList();

More Posts