LINQ - Unable to cast object of type in Union - Asked By thangaselvi m on 24-May-11 07:54 AM

Unable to cast object of type 'System.Data.Linq.SqlClient.SqlNew' to type 'System.Data.Linq.SqlClient.SqlValue'.

when I run below query

Dim plnQuery = (From a In db.OBdatacontexts Select Payor_Name = "", obligorid = Convert.ToInt32(0)) _

.Union(From a In db.OBdatacontexts Order By a.Payor_Name Ascending Select a.Payor_Name, a.ObligorId)

Try using Select New to select multiple columns

(
	from o in Order
	select new { ID = o.ID, Order = o , Archive = (OrderArchive)null}
)
.Concat(
	from o in OrderArchive
	select new { ID = o.ID, Order = (null)Order, Archive = o}
).Take(200)

Thanks,
but I got below error
Unable to cast object of type 'System.Data.Linq.DataQuery`1[OBdatacontext]' to type 'System.Collections.Generic.IEnumerable`1[VB$AnonymousType_0`2[System.String,System.Int32]]'.

If there is no much more data in db.OBdatacontexts, please try: