ASP.NET MVC+LINQ開發一個圖書銷售網站(6):建立資料層

1. 我們在Model下存放我們系統需要的資料，首先我們建立一個資料庫的Linq to Sql Class

2.選中所有的表到設計檢視

3. 建立一個BookShopDBDataContext的分布類，我們在這裡寫一些方法和邏輯層Controller互動.

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Xml.Linq;
using System.Collections.Generic;

namespace BookShop.Models
{
    public partial class BookShopDBDataContext
    {
        //return all categories       
        public List<Category> GetAllCategory()
        {
            return Categories.ToList();
        }

        //Add Category
        public void AddCategory(Category c)
        {
            
            this.Categories.InsertOnSubmit(c);
            this.SubmitChanges();
        }

        //Edit Category
        public void EditCategory(Category c)
        {
            
            this.UpdateCategory(c);
            this.SubmitChanges();
        }

        public Category GetCategory(int id)
        {
            return Categories.Single(c => c.CategoryId == id);
        }

        //delete category
        public bool DelCategory(int id)
        { 

            //check if has used
            if (Books.Any(b => b.BookCategoryId == id))
            {
                return false;
            }
            else
            {
                Category delCategory = this.Categories.Single(c => c.CategoryId == id);
                this.Categories.DeleteOnSubmit(delCategory);
                this.SubmitChanges();
                return true;
            }
        }
    }
}