Moon.Orm 5.0(MQL版)使用指南(二).doc

Moon.Orm 5.0(MQL版)使用指南(二) 一、使用sql及存储过程 1)使用ListDictionarystring, MObject 1.使用sql ,体验原生态的感觉 string sql=select * from Class where ClassName = @;string sql2=select * from Class where DateTimem = @;ListDictionarystring, MObject mylist=db.ExecuteSqlToDictionaryList(sql,boy);ListDictionarystring, MObject mylist2=db.ExecuteSqlToDictionaryList(sql2,DateTime.Parse(2013-10-10 14:40:08)); foreach(var oneClass in mylist){ string className=oneClass[className].Tostring(); long id=oneClass[Classid].Tolong(); DateTime datetimem=oneClass[datetimem].ToDateTime();//不用区分大小写 Console.WriteLine(className+ +id+ +datetimem);} 2.使用mql,智能感知带来的优雅体验 var list=db.GetDictionaryList(ClassSet.SelectAll().Where(ClassSet.ClassID.BiggerThan(0))) 2)MQL 全面接触 2.1 MQL的标准查询 var mm=ClassSet.Select(ClassSet.ClassID,ClassSet.ClassName). Where(ClassSet.ClassName.Contains(s).And(ClassSet.ClassID.BiggerThan(9))); SELECT [Class].[ClassID],[Class].[ClassName] FROM [Class] WHERE [Class].[ClassName] LIKE @p1 AND [Class].[ClassID]@p2@p1=%s%@p2=9 2.2 MQL的嵌套查询(含有Top查询:支持mysql、oracle、postgreSQL、sqlserver、sqlite) var qiantao=ScoreSet.SelectAll().Where( ScoreSet.UserID.In(UserSet.Select(UserSet.UserID).Where( UserSet.ClassID.In( ClassSet.Select(ClassSet.ClassID).Where( ClassSet.ClassName.Equal(c.ClassName).And(ClassSet.ClassID.BiggerThan(0)) ) ) ) )  ).Top(1); SELECT TOP 1 [Score].* FROM [Score] WHERE [Score].[UserID] IN (SELECT [User].[UserID] FROM [User] WHERE [User].[ClassID] IN (SELECT [Class].[ClassID] FROM [Class] WHERE [Class].[ClassName]=@p1 AND [Class].[ClassID]@p2 ) )@p1=综合测试ClassName2@p2=0 2.3 MQL的分组查询 var mql=ScoreSet.Select(ScoreSet.ScoreM.Sum().AS(sum),ScoreSet.TypeName). Where(ScoreSet.ScoreM.BiggerTha