private static void AddBook(Book book) { MySqlCommand cmdInsertBook = new MySqlCommand( "INSERT INTO Books(Title, ISBN, PublishDate) " + "VALUES (@title, @iSBN, @publishDate)", conn); cmdInsertBook.Parameters.AddWithValue("@title", book.Title); cmdInsertBook.Parameters.AddWithValue("@iSBN", book.ISBN); cmdInsertBook.Parameters.AddWithValue("@publishDate", book.Date); cmdInsertBook.ExecuteNonQuery(); Console.WriteLine("Book added!"); }
internal static void Main() { Console.Write("Enter pass: "******"Server=localhost; Database=store; Port=3306; Uid=root; Pwd=" + pass + ";"; conn = new MySqlConnection(connectionStr); conn.Open(); using (conn) { MySqlCommand command = new MySqlCommand( "CREATE TABLE Books " + "( " + " BookID int NOT NULL AUTO_INCREMENT, " + " Title nvarchar(100) NOT NULL, " + " ISBN nvarchar(100) NOT NULL, " + " PublishDate date NOT NULL, " + " CONSTRAINT PK_Books PRIMARY KEY (BookID) " + ");", conn); command.ExecuteNonQuery(); Console.WriteLine("The Books table is created in store database!"); var book = new Book { Title = "C# masters", ISBN = "43243242", Date = DateTime.Today }; AddBook(book); AddBook(book); ListAllBooks(); var title = "C# masters"; bool foundBook = FindBookByTitle(title); Console.WriteLine("FoundBook: {0}", foundBook); } }