code_junkie

Search in LINQ to SQL

Nov 14th, 2011
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. Function GetTypeFromTableName(ByVal _TableName As String, ByVal _DataContext As DataContext)
  2.  
  3. Dim Mytype As Type = (From t In _DataContext.Mapping.GetTables Where t.TableName = "dbo." + _TableName Select t.RowType.Type).SingleOrDefault
  4. Return Mytype
  5.  
  6. End Function
  7.  
  8. Dim DBA As New LINQDataContext
  9. _TBLName="City"
  10. TableType = GetTypeFromTableName(_TBLName, DBA)
  11.  
  12. Dim GridQuery = From T In DBA.GetTable(TableType) Select T
  13.  
  14. If Chk.Checked Then
  15. CallByName(obj, "CName", CallType.Set, Txt_Name.Text)
  16. GridQuery = From T In DBA.GetTable(TableType) Where T Like obj
  17. End If
Add Comment
Please, Sign In to add comment