ansaurus

Question

LINQ VB.net Return Single Type of Object Invalid Cast

Answer 1

A:

This would seem to get what you are looking for. Not sure why you are passing in a function for a simple query like this.

Public Function GetJacketByPolicyID(ByVal jacketID As Int32) As tblPolicy
 Dim _jacket as tblPolicy
 Using _db As New DEVDataContext()
  _jacket = (From _j In db.tblPolicies Where _j.policyNumber.Equals(jacketID) Select _j).Single()
 End Using
 Return _jacket
End Function

StingyJack 2010-06-29 17:22:43

Hi Stingyjack....thanks for the reply. The function is just merely an exercise in trying to figure out what to class and what not to, but I do understand and appreciate the point.I'm still getting that Specified Cast is Not Valid error however. I'm really puzzled and looked all through my data context definitions to see if something is strange there. Is there a way to simply check if the single query works without having to cast it as a tblPolicy? In other words can I perform a LINQ query and throw it into just any ol object like Response.Write(newpolobject(0).ToString() or something?

Indy-Jones 2010-06-29 18:13:41

Well... I am trying to say there is no need to pass in a function [Function(p)] for this simple statement. GetJacketByPolicyID returns a tblPolicy, just as the linq query does. I still dont get why you are trying to cast it to something different. Also its worth notingthat the VB syntax for linq is a bit different than C# and VB doesn't support (at least without heinous workarounds) some of it completely (like functions) yet.

StingyJack 2010-06-29 20:07:22

Thanks so much StingyJack, yeah I don't like VB.net much and prefer C# any day of the week, but my client is new to .net and wanted to have a base language that they were familiar with, hence the vb.net...lol. Anyway, I did get this to work. I had to delete and let .net rebuild the DataContexts and it worked like a charm. Thanks again.

Indy-Jones 2010-07-01 12:59:36

ansaurus

tags:

views:

answers:

LINQ VB.net Return Single Type of Object Invalid Cast

related questions