Notatki dla .NET w języku programowania C#

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

Czytaj dalej wpis Pomelo sql example
Zaloguj się aby dodać komentarz.

var row_updated = db.Articles
.Where(x => x.Id <= 10)
.Where(x => x.Title == "Hello World")
.Where(x => DateTime.Now >= x.Time)
.SetField(x => x.Title).Prepend("[old] ")
.SetField(x => x.IsPinned).WithValue(true)
.Update();

var row_updated2 = db.Articles
.Where(x => db.Users.Where(y => y.Id %2 == 0).Select(y=>y.Id).Contains(x.Id))
.Delete();

Kategoria:

.net inne