Comments by Greysontyrus (Top 17 by date)

Thanks BobJanova, It appears that you have identified the problem but you have not offered any solution so I wonder why you have posted it as such. I feel that this would make a good comment, one that I would even edit into by question, but I cannot accept it as a solution. As the post now appears to have a solution to the casual 'Authority' poster the number of views has remained nearly constant ever since. Is there a way that you can re-organise this post as a comment instead?
Thanks ^_^

I'd rate that as an answer, digimanus

Please use the reply button on the comment. That way the conversation is easy to track and I get a note letting me know that you've replied ^_^
To update a record you have to change the record you got back from the data context, not a new instance. I think what you need is:
foreach(industries ind in indList){
ind.workfor_id = Convert.ToInt16(k.id);
ind.workfor_industry_id = Convert.ToInt16(k.industryid);
}
dbContext.SubmitChanges();

or am I getting the wrong end of the stick?

It looks like you're taking a csv list in 'industryParts' and are creating new 'industries' instances for each item in the csv. First, without anything else within that 'for' loop, you are losing every instance of 'ind' apart from the last. Second, each instance 'ind' is identical.
Q: where are you expecting this update to take place? Is this the whole code?

Thank you very much ^_^
I'll have to wait for another lock to try these out.

There is now. Just had another incident with a different query but still included Event_log and Package. I've killed the process but kept a copy of the two tables you spoke of. What am I looking for here?

The problem there is that if the query is regarding a large volume of data then that data has to be transported raw from the database to the web server and back again. MicroSoft have decided that developers don't know what they are doing so they have restricted us from writing elegant insert queries in Linq in 4.0. Thanks MicroSoft for changing my nappy >_<

A sound suggestion but the fact that SQL has no idea that anything is wrong means that the issue will not stand out. This wouldn't be much of an issue if not for the volume of traffic. The database in question receives around 5000 or more transaction per minute which does not abate overnight.

The most puzzling thing is that the db is set up for row locks, not page locks. I have had to avoid any page locks due to the volume of traffic.

Thanks for the response ^_^

Could we have a few rows (or the whole) of the input file please.
Whenever I see items[#] where # is hard coded I always shudder. The message says that there is a line that has less than 4 elements in a 'item'
You can confirm this by testing the file with your code but replacing the t1 linq to:
var t1 = lines
.Where(l => !l.StartsWith("#"))
.Where(l => l.Split(' ').Length < 4);
.Select(l => "'" + l.Replace(" ", "' '") + "'");
the Console.WriteLine(t); with then print any rows that causes an error in quotes so you can see each line and item as the lamba see it. You may find that a row is missing some ' 's so the .Split(' ') is failing to find 4 seperate elements

The error message and question have changed

Thx Andrei ^_^