Building a Simple Blog Engine with ASP.NET MVC and LINQ

Print Add To Favorites Email To Friend Rate This Article
Building a Simple Blog Engine with ASP.NET MVC and LINQ - Part 3

page 4 of 8

by Keyvan Nayyeri
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 14554/ 197

Article Contents:

LINQ to SQL

For KBlog I want to use a LINQ to SQL mechanism to load data to the data model and pass them to controller actions. Using LINQ to SQL is pretty easy and should be common knowledge for a normal .NET developer, but since it's a new technology just let me point that you can add a new LINQ to SQL Classes item to your Models folder in ASP.NET MVC project as shown in Figure 2.

Figure 2

After adding this item to your project you can drag and drop database tables to the designer and don't need to do anything else because this is all we need for this example.

Your LINQ to SQL designer should look like Figure 3 after that.

Figure 3

« (Page 3)

View Entire Article

(Page 5) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 8 and 8 and type the answer here:

User Comments

Title: Busby SEO Test
Name: info@gmail.com
Date: 12/22/2008 12:07:27 AM
Comment:
thank you very much

Title: Question
Name: Michael
Date: 12/6/2008 6:31:47 AM
Comment:
Hi, how about if our sample url is '/2008/12/06/post-title-here' just like what Wordpress did, is it possible?

Title: Nevermind
Name: Nick Kirkes
Date: 4/26/2008 7:07:31 PM
Comment:
Just realized I am missing the DBDataContext.

Title: context.Posts?
Name: Nick Kirkes
Date: 4/26/2008 7:06:44 PM
Comment:
Thanks for the article.

I'm following your guidance, but I can't build as the "context.Posts" don't exist (same for categories). Am I missing something?

Title: anxiously awaiting...
Name: Emiel
Date: 4/24/2008 3:06:02 AM
Comment:
Here's another one waiting for part 4...
When, when, WHEN?

Title: And the part 4?
Name: lxx
Date: 4/17/2008 11:42:43 AM
Comment:
I wait for your next artical.Thanks.

Title: Reply to Mike
Name: Keyvan Nayyeri
Date: 3/28/2008 8:53:51 AM
Comment:
Mike,

I'll send it to editorial team in the next three days so I expect it to be published in the next couple of weeks.

Title: Expectation?
Name: Mike Mayers
Date: 3/28/2008 8:45:08 AM
Comment:
Is there any prevision about the release of the 4th part? Can't wait to see it. Very nice.

Title: Very good!!!!!
Name: Marcelo
Date: 3/27/2008 4:35:06 PM
Comment:
Very good tutorial! Am waiting anxiously for the "View" part!!! Thank you.