public void Update(BooksStaroseletsEV book) { using (IDbConnection db = new SqlConnection(connectionString)) { var sqlQuery = "UPDATE Books SET Name = @name, Publisher = @publisher, Anotation = @anotation, Binding = @binding, Year = @year, Count = @count, Author = @author, Ganres = @ganres " + "WHERE idBooks = @id"; db.Execute(sqlQuery, book); } }
public void Create(BooksStaroseletsEV book) { using (IDbConnection db = new SqlConnection(connectionString)) { var sqlQuery = "INSERT INTO Books (Name, Publisher, Anotation, Binding, Year, Author, Ganres, Count) " + "VALUES(@name, @publisher, @anotation, @binding, @year, @author, @ganres, @count)"; db.Execute(sqlQuery, book); } }