Databases with linq
Download
1 / 8

Databases with LINQ - PowerPoint PPT Presentation


  • 151 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Databases with LINQ' - manchu


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Linq to sql
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.


Displaytablebooks example
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.


Displaytablebooks example1
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.


Displayqueryresult example
DisplayQueryResult example

  • More Complex LINQ Queries and Data Binding


Joiningwithlinq example
JoiningWithLINQ example

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


Masterdetailexample
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.


Addressbook example
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.