Hello,
I am new to Linq & DbLinq. I'm trying to update a single record in my
MySql database but I receive the following error:
System.InvalidCastException: Unable to cast object of type
'DbLinq.Data.Linq.Implementation.QueryProvider`1[cadetx.EventsDb]' to
type 'cadetx.EventsDb'. at AdminV2.btnUpdate_Click(Object sender,
EventArgs e) in C:\inetpub\wwwroot\Cadet-X V2\AdminV2.aspx.vb:line 241
Here is the code:
Dim conn As New
MySqlConnection(SQLConnection.ConnectionString)
Dim db As New cadetx.CxBeta(conn)
Dim cxevent As cadetx.EventsDb = From c In db.EventsDb
_
Where c.EventID = hidEID.Value
Select c
cxevent.Date = txtDate.Text
cxevent.Name = txtEvent.Text
cxevent.Location = txtLocation.Text
cxevent.Info = txtInfo.Text
cxevent.C1 = chkClasses.Items(0).Selected
cxevent.C2 = chkClasses.Items(1).Selected
cxevent.C3 = chkClasses.Items(2).Selected
cxevent.C4 = chkClasses.Items(3).Selected
cxevent.Time = txtHrs.Text & ":" & txtMin.Text
db.SubmitChanges()
I am using v 0.19 of DbLinq and my class (cadetx) was generated using
DbMetal.
Thanks for the help!
--
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en.
