Notatki dla .NET w języku programowania C#

JSON Web Tokens

JSON Web Tokens

https://jwt.io/

Kategoria: 

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: 

Pomelo update example

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: 

sql command

sqlcmd -S SERVER\INSERTGT -P
sqlcmd -S SERVER\INSTANCE -Q "sp_databases" -P

select name from sys.databases
go

Kategoria: 

Strony

Subskrybuj Notatki dla .NET w języku programowania C#