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);
     }
 }