Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Home » Tip Bank » .NET » C#
Language: .NET
Expertise: Intermediate
Jul 5, 2016

Using LINQ for Queries

LINQ is very good and efficient when it comes to handling data coming from a datasource. This little example creates a Table object. Then creates a DataContext to interpret the Table data, and finally does a query to extract the wanted data.
        [Table(Name = "Courses")]
        public class Courses //Create Courses Table
        {
            [Column(IsPrimaryKey = true, DbType = "BIGINT NOT NULL IDENTITY", IsDbGenerated = true)]
            public Int32 CourseID; //Field
            [Column]
            public string CourseDesc; //Field
        }
                using (DataContext dcCourses = new DataContext("CONNECTION_STRING)) //Connect to DB
                {
                    var data = (from c in _Courses
                                where c.CourseID == ComboBox1.SelectedIndex
                                select new { c.CourseDesc }
                    ).FirstOrDefault(); //Select CourseID That Corresponds to ComboBox Selection
                    TextBox1.Text = data.Name; //Display
                 }

Hannes du Preez
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date