Hello, I have an array with over 300 fields to be inserted into SQL. Trying to use LINQ to SQL, but the problem is I can not find a way to loop through Linq object which was created by dragging table. Basically For Each rowField In allRows If rowField.Length > 1 Then allfields = rowField.Split(vbTab) 'fields 'process-insert into SQL Dim newRecord As New Elements newRecord.id= allfields(0) newRecord.name = allfields(1) newRecord.city = allfields(2) ........ here goes 300 more rows which I really don't
Read More...