problem with LINQ

Hi Friends, Here I am to share some experience on latest technology from project currently completed by me. The project was in Asp.net 3.5, C#, SQL 2005 and LINQ. I found LINQ as good for faster executions of INSERT, DELETE or UPDATE queries. But still there are few things which I couldn’t found to work with LINQ. For example, if I want a sql query explained in example below, to be written in LINQ, I am not getting desired output results. Example: 1. Web Form have three textboxes ( for Employee textBoxFirstName, textBoxLastName and textBoxEmailId ) and one button (buttonRetrieveData). 2. I want to select result data from sql table “Employee” with sql query like, “SELECT * FROM Employee WHERE FirstName like ‘%” + textBoxFirstName.Text + ”’ && LastName like ‘%” + textBoxLastName.Text + ”’ && EmailId like ‘%” + textBoxEmailId.Text + ”’” 3. I am not able to perform such query in LINQ to get same result as this select query will give. If anyone from you know the solution, please let me know. Thanks & Regards, Shekhar
Ebook Download
View all
Learn
View all