1 / 8

Databases with LINQ

Databases with LINQ. LINQ to SQL. LINQ to SQL uses LINQ syntax to query databases. LINQ to SQL classes are automatically generated by the IDE’s LINQ to SQL Designer. The IDE creates a class for each table, with a property for each column in the table.

manchu
Download Presentation

Databases with LINQ

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Databases with LINQ

  2. LINQ to SQL • LINQ to SQL uses LINQ syntax to query databases. • LINQ to SQL classes are automatically generated by the IDE’s LINQ to SQL Designer. • The IDE creates a class for each table, with a property for each column in the table. • LINQ queries on an IQueryable object are processed together as a single SQL statement. • If each query operator were handled separately, multiple round trips to the database would be needed. • A DataContext class controls the flow of data between the program and the database. • When cached objects have been changed, these changes are saved using the DataContext’sSubmitChanges method.

  3. DisplayTableBooksexample • Select Tools > Connect to Database…. • If the Choose Data Source dialog appears, select Microsoft SQL Server Database File from the Data source:ListBox. • Click Continue to open the Add Connection dialog. • Click Browse… and choose Books.mdf. • Right click the project in the SolutionExplorer and select Add>NewItem… • Select LINQ to SQLclasses, name the new item Books.dbml and click the Add button. • The Database Explorer window allows you navigate the structure of databases. • Drag the Authors, Titles and AuthorISBN tables onto the Object Relational Designer and select Yes. • Select Data> Add New Data Source…to display the Data Source Configuration Wizard. • In the dialog, select Object and click Next >. • Expand the tree view and select DisplayTable > DisplayTable > Author. • Click Next > then Finish. The Authors table in the database is now a data source that can be used by the bindings.

  4. DisplayTableBooksexample • Open the Data Sources window by selecting Data > Show Data Sources. • Open the DisplayTableForm in Design view. • Click the Author node in the DataSources window—it should change to a drop-down list. Ensure that the DataGridView option is selected. • Drag the Author node from the DataSources window to the DisplayTableForm. • The IDE creates a DataGridView with the correct column names and a BindingNavigator. • The BindingNavigator contains Buttons for moving between entries, adding entries, deleting entries and saving changes to the database. • A BindingSource transfers data between the data source and the data-bound controls on the Form.

  5. DisplayQueryResult example • More Complex LINQ Queries and Data Binding

  6. JoiningWithLINQ example • LINQ to SQL to combine and organize data from multiple tables.

  7. MasterDetailexample • Demonstrates a master/detail view—one part of the interface allows you to select an entry, and another part displays detailed information about that entry.

  8. AddressBook example • The AddressBook application provides a GUI for querying the database with LINQ. • Create a new Windows Forms Application named AddressBook. • Add the AddressBook.mdf database and name the file AddressBook.dbml. • You must also add the Addresses table as a data source. • Click the Address node in the DataSources window. Click the down arrow to view the items in the list. • Select the Details option to indicate that the IDE should create a set of Label/TextBox pairs. • Drag the Address node from the DataSources window to the Form.

More Related