public static int Create(Task.Models.Person person)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var sqlQuery = "insert into Person (LastName, FirstName, MiddleName) values(@LastName, @FirstName, @MiddleName); select cast(SCOPE_IDENTITY() as int)";
int newPersonId = db.Query <int>(sqlQuery, person).FirstOrDefault();
return(newPersonId);
}
}
public static void InitData()
{
Task.Models.Person fahaPerson = new Task.Models.Person();
fahaPerson.LastName = "Faridun";
fahaPerson.FirstName = "Berdiev";
fahaPerson.MiddleName = "Hasanovich";
Task.Models.Person mjonPerson = new Task.Models.Person();
mjonPerson.LastName = "Mijgona";
mjonPerson.FirstName = "Jumaeva";
mjonPerson.MiddleName = "Shohinovna";
Task.Models.Person jofiPerson = new Task.Models.Person();
jofiPerson.LastName = "Firuz";
jofiPerson.FirstName = "Jonmamadov";
jofiPerson.MiddleName = "Raimovich";
PersonContext.Create(fahaPerson);
PersonContext.Create(mjonPerson);
PersonContext.Create(jofiPerson);
}