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