Practical Database Programming With Visual C#.NET

Practical Database Programming With Visual C#.NET

Ying Bai

Language: English

Pages: 936

ISBN: 0470467274

Format: PDF / Kindle (mobi) / ePub

A novel approach to developing and applying databases with Visual C#.NET

Practical Database Programming with Visual C#.NET clearly explains the considerations and applications in database programming with Visual C#.NET 2008 and in developing relational databases such as Microsoft Access, SQL Server, and Oracle Database. Sidestepping the traditional approach of using large blocks of code, Ying Bai utilizes both Design Tools and Wizards provided by Visual Studio.NET and real-time object methods to incorporate over sixty real sample database programming projects along with detailed illustrations and explanations to help readers understand the key techniques and programming technologies in database programming. This invaluable resource features:

  • Fundamental and advanced database programming techniques for beginning and experienced students as well as programmers

  • A real completed sample database CSE_DEPT with three versions (Microsoft Access 2007, SQL Server 2005 SP2, and Oracle Database 10g XE Release 2) used throughout the entire book

  • Step-by-step details on designing and building a practical relational database

  • Discussion and analysis of the new database query technique, LINQ API—which includes LINQ to Objects, LINQ to DataSet, LINQ to SQL, LINQ to Entities, and LINQ to XML—and implementation in actual projects with line-by-line explanation

  • Homework and selected solutions for each chapter to strengthen and improve learning and understanding

  • An Instructor's Manual (MS PPT), example codes and exercise questions, homework/exercise solutions, and database projects available for free download

  • E-mail assistance from the author

Readers who will benefit highly from this reference are undergraduate or graduate students majoring in computer science and engineering, graduate students in all engineering departments, and software engineers and researchers in academic and industrial fields.

To obtain instructor materials please send an email to

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Arista Warrior

A Discipline of Multiprogramming: Programming Theory for Distributed Applications (Monographs in Computer Science)

Credibilistic Programming: An Introduction to Models and Applications (Uncertainty and Operations Research)

Computer Vision: Models, Learning, and Inference













data objects method and some sophisticated database programming techniques such as LINQ queries, joined-table query, nested stored procedures, and Oracle Package are discussed and illustrated with real examples. Also the ASP.NET Web applications and ASP.NET Web services are discussed and analyzed with 24 real database program examples for SQL Server 2005 and Oracle Database 10 g XE. HOW TO USE THE SOURCE CODE AND SAMPLE DATABASES All source codes for each actual project developed in this book

Provides detailed descriptions about download and installation of Oracle Database 10 g Express Edition (XE) Release 2. • Appendix D: Provides detailed discussions on how to create user database in Oracle Database 10 g XE and how to duplicate Oracle 10 g user database using Unload and Load methods. • Appendix E: Provides detailed discussions on how to add and connect Oracle 10 g XE database into Visual C#.NET applications using the Visual Studio.NET design tools and wizards. • Appendix F: Provides

folder under the dbo.StudentCourse table from the Object Explorer window and select the New Foreign Key item from the pop-up menu. On the opened Foreign Key Relationships dialog, change the name of this new relationship to FK_StudentCourse_Student in the (Name) box and press the Enter key on the keyboard. 2.10 Create Microsoft SQL Server 2005 Sample Database Figure 2.37 The finished Tables and Columns dialog. Figure 2.38 Finished Tables and Columns dialog. 61 In the opened Tables and

(pass_word LIKE @Param2)"; SqlParameter paramUserName = new SqlParameter(); SqlParameter paramPassWord = new SqlParameter(); SqlCommand sqlCommand As New SqlCommand(); paramUserName.ParameterName = "@Param1"; paramUserName.Value = txtUserName.Text; paramPassWord.ParameterName = "@Param2"; paramPassWord.Value = txtPassWord.Text; sqlCommand.Connection = sqlConnection; sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = cmdString; sqlCommand.Parameters.Add(paramUserName);

window and errors are reported in the Error List. Figure 3.20 shows an example of the ADO.NET 3.5 EDM Designer. Two important functionalities of using the EDM Designer are: Opening the ADO.NET Entity Data Model Designer The ADO.NET 3.5 EDM Designer is designed to work with an .edmx file. The .edmx file is an encapsulation of three EDM metadata artifact files, the CSDL, the SSDL, and the MSL files. When you run the EDM Wizard, an .edmx file is created and added to your solution. You open the ADO.NET

Download sample