//입력 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); }