Pomelo sql example

https://docs.microsoft.com/en-us/ef/core/querying/raw-sql
http://www.learnentityframeworkcore.com/raw-sql

using (var context = new SampleContext())
using (var command = context.Database.GetDbConnection().CreateCommand())
{
    command.CommandText = "SELECT * From Table1";
    context.Database.OpenConnection();
    using (var result = command.ExecuteReader())
    {
        // do something with result
    }
}

przykład SQL select

           IQueryable<Setting>  ccc = dbContext.Set<Setting>().FromSql("SELECT * FROM settings");
 
 
           string commandText = "INSERT INTO settings (desc, name, value) VALUES (@desc, @name, @value)";
           var desc = new SqlParameter("@desc", "opis opis");
           var name = new SqlParameter("@name", "test sql insert");
           var value = new SqlParameter("@value", "111");
           dbContext.Database.ExecuteSqlCommand(commandText, desc, name, value);
Kategoria: 
.net inne