默认值的问题（C＃的变量）在LINQ to SQL更新(Default Values (of C#

我有一个与LINQ更新帐户表到SQL下面的代码。账户号码是主键列。这需要更新的唯一价值是ACCOUNTTYPE; 然而，持续时间也被以零（对于int默认值）更新。我们怎样才能避免这种不必要的覆盖？

注：我使用Attach方法

注：我理解这种现象的原因。 “在DataContext不能场之间具有零分配的值，并且一个是仅仅未分配区分。”。我要寻找一个解决方案来克服这一点。

[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Duration", DbType="Int NOT NULL"
public int Duration

表中的数据

表结构：

 CREATE TABLE [dbo].[Account](
[AccountNumber] [int] NOT NULL,
[AccountType] [nchar](10) NOT NULL,
[Duration] [int] NOT NULL,
[DepositedAmount] [int] NULL,
 CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED 
 (
[AccountNumber] ASC
 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 ) ON [PRIMARY]

码

    public void UpdateAccount()
    {
        RepositoryLayer.Account acc1 = new RepositoryLayer.Account();
        acc1.AccountNumber = 4;
        acc1.AccountType = "Verify";

        accountRepository.UpdateChangesByAttachAndRefresh(acc1);
        accountRepository.SubmitChanges();

    }


    public virtual void UpdateChangesByAttachAndRefresh(T entity)
    {

        //Can GetOriginalEntityState cause any bug? Is it unnecessary?           
        if (GetTable().GetOriginalEntityState(entity) == null)
        {
            //If it is not already attached

            Context.GetTable<T>().Attach(entity);
            Context.Refresh(System.Data.Linq.RefreshMode.KeepCurrentValues, entity);


        }

    }

生成的SQL

UPDATE [dbo].[Account]
SET [AccountType] = @p3, [Duration] = @p4
WHERE ([AccountNumber] = @p0) 
AND ([AccountType] = @p1) 
AND ([Duration] = @p2) 
AND ([DepositedAmount] IS NULL)

-- @p0: Input Int (Size = -1; Prec = 0; Scale = 0) [4]
-- @p1: Input NChar (Size = 10; Prec = 0; Scale = 0) [TEST      ]
-- @p2: Input Int (Size = -1; Prec = 0; Scale = 0) [10]
-- @p3: Input NChar (Size = 10; Prec = 0; Scale = 0) [Verify]
-- @p4: Input Int (Size = -1; Prec = 0; Scale = 0) [0]

-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 4.0.30319.1

读：

能否LINQ到SQL忽略上插入未指定的列，以便数据库使用默认值？
我如何绑定枚举，以位或为int的的DbType？
LINQ到SQL：为什么会出现IDENTITY_INSERT错误？
LINQ to SQL的：更新不刷新时“UpdateCheck的=从不”

Answer 1:

这应该这样做：

int number = 4;
var acc1 = new accountRepository.Accounts.Where(a => a.Number == number).FirstOrDefault();

if (acc1 == null)
{
    // Not found by ID, create new
    acc1 = new RepositoryLayer.Account();
    acc1.Number = number;
    accountRepository.Accounts.AddObject(acc1);
}

acc1.AccountType = "Verify";

accountRepository.SubmitChanges();

Answer 2:

我解决了这个问题，通过下面的回答修改更新方法的LINQ to SQL：更新没有刷新时“UpdateCheck的=从不”

UpdateCheck的设置为从不为持续时间列

    public void UpdateAccount()
    {
        //Used value from previous select
        DateTime previousDateTime = new DateTime(2012, 6, 26, 11, 14, 15, 327);
        int prevDuration = 0;

        RepositoryLayer.Account accEntity = new RepositoryLayer.Account();
        accEntity.AccountNumber = 1; //Primary Key
        accEntity.ModifiedTime = previousDateTime; //Concurrency column
        //accEntity.Duration = prevDuration;

        accountRepository.UpdateChangesByAttach(accEntity);

        //Values to be modified after Attach
        accEntity.AccountType = "WIN-WIN";
        accEntity.ModifiedTime = DateTime.Now;

        try
        {
            accountRepository.SubmitChanges();
        }
        catch(System.Data.Linq.ChangeConflictException e)
        {
            throw new Exception(e.Message);
        }

    }


   public virtual void UpdateChangesByAttach(T entity)
    {

        if (Context.GetTable<T>().GetOriginalEntityState(entity) == null)
        {
            //If it is not already attached
            Context.GetTable<T>().Attach(entity);
        }

    }

生成的SQL

UPDATE [dbo].[Account]
SET [AccountType] = @p2, [ModifiedTime] = @p3
WHERE ([AccountNumber] = @p0) 
      AND ([ModifiedTime] = @p1)

-- @p0: Input Int (Size = -1; Prec = 0; Scale = 0) [1]
-- @p1: Input DateTime (Size = -1; Prec = 0; Scale = 0) [6/26/2012 11:14:15 AM]
-- @p2: Input NChar (Size = 10; Prec = 0; Scale = 0) [WIN-WIN]
-- @p3: Input DateTime (Size = -1; Prec = 0; Scale = 0) [6/26/2012 11:16:29 AM]

文章来源: Default Values (of C# variables) Issue in LINQ to SQL Update