110,502
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Linq;
namespace WuweiCommon
{
public interface IDomain : IDisposable
{
IQueryable<T> Cast<T>() where T : class;
void Insert<T>(T obj) where T : class;
void Update<T>(T obj) where T : class;
void Delete<T>(T obj) where T : class;
void Commit();
}
}
using (var dt = WuweiCommon.Extensions.GetDALInstance ())
{
var tm = dt.Cast<Team>().First(t => t.Name == TeamName);
tm.Name = Team.Name;
dt.Insert(tm);
dt.Commit();
}
using(var dbt=new DataContext(this.connectionString))
{
var u=new User{LogName="张三",Email="张三@1234.com"};
var u=dbt.GetTable<User>().InsertOnSubmit(u);
dbt.SubmitChanges();
}
using(var dbt=new DataContext(this.connectionString))
{
var table=dbt.GetTable<User>();
var u=table.Where(u=>u.LogName=="1234").First(); //删除1234这个用户
table.DeleteOnSubmit(u);
dbt.SubmitChanges();
}
using(var dbt=new DataContext(this.connectionString))
{
var u=dbt.GetTable<User>().Where(u=>u.LogName=="1234").First();
u.Email="xx@1234.com";
dbt.SubmitChanges();
}
[Table]
public class User
{
private static Random Rnd = new Random();
private long _ID = long.MinValue;
[Column(IsPrimaryKey=true)]
public long ID
{
get
{
if (_ID == long.MinValue)
_ID = (long)Rnd.Next() + DateTime.Now.Ticks;
return _ID;
}
set { _ID = value; }
}
private string _LogName;
[Column(DbType="nvarchar(40) NOT NULL")]
public string LogName
{
get { return _LogName; }
set { _LogName = value; }
}
[Column(DbType = "varbinary(32) NULL")]
private byte[] PasswordMD5 { set; get; }
private string _EMail;
[Column(DbType = "nvarchar(100) NOT NULL")]
public string EMail
{
get { return _EMail; }
set { _EMail = value; }
}
[Column(DbType = "bit NOT NULL")]
public bool DenyLogin { get; set; }