Click here to Skip to main content
14,541,260 members
   

C#

 
AnswerRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 9:16
MemberExoskeletor9-Mar-20 9:16 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Eddy Vluggen9-Mar-20 9:53
professionalEddy Vluggen9-Mar-20 9:53 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Eddy Vluggen9-Mar-20 8:58
professionalEddy Vluggen9-Mar-20 8:58 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Eddy Vluggen9-Mar-20 4:14
professionalEddy Vluggen9-Mar-20 4:14 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 9:09
MemberExoskeletor9-Mar-20 9:09 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Eddy Vluggen9-Mar-20 9:15
professionalEddy Vluggen9-Mar-20 9:15 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 9:31
MemberExoskeletor9-Mar-20 9:31 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Eddy Vluggen9-Mar-20 9:49
professionalEddy Vluggen9-Mar-20 9:49 
I usually perform a select (on the pk) to verify if it exists, and if it doesn't, execute an insert; whether that's the "best" idea is debatable. I'm trying to stay away from parts of SQL that aren't part of the SQL92 spec, making it easier to move queries between different types of databases. Another little benefit is that I can use most databases to test any queries, since most support the SQL92 standard.

If your code is designed specifically for SQLite, then it makes little sense to limit yourself and not use the options that the database gives you. There's an "upsert" command for example (SQLite Query Language: upsert[^]), combining insert and update (in a somwhat similar way to "insert or replace").
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 14:18
MemberExoskeletor9-Mar-20 14:18 
PraiseRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Eddy Vluggen10-Mar-20 1:44
professionalEddy Vluggen10-Mar-20 1:44 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Eddy Vluggen9-Mar-20 2:23
professionalEddy Vluggen9-Mar-20 2:23 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 0:26
MemberExoskeletor9-Mar-20 0:26 
QuestionHow do I make table data red in <td>? Pin
Member 114033044-Mar-20 8:33
MemberMember 114033044-Mar-20 8:33 
AnswerRe: How do I make table data red in <td>? Pin
Richard Deeming4-Mar-20 8:50
mveRichard Deeming4-Mar-20 8:50 
GeneralRe: How do I make table data red in <td>? Pin
Member 114033044-Mar-20 8:59
MemberMember 114033044-Mar-20 8:59 
GeneralRe: How do I make table data red in <td>? Pin
Richard Deeming4-Mar-20 23:58
mveRichard Deeming4-Mar-20 23:58 
GeneralRe: How do I make table data red in <td>? Pin
Member 114033049-Mar-20 4:36
MemberMember 114033049-Mar-20 4:36 
GeneralRe: How do I make table data red in <td>? Pin
Richard Deeming9-Mar-20 8:36
mveRichard Deeming9-Mar-20 8:36 
GeneralRe: How do I make table data red in <td>? Pin
Member 114033049-Mar-20 9:41
MemberMember 114033049-Mar-20 9:41 
GeneralRe: How do I make table data red in <td>? Pin
Richard Deeming9-Mar-20 9:53
mveRichard Deeming9-Mar-20 9:53 
GeneralRe: How do I make table data red in <td>? Pin
Member 114033049-Mar-20 11:45
MemberMember 114033049-Mar-20 11:45 
GeneralRe: How do I make table data red in <td>? Pin
Richard Deeming10-Mar-20 0:14
mveRichard Deeming10-Mar-20 0:14 
GeneralRe: How do I make table data red in <td>? Pin
Member 1140330412-Mar-20 4:08
MemberMember 1140330412-Mar-20 4:08 
QuestionHow to capture credentials / auth token from Windows credential popup dialog? Pin
S p k 5214-Mar-20 0:27
MemberS p k 5214-Mar-20 0:27 
AnswerRe: How to capture credentials / auth token from Windows credential popup dialog? Pin
Richard MacCutchan4-Mar-20 0:37
mveRichard MacCutchan4-Mar-20 0:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.