public void InsertSamurai()
{
var samurai = new Samurai()
{
Name = "bobo"
};
using (var context = new SamuraiSqlServerContext())
{
context.Samurais.Add(samurai);
context.SaveChanges();
}
}
public void RunStoredProcedure()
{
using (var context = new SamuraiSqlServerContext())
{
string nameToSearch = "Julia";
var samurai = context.Samurais
.FromSql($"EXEC dbo.FilterSamuraiByPartOfName {nameToSearch}")
.OrderByDescending(s => s.Name)
.Where(s => (s.Name ?? "") != "")
.ToList();
samurai.ForEach(s => Console.WriteLine(s.Name));
Console.WriteLine();
}
}
public CreateAndSelectDataExamples()
{
Context = new SamuraiSqlServerContext();
}
