Adding data to database using asp.net mvc

Question

I'm trying to add data to the Event table in SQL Server. This is the table details:

CREATE TABLE [dbo].[Event]
(
    [EventID] [int] IDENTITY(1001,1) NOT NULL,
    [EventName] [nvarchar](50) NOT NULL,
    [EventDesc] [nvarchar](50) NOT NULL,
    [EventLogo] [image] NULL,
    [EventLocation] [decimal](9, 6) NULL,
    [EventDate] [nvarchar](20) NOT NULL,
    [EventStartTime] [nvarchar](7) NOT NULL,
    [EventEndTime] [nvarchar](7) NOT NULL,
    [NumOfAttendees] [nvarchar](7) NULL,
    [EventStatus] [nvarchar](5) NOT NULL,
    [UserID] [int] NULL,
    [CategoryID] [int] NULL,
    [RatingID] [int] NULL,
    [FeedbackID] [int] NULL
)

This is where I receive the error:

Keyword, identifier or string expected after verbatim specifier @

This is the EventController code:

public ActionResult Index()
{
    var events = db.Events.Include(@ => @.Category).Include(@ => @.Feedback).Include(@ => @.Rating).Include(@ => @.User);
    return View(events.ToList());
}

Keyword, identifier or string expected after verbatim specifier @ in the index action — JohnWayne
– JohnWayne, Commented Aug 18, 2015 at 9:54

CoOl · Accepted Answer · 2015-08-18 10:01:18Z

1

Change it to -

db.Events.Include(c => c.Category).Include(f => f.Feedback).Include(r => r.Rating).Include(u => u.User);

@ is a keyword which is used for verbatim literals.

answered Aug 18, 2015 at 10:01

CoOl

2,83724 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ekad Over a year ago

@JohnaneUmslana if this answer solves your issue, then consider accepting this answer so other people will know that your issue is resolved.

JohnWayne Over a year ago

Thanks for the heads up ekad

Collectives™ on Stack Overflow

Adding data to database using asp.net mvc

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related