예제 #1
0
        public void AddBook(int id, string authorFirstName, string authorLastName, string bookTitle, int publicationDate, string publisher)
        {
            using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(SQLConnectionHelper.CnnVal("MyBooksDB")))
            {
                List <Book> books = new List <Book>();

                books.Add(new Book
                {
                    ID = id,
                    AuthorFirstName = authorFirstName,
                    AuthorLastName  = authorLastName,
                    BookTitle       = bookTitle,
                    PublicationDate = publicationDate,
                    Publisher       = publisher
                });

                connection.Execute("dbo.spINSERT @ID, @AuthorFirstName, @AuthorLastName, @BookTitle, @PublicationDate, @Publisher", books);
            }
        }
예제 #2
0
 public List <Book> GetBooks(string title)
 {
     using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(SQLConnectionHelper.CnnVal("MyBooksDB")))
     {
         //var output = connection.Query<Book>
         //	($"SELECT * FROM Books WHERE BookTitle ='{title}'").ToList();
         var output = connection.Query <Book>
                          ("dbo.spGetBookTitle @BookTitle", new { BookTitle = title }).ToList();
         return(output);
     }
 }