MySoft从2010年3月1号开始会将所有组件陆陆续续开源发布，发布开始版本(v2.7.2)，期间如有使用的朋友碰到任何的问题与疑问
可及时在此反馈，我会及时解答大家的问题，并在很短的时间内修复用户碰到所有bug.
祝大家新的一年：身体健康、工作顺利
QQ:121849018
MSN:maoyong181@hotmail.com
Gmail:mysoft181@gmail.com
QQ讨论群(MySoft)：27071789
class DB { DbSession session = new DbSession("ConnectionString"); public DB() { session.RegisterSqlLogger(LogSql); } private static void LogSql(string sql) { using (FileStream fs = new FileStream(@"c:\sql.sql", FileMode.Append)) { using (StreamWriter sw = new StreamWriter(fs)) { sw.WriteLine(sql); } } } public DataTable DoWork() { return session.From<News>().ToTable() as DataTable; } }
private void button1_Click(object sender, EventArgs e) { DataTable dt = new DB().DoWork(); gvData.DataSource = dt; }
using (DbTrans trans = session.BeginTrans()) { try { DbBatch batch = trans.BeginBatch(); //删除本节点 CollectType del = GetOneType(delId); del.IsDel = 1; del.Attach(); batch.Save<CollectType>(del); //移动子节点 foreach (CollectType ct in GetChildType(delId)) { ct.Pid = newId; ct.Attach(); batch.Save<CollectType>(ct); } batch.Process(); trans.Commit(); return true; } catch { trans.Rollback(); return false; } finally { trans.Close(); } }
MyTable mytable = new MyTable() { PrimaryCode = 1, SomeInt = 1002, SomeDateTime = DateTime.Now, SomeVarchar = "MoveUpdate4" }; UpdateCreator uc = UpdateCreator.NewCreator() .From<MyTable>() .SetEntity<MyTable>(mytable, true); DbSession.Default.Excute(uc);