Creating LINQ to SQL Data Models' Data Contexts with ASP.NET MVC

Question

I'm just getting started with ASP.NET MVC, mostly by reading ScottGu's tutorial. To create my database connections, I followed the steps he outlined, which were to create a LINQ-to-SQL dbml model, add in the database tables through the Server Explorer, and finally to create a DataContext class.

That last part is the part I'm stuck on. In this class, I'm trying to create methods that work around the exposed data. Following the example in the tutorial, I created this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MySite.Models
{
    public partial class MyDataContext
    {
        public List<Post> GetPosts()
        {
            return Posts.ToList();
        }
        public Post GetPostById(int id)
        {
            return Posts.Single(p => p.ID == id);
        }

    }
}

As you can see, I'm trying to use my Post data table. However, it doesn't recognize the "Posts" part of my code. What am I doing wrong? I have a feeling that my problem is related to my not adding the data tables correctly, but I'm not sure.

Thanks in advance.

Can you post the exact error message?

Andomar
– Andomar

2010-04-02 19:14:40 +00:00
Commented Apr 2, 2010 at 19:14 — Andomar
– Andomar, Commented Apr 2, 2010 at 19:14

tvanfosson · Accepted Answer · 2010-04-02 19:13:17Z

3

What's the name of your actual data context? Do you have a My.dbml file? Or is it named something different? The partial class definition has to exactly match the partial class definition given by the designer. Also, the partial class must be in the same project as the designer-generated class.

answered Apr 2, 2010 at 19:13

tvanfosson

534k102 gold badges703 silver badges801 bronze badges

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

1 Comment

Maxim Zaslavsky Over a year ago

Ah yes, just found the problem and fixed it: I had originally named the .dmbl something else, and then renamed the file (not the properties). I created a partial DataContext class with the new name, but the name hadn't been changed in the .dbml's Properties, so it was failing. Thanks!

SDReyes · Accepted Answer · 2010-04-02 19:15:58Z

1

Check the class name and namespace of your DataContext:

Is it MySite.Models.MyDataContext?

answered Apr 2, 2010 at 19:15

SDReyes

9,96416 gold badges58 silver badges93 bronze badges

Collectives™ on Stack Overflow

Creating LINQ to SQL Data Models' Data Contexts with ASP.NET MVC

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related