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