/// <summary> /// Read books, authors, etc., from the KaggleGoodReadsBookDataset on our server. /// Our VPN needs to be running. /// There is no error handling at all. /// </summary> /// <returns>A List object containing the collection of Book objects</returns> public static List <Book> ReadBooks() { List <SQLServerToolsDemo.Book> books = new List <Book>(); string query = "SELECT Book, PagesNumber, Author, Language, Publisher " + "FROM tBook B " + "INNER JOIN tAuthor A ON B.AuthorID = A.AuthorID " + "INNER JOIN tLanguage L ON B.LanguageID = L.LanguageID " + "INNER JOIN tPublisher P ON B.PublisherID = P.PublisherID " + "ORDER BY Book ASC"; SQLServerTools.SQLServerTools sqlServerTools = new SQLServerTools.SQLServerTools("IL-Server-002.uccc.uc.edu\\MSSQLServer2019", "KaggleGoodReadsBookDataset", "KaggleGoodReadsBookDatasetLogin", "P@ssword1"); sqlServerTools.ConnectToDatabase(); SqlDataReader dr = sqlServerTools.submitSQL(query); if (dr.HasRows) { while (dr.Read()) { Book book = new Book(); book.BookTitle = dr.GetString(0); book.Author = dr.GetString(2); book.Language = dr.GetString(3); book.Publisher = dr.GetString(4); books.Add(book); } } return(books); }
public Demo() { SQLServerTools.SQLServerTools sqlServerTools = new SQLServerTools.SQLServerTools("IL-Server-002.uccc.uc.edu\\MSSQLServer2019", "nicomp", "nicomp", "Danger42!"); sqlServerTools.HelloWorld(); sqlServerTools.ConnectToDatabase(); SqlDataReader dr = sqlServerTools.submitSQL("SELECT * FROM tFish"); //check if there are records if (dr.HasRows) { while (dr.Read()) { //display retrieved record (second column only/string value) Console.WriteLine(dr.GetString(1)); // Columns are zero-based } } else { Console.WriteLine("No data found."); } }