用LINQ TO SQL 如何给插入一行数据?
sntyy 2008-10-25 01:37:41 hs_id列是标识列,提交数据时总是报错“不能给标识列显示插入数据”,请问怎么修改?
还有奇怪的是我把数据模型类下面的被注释掉的那部分去掉以后,提交数据时就报错“未将对象引用设置到对象的实例”
DAL.mysystem db1 = new DAL.mysystem();
DAL.MODEL.Sys_HelpSort hs = new DAL.MODEL.Sys_HelpSort();
//hs.HS_Id = 111;
hs.HS_Name = "ddddd";
db1.Sys_HelpSort.InsertOnSubmit(hs);
db1.SubmitChanges();
//下面是数据模型类
[Table(Name = "Sys_HelpSort")]
public class Sys_HelpSort
{
private int _HS_Id;
/// <summary>
/// 编号
/// </summary>
[Column(Name = "HS_Id",Storage="_HS_Id", IsPrimaryKey = true, DbType = "int not null identity")]
public System.Int32 HS_Id
{
get { return this._HS_Id; }
set { this._HS_Id = value; }
}
private string _HS_Name;
/// <summary>
/// 类型名称
/// </summary>
[Column(Name="HS_Name",Storage="_HS_Name")]
public System.String HS_Name
{
get { return this._HS_Name; }
set { this._HS_Name = value; }
}
//private EntitySet<Sys_Help> _Sys_HelpSort_Sys_Help = null;
///// <summary>
///// 主键关系,主键表:Sys_HelpSort,外键表:Sys_Help
///// </summary>
//[Association(Storage = "_Sys_HelpSort_Sys_Help", OtherKey = "H_Sort_Id")]
//public EntitySet<Sys_Help> Sys_HelpSort_Sys_Help
//{
// get{ return _Sys_HelpSort_Sys_Help; }
// set{ _Sys_HelpSort_Sys_Help.Assign(value); }
//}
}