Click here to Skip to main content
13,770,697 members
Rate this:
Please Sign up or sign in to vote.
See more:
How to check duplicate records in the database before inserting using linq in

for example I have a table of general_categories, consists of cat_id and categories

when i click save to there will pop up message says that their is duplicate

records found when the file you want to save is existing..........
Posted 7-Jun-12 23:10pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

I think this is very basic engineering solution that your are trying .

Read this all link as I found this to be very helpful to understand basic functionality of LinQ .[^]

Apart from this I would like to give solution for your issue not in the form of code but in the form of algorithm.
1) Connect the database
2) Use that connection to run LinQ Query
3) Declare one variable which will store YES/NO for result
4) Write SELECT query to find out the data in table If exists query will return YES otherwise NO
5) Make use of this condition to process further request.

Hope this helps , If yes then plz accept and vote the answer. Any queries / questions on this are always welcome.

Thanks & Regards
RDBurmon.Sr.Software Engineer

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Cookies | Terms of Service
Web05-2016 | 2.8.181119.1 | Last Updated 18 Dec 2015
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100