Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: VB9.0 VB10.0
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
0 OriginalGriff 685
1 Maciej Los 290
2 Richard Deeming 185
3 Suvendu Shekhar Giri 184
4 Abhinav S 166
0 Sergey Alexandrovich Kryukov 9,678
1 OriginalGriff 9,135
2 Peter Leow 5,082
3 Kornfeld Eliyahu Peter 3,373
4 Maciej Los 2,606

Advertise | Privacy | Mobile
Web01 | 2.8.150327.1 | Last Updated 8 Jun 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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