Explicit Data Typing

[KodeKrazy]

When I try to use LINQ to SQL, I get the following error:

"Data type(s) of the type parameter(s) in method 'Public Sub InsertAllOnSubmit(Of TSubEntity As TEntity)(entities As System.Collections.Generic.IEnumerable(Of TSubEntity))' cannot be inferred from these arguments. Specifying the data type(s) explicitly might correct this error."

Where do I need to specify the data types explicitly? In my

DB.Items.InsertAllOnSubmit(newCatItem)

statement, or where I declare the variables? (Already typed everything to match my SQL DB in the variable declarations, so if that's correct, I did something wrong)

KK

[daniel aristidou]

Ok i think the isue is the newcatitem
Can u post the code that sets this variable?

[KodeKrazy]

Option Infer On
Option Strict On
 
Imports System.Collections.Generic
Imports System.Data
Imports System.Data.Linq
Imports System.Data.Linq.Mapping
Imports System.Data.Linq.SqlClient
Imports System.IO
Imports System.Linq
Imports System.Linq.Expressions
Imports System.Reflection
 
Public Class clsLINQ_Procs
  Private DB As CatDataClassesDataContext
  Public pag As String    ' Page
 
  Public Function AddCat() As Boolean
 
     pag = CType(frmMain.dgvItems.Rows(i).Cells.Item(38).Value.ToString, String)
 
     Dim newCatItem = New Item With {.Page = CType(pag, String)}
 
     DB.Items.InsertAllOnSubmit(newCatItem)
     DB.SubmitChanges() 
 
     Return AddCat=True
 
  End Function
End Class
 
 

There are quite a few other variables but in the interest of simplicity all the other variables are typed and declared in the same manner.

TIA,

KK

[KodeKrazy]

Option Infer On
Option Strict On
 
Imports System.Collections.Generic
Imports System.Data
Imports System.Data.Linq
Imports System.Data.Linq.Mapping
Imports System.Data.Linq.SqlClient
Imports System.IO
Imports System.Linq
Imports System.Linq.Expressions
Imports System.Reflection
 
Public Class clsLINQ_Procs
  Private DB As CatDataClassesDataContext
  Public pag As String    ' Page
 
  Public Function AddCat() As Boolean
 
     pag = CType(frmMain.dgvItems.Rows(i).Cells.Item(38).Value.ToString, String)
 
     Dim newCatItem = New Item With {.Page = CType(pag, String)}
 
     DB.Items.InsertAllOnSubmit(newCatItem)
     DB.SubmitChanges() 
 
     Return AddCat=True
 
  End Function
End Class
 
 

There are quite a few other variables but in the interest of simplicity all the other variables are typed and declared in the same manner.

TIA,

KK

Not sure why it is putting all the space in the word "Value" but it's not there in my code. Just an FYI... kk

[KodeKrazy]

Still getting the error, still don't know why...