Click here to Skip to main content
15,887,214 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Make setup file Pin
Eddy Vluggen5-Feb-18 1:17
professionalEddy Vluggen5-Feb-18 1:17 
GeneralRe: Make setup file Pin
Member 136226275-Feb-18 2:14
Member 136226275-Feb-18 2:14 
GeneralRe: Make setup file Pin
Eddy Vluggen5-Feb-18 2:26
professionalEddy Vluggen5-Feb-18 2:26 
GeneralRe: Make setup file Pin
Member 136226275-Feb-18 2:48
Member 136226275-Feb-18 2:48 
GeneralRe: Make setup file Pin
Eddy Vluggen5-Feb-18 2:52
professionalEddy Vluggen5-Feb-18 2:52 
GeneralRe: Make setup file Pin
Member 136226275-Feb-18 3:30
Member 136226275-Feb-18 3:30 
GeneralRe: Make setup file Pin
Eddy Vluggen5-Feb-18 5:08
professionalEddy Vluggen5-Feb-18 5:08 
QuestionStrange behaviour with Entirty Framework Query Pin
desanti29-Jan-18 9:35
desanti29-Jan-18 9:35 
I'm using entity framework with a visual studio 2013 application and SQL Server 2008R2. I have a table on the database :

id == name == quantity
1----- nm1---- 3
2------nm2---- 7

Now , I have this code

Dim query1 as ienumerable(of Table1)

query1=(From t in context.table1 where t.quantity>0 select t).Tolist
query1.First.quantity-=3
query1=(From t in context.table1 where t.quantity>0 select t).Tolist


Now, in the first line, query1 contains 2 objects nm1 and nm2 with quantity 3 and 7.
In the third line, query1 contains 2 objects nm1 and nm2 , but nm1 has quantity 0.
My question is :
-If the query on third line get the items from the database , the nm1 should have the quantity=3. Why this item has quantity 0?
-If the query on third line get the items from the local cache , should not contain nm1 at all because on the local cache nm1 has the quantity=0 and the query has the clause t.quantity>0.

Thank you!
AnswerRe: Strange behaviour with Entirty Framework Query Pin
Richard Deeming29-Jan-18 10:30
mveRichard Deeming29-Jan-18 10:30 
GeneralRe: Strange behaviour with Entirty Framework Query Pin
desanti29-Jan-18 13:41
desanti29-Jan-18 13:41 
GeneralRe: Strange behaviour with Entirty Framework Query Pin
Richard Deeming30-Jan-18 0:32
mveRichard Deeming30-Jan-18 0:32 
QuestionHow can I group multiple datatable columns, with sum/count colyms Pin
Member 1361559729-Jan-18 7:55
Member 1361559729-Jan-18 7:55 
AnswerRe: How can I group multiple datatable columns, with sum/count colyms Pin
Eddy Vluggen29-Jan-18 12:06
professionalEddy Vluggen29-Jan-18 12:06 
GeneralRe: How can I group multiple datatable columns, with sum/count colyms Pin
Member 1361559730-Jan-18 23:28
Member 1361559730-Jan-18 23:28 
GeneralRe: How can I group multiple datatable columns, with sum/count colyms Pin
Eddy Vluggen31-Jan-18 1:28
professionalEddy Vluggen31-Jan-18 1:28 
QuestionCSV to Datagridview Pin
mishphar26-Jan-18 8:28
mishphar26-Jan-18 8:28 
AnswerRe: CSV to Datagridview Pin
Gerry Schmitz27-Jan-18 12:28
mveGerry Schmitz27-Jan-18 12:28 
AnswerRe: CSV to Datagridview Pin
Richard MacCutchan27-Jan-18 20:56
mveRichard MacCutchan27-Jan-18 20:56 
QuestionCompiler does not see reference to control. Closed Pin
mo149226-Jan-18 5:45
mo149226-Jan-18 5:45 
QuestionAdding two numbers together? Pin
MallardsReach25-Jan-18 23:34
MallardsReach25-Jan-18 23:34 
AnswerRe: Adding two numbers together? Pin
Ralf Meier26-Jan-18 0:19
mveRalf Meier26-Jan-18 0:19 
SuggestionRe: Adding two numbers together? Pin
Richard Deeming26-Jan-18 2:40
mveRichard Deeming26-Jan-18 2:40 
GeneralRe: Adding two numbers together? Pin
Ralf Meier26-Jan-18 6:53
mveRalf Meier26-Jan-18 6:53 
GeneralRe: Adding two numbers together? Pin
MallardsReach26-Jan-18 5:57
MallardsReach26-Jan-18 5:57 
AnswerRe: Adding two numbers together? Pin
Dave Kreskowiak26-Jan-18 4:43
mveDave Kreskowiak26-Jan-18 4:43 

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.