SQL Server Database Programming with C#: Desktop and Web Applications

Databases have become an integral part of modern-day life. We live in an information-driven society and database technology has a direct impact on our daily lives. Decisions are routinely made by organizations based on the information collected and stored in the databases. Because databases play such an important role in business and society, database programming is a key skill.

SQL Server Database Programming with C#: Desktop and Web Applications is for college students and software programmers who want to develop practical and commercial skills in database programming with C# or Visual C#.NET 2022 as well as the relational database Microsoft SQL Server 2019. The book explains the practical considerations and applications in database programming with Visual C# 2022 and provides realistic examples and detailed explanations. A direct writing style is combined with real-world examples to provide readers with a clear picture of how to handle database programming issues in the Visual C#.NET 2022 environment.

Highlights include:

• A complete sample database CSE_DEPT, built with Microsoft SQL Server 2019 Express, is provided and used for the entire book. Step-by-step, detailed illustrations and descriptions show how to design and build a practical relational database.
• Both fundamental and advanced database-programming techniques are covered to benefit beginning students and experienced programmers.
• An advanced database query technique, LINQ API, which includes LINQ to Objects, LINQ to DataSet, LINQ to SQL, LINQ to Entities and LINQ to XML, is discussed, analyzed, and implemented in actual projects with line-by-line explanations.
• Homework and class projects are provided for each chapter to strengthen and improve students' abilities to learn and understand the topics they studied.
• PowerPoint teaching slides and selected homework solutions help instructors to teach and organize their classes easily and effectively.

Useful and practical, this textbook is an intuitive guide on how to develop and build professional and practical database applications.

資料庫已成為現代生活中不可或缺的一部分。我們生活在一個資訊驅動的社會，資料庫技術直接影響著我們的日常生活。組織通常根據資料庫中收集和存儲的資訊做出決策。由於資料庫在商業和社會中扮演著如此重要的角色，資料庫程式設計是一項關鍵技能。

《SQL Server Database Programming with C#: Desktop and Web Applications》適用於大學生和軟體程式設計師，他們希望在使用C#或Visual C#.NET 2022進行資料庫程式設計以及使用關聯式資料庫Microsoft SQL Server 2019時，能夠發展實用和商業技能。本書解釋了使用Visual C# 2022進行資料庫程式設計的實際考慮因素和應用，並提供了實際範例和詳細解釋。直接的寫作風格結合現實世界的範例，為讀者清晰地呈現了如何在Visual C#.NET 2022環境中處理資料庫程式設計問題。

重點包括：
- 提供了一個完整的範例資料庫「CSE_DEPT」，使用Microsoft SQL Server 2019 Express構建，並在整本書中使用。逐步詳細的圖示和描述展示了如何設計和建立一個實用的關聯式資料庫。
- 涵蓋了基礎和高級的資料庫程式設計技術，以使初學者和有經驗的程式設計師受益。
- 討論、分析並實現了一種高級的資料庫查詢技術，LINQ API，其中包括LINQ to Objects、LINQ to DataSet、LINQ to SQL、LINQ to Entities和LINQ to XML，並提供了逐行解釋的實際專案。
- 每章提供作業和課堂專案，以加強和提高學生學習和理解所學主題的能力。
- 提供PowerPoint教學投影片和選定的作業解答，幫助教師輕鬆有效地教學和組織課堂。

這本教科書實用而實際，是開發和建立專業和實用資料庫應用程式的直觀指南。

Dr. Ying Bai is a Professor in the Department of Computer Science and Engineering at Johnson C. Smith University. His special interests include Artificial intelligences, soft-computing, mix-language programming, fuzzy logic and deep learning, robotic controls, robots calibrations, and database programming. His industry experience includes positions as software and senior software engineers at companies such as Motorola MMS, Schlumberger ATE Technology, Immix TeleCom, and Lam Research. Since 2003, Dr. Bai has published 18 books with publishers such as Prentice Hall, CRC Press LLC, Springer, Cambridge University Press and Wiley IEEE Press. The Russian translation of his first book titled Applications Interface Programming Using Multiple Languages was published by Prentice Hall in 2005. The Chinese translation of his 8th book titled Practical Database Programming with Visual C#.NET was published by Tsinghua University Press in China in 2011. Most of his books are about artificial intelligence and soft-computing, software interfacing and serial port programming, database programming, fuzzy logic controls, microcontroller programming as well as classical and modern control technologies. During recent years, Dr. Bai has also published more than 65 academic research papers in IEEE Trans. Journals and International conferences.

Dr. Ying Bai是Johnson C. Smith University計算機科學與工程系的教授。他的特殊興趣包括人工智能、軟計算、混合語言編程、模糊邏輯和深度學習、機器人控制、機器人校準和數據庫編程。他在業界的經驗包括在Motorola MMS、Schlumberger ATE Technology、Immix TeleCom和Lam Research等公司擔任軟件和高級軟件工程師的職位。自2003年以來，Dr. Bai已經出版了18本書，出版商包括Prentice Hall、CRC Press LLC、Springer、Cambridge University Press和Wiley IEEE Press。他的第一本書《應用界面編程使用多種語言》的俄文翻譯版於2005年由Prentice Hall出版。他的第八本書《使用Visual C#.NET進行實用數據庫編程》的中文翻譯版於2011年由清華大學出版社在中國出版。他的大部分書籍都是關於人工智能和軟計算、軟件界面和串口編程、數據庫編程、模糊邏輯控制、微控制器編程以及經典和現代控制技術。近年來，Dr. Bai還在IEEE Trans. Journals和國際會議上發表了65多篇學術研究論文。