Click here to Skip to main content
Click here to Skip to main content

Linq: Relationship Code Sample

, 16 May 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
How to Implement Relationship in LINQ using C# and ASP.NET for Beginners

Introduction

This sample shows how to implement Relationship Using LINQ in C# and ASP.NET for a beginner.

How To Do

  1. Create an ASP.NET Web application using C# in Visual Studio 2008.

    File-> New -> Project -> ASP.NET Web Application

  2. Add a database file to app_data - "student.mdf".
    1. Right Click App_Data, Add->New Item->Data->SQL Server DataBase.
    2. Give name Student.mdf.

    3. Go to the Server Explore, Expand Student DataBase, In Tables, Add New Table
    4. Add two tables, Student and Mark.

      Table: StudentColumns: StudentID int, Name nvarchar(50), Age int

      Table: Mark
      Columns: StudentID int, Class nvarchar(50), Mark int

      Add some sample data for the Student and Mark tables, (student id should be same in Mark and Student table)

      For that, right click the table and click show table data, you can add data here.

  3. LINQ to SQL

    Right click the solution, add New Item->Data-> Linq to SQL Class.

  4. Give Name "LinqToStudents.dbml".

  5. Pick SQL Server explore, drag the two tables to the window:

    Save the Project.

  6. Drag a DataGrid view to the Default.aspx Page:

  7. Use the below code snippets pageload of the project:
    LinqToStudentsDataContext linqStud = new LinqToStudentsDataContext();
    var query = from s in linqStud.Students
    join h in linqStud.Marks on s.StudentID equals h.StudentID 
    select new {h.StudentID ,s.Name, };      
    GridView1.DataSource = query; 
    GridView1.DataBind(); 

Run the project by pressing F5.

History

  • Release 1

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

sabindas k s
Software Developer Banque Saudi Fransi
India India
No Biography provided
Follow on   Twitter

Comments and Discussions

 
GeneralMy vote of 2 PinmemberAfter205020-May-11 3:55 
GeneralRe: My vote of 2 Pinmemberak9937218-Sep-12 10:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.141223.1 | Last Updated 16 May 2011
Article Copyright 2011 by sabindas k s
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid