How can update an entity using Linq-to-SQL?
I have the following class that can create/delete and list entities:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
namespace Backend.Models
{
    public class PaisRepository
    {
        private EnviosDataContext db = new EnviosDataContext();
        public IQueryable<Pai> FindAll()
        {
            return db.Pais;
        }
        public Pai Get(int id)
        {
            return db.Pais.FirstOrDefault(x => x.ID == id);
        }
        public void Add(Pai pai)
        {
            db.Pais.InsertOnSubmit(pai);
        }
        public void Delete(Pai pai)
        {
            开发者_StackOverflow中文版db.Pais.InsertOnSubmit(pai);
        }
        public void Save()
        {
            db.SubmitChanges();
        }
    }
}
How can I update a model?
From a separate class:
public void UpdatePai(int id, string field1, string field2, int field3)
{
    PaisRepository repository = new PaisRepository();
    Pai pai = repository.Get(id);
    pai.Field1 = field1;
    pai.Field2 = field2;
    pai.Field3 = field3;
    pai.Save();        
}
Try the following code
Pai p = PaisRepository.Get(1);
p.Someproperty = x;
PaisRepository.Save();
Try db.Pais.ApplyChanges(pai);
 
         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论