Click here to Skip to main content
15,919,479 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Listbox maximum? Pin
MallardsReach3-Feb-18 4:57
MallardsReach3-Feb-18 4:57 
GeneralMake setup file Pin
Member 1362262729-Jan-18 10:13
Member 1362262729-Jan-18 10:13 
GeneralRe: Make setup file Pin
Eddy Vluggen30-Jan-18 0:52
professionalEddy Vluggen30-Jan-18 0:52 
GeneralRe: Make setup file Pin
Member 1362262730-Jan-18 11:56
Member 1362262730-Jan-18 11:56 
GeneralRe: Make setup file Pin
Eddy Vluggen31-Jan-18 1:26
professionalEddy Vluggen31-Jan-18 1:26 
GeneralRe: Make setup file Pin
Member 1362262731-Jan-18 1:37
Member 1362262731-Jan-18 1:37 
GeneralRe: Make setup file Pin
Eddy Vluggen31-Jan-18 1:48
professionalEddy Vluggen31-Jan-18 1:48 
GeneralRe: Make setup file Pin
Member 1362262731-Jan-18 2:05
Member 1362262731-Jan-18 2:05 
GeneralRe: Make setup file Pin
Eddy Vluggen31-Jan-18 2:37
professionalEddy Vluggen31-Jan-18 2:37 
GeneralRe: Make setup file Pin
Member 136226274-Feb-18 20:59
Member 136226274-Feb-18 20:59 
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 

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.