public State Create(State state) { const string SQL = @" INSERT INTO STATE (Code, Name) VALUES (@Code, @Name); SELECT SCOPE_IDENTITY() "; var id = ExecuteScalar(SQL, CommandType.Text, new[] { GetDbParameter("@Code", state.Code), GetDbParameter("@Name", state.Name) }); state.Id = Convert.ToInt32(id); return state; }
public State Update(State state) { const string SQL = @" UPDATE STATE SET Code = @Code, Name = @Name WHERE Id = @Id "; var id = ExecuteNonQuery(SQL, CommandType.Text, new[] { GetDbParameter("@Code", state.Code), GetDbParameter("@Name", state.Name), GetDbParameter("@Id", state.Id) }); return state; }