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();