Click here to Skip to main content
15,936,395 members
Home / Discussions / C#
   

C#

 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 4:28
Exoskeletor9-Mar-20 4:28 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Eddy Vluggen9-Mar-20 4:44
professionalEddy Vluggen9-Mar-20 4:44 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 4:47
Exoskeletor9-Mar-20 4:47 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Eddy Vluggen9-Mar-20 4:51
professionalEddy Vluggen9-Mar-20 4:51 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 5:00
Exoskeletor9-Mar-20 5:00 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 5:28
Exoskeletor9-Mar-20 5:28 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Eddy Vluggen9-Mar-20 9:00
professionalEddy Vluggen9-Mar-20 9:00 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 9:03
Exoskeletor9-Mar-20 9:03 
QuestionRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Eddy Vluggen9-Mar-20 9:13
professionalEddy Vluggen9-Mar-20 9:13 
AnswerRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 9:16
Exoskeletor9-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 
The page that I linked to lets you try the SQL statements online Smile | :)

Hadn't seen that it is a real "replace", not an insert "or" update; but it explains that too. It does look like it honors the unique constraint, so should work with a primary key too.

Exoskeletor wrote:
so if i have a template with id 5, and i delete it one day, the template that belong to id 6 wll go to the position of id 5? and so on?
Id's that have been used already do not get re-used; so if you delete 5 and 6 exists, another insert would give you 7, not 5, even if that position is empty.
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
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
Exoskeletor9-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
Exoskeletor9-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 
GeneralRe: Converting List<int> to List<object> for One to Many relation with sqlite-net-extensions Pin
Exoskeletor9-Mar-20 14:18
Exoskeletor9-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
Exoskeletor9-Mar-20 0:26 
QuestionHow do I make table data red in <td>? Pin
Member 114033044-Mar-20 8:33
Member 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
Member 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 

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.