using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

​

namespace part1

{

    public class Author

    {

        public string Name

        {

            get;

            set;

        }

​

        public string Book

        {

            get;

            set;

        }

​

        public string Publisher

        {

            get;

            set;

        }

​

        public Int16 Year

        {

            get;

            set;

        }

​

        public double Price

        {

            get;

            set;

        }

    }

​

    public class Program

    {

        static void Main(string[] args)

        {

            List<Author> authorsList = new List<Author>

            {

            new Author()

            {

            Name = "Shaliza", Book = ".net Programming", Publisher = "xyz", Year = 2016, Price = 44.99

            }

​

            , new Author()

            {

            Name = "Shiraz", Book = "HTML", Publisher = "WXY", Year = 2010, Price = 49.95

            }

​

            , new Author()

            {

            Name = "XYZ", Book = "CSS", Publisher = "Microsoft ", Year = 2012, Price = 44.95

            }

            }

​

            ;

            var authorQuery =

                from author in authorsList

                where author.Price == 44.95

                select new

                {

                author.Name, author.Publisher

                }

​

            ; //\\\\\\\\\\\sql like statement

            //var authorquery1 =  authorsList.Find(X => X.Price == 44.95);

            foreach (var author in authorQuery)

            {

                Console.WriteLine("Name={0}, Publisher={1}", author.Name, author.Publisher);

            }

        }

    }

}