//입력
public Maxims AddMaxims(Maxims maxims)
{
string query = @"INSERT INTO Maxims (Name, Contents, RegDate) Values (@Name,@Contents,getdate());
SELECT CASE(SCOPE_IDENTITY() AS INT);";
var id = db.Query <int>(query, maxims).Single();
maxims.Id = id;
return(maxims);
}
// 입력
public Maxims AddMaxims(Maxims maxim)
{
string query = @"INSERT INTO Maxims (Name, Contents) Values (@Name, @Contents, getdate());
SELECT Cast(SCOPE_IENTITY() AS INT); ";
var id = this.db.Query <int>(query, maxim).Single();
maxim.Id = id;
return(maxim);
}
//입력
public Maxims AddMaxims(Maxims maxim)
{
string query = @"INSERT INTO Maxims (Name,Contnts) Values (@Name,@Contents);
Select Case(Scope_Identity() as int)";
var id = db.Query <int>(query, maxim).Single();
maxim.Id = id;
return(maxim);
}
// 입력
public Maxims AddMaxims(Maxims maxim)
{
string query = @"INSERT INTO Maxims (Name, Contents) Values (@Name, @Contents)
SELECT CASE(SCOPE_IDENTITY() AS INT);";
var id = db.Query(query, maxim).Single();
maxim.Id = id;
return(maxim);
}
