Reputation
361
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 12
Impact
~6k people reached

  • 0 posts edited
  • 1 helpful flag
  • 46 votes cast
May
28
awarded  Popular Question
Oct
1
accepted Third Party web controls and tight coupling
Sep
30
revised Third Party web controls and tight coupling
added 2 characters in body
Sep
30
revised Third Party web controls and tight coupling
added 896 characters in body
Sep
30
asked Third Party web controls and tight coupling
Sep
24
awarded  Autobiographer
Sep
3
awarded  Notable Question
Dec
7
comment How exactly can I check for new rows in sql with ajax?
Google this: Websocket. ServerSent Events. SignalR
Jun
1
awarded  Yearling
Feb
19
awarded  Caucus
Jan
14
accepted Asking people to disable Java for security - what's next for developer?
Jan
13
comment Asking people to disable Java for security - what's next for developer?
The article says "Since this threat is Java-based, it will only affect systems that have Java installed. Most platforms do not come with Java, but if you have installed it and do not need or regularly use it, you might consider removing it from your system. While Java is convenient for legitimate developers, its conveniences also help malware developers spread their harmful practices to multiple platforms". I see this as a swipe at Java. Can we blame this on Oracle?
Jan
13
asked Asking people to disable Java for security - what's next for developer?
Aug
28
accepted What Pattern will solve this - fetching dependent record from database
Aug
28
comment What Pattern will solve this - fetching dependent record from database
I updated my question. There are 2 teams per match which are never the same for the whole 10 records. That is 2x10=20
Aug
28
comment What Pattern will solve this - fetching dependent record from database
Your approach looks promising. I could loop through the List<Match>, get the 20 TeamIDs and query the database once for just 20 records using WHERE IN (......). Storing 20 records in memory won't be much. Thanks.
Aug
28
revised What Pattern will solve this - fetching dependent record from database
added 87 characters in body
Aug
28
comment What Pattern will solve this - fetching dependent record from database
Thanks for your answer. I have updated my question. Paging is not the problem, updating the TeamName for each team in the Match collection is the issue. I used to fetch all records from database but it isn't easy to use a class with fixed attributes as they will change every time I join another table to accommodate more values from DB. Am using Asp.Net MVC, I only want to decorate my view model with the TeamName and let the TeamID be in the Entity class
Aug
28
comment What Pattern will solve this - fetching dependent record from database
Thanks for your answer. I used to fetch all records from database but it isn't easy to use a class with fixed attributes as they will change every time I join another table to accommodate more values from DB. Am using Asp.Net MVC, I only want to decorate my view model with the TeamName and let the TeamID be in the Entity class
Aug
28
revised What Pattern will solve this - fetching dependent record from database
added 172 characters in body