打造Orm经典,创CRUD新时代,Orm的反攻战_.NET_编程开发_程序员俱乐部

让我们开启数据库无Linq、零sql时代(续)

第一部分 MQL

qq群:225656797

demo下载: 点此下载(既然下载,就支持该文,关注我的博客)

1.MQL概述

MQL是Moon.Orm 5.0中的全新设计,是在之前版本的革命性的升级.目的在于让我们的数据库开发打造为无Linq、零sql.它全面贴近标准sql,噪音低.原生.NET2.0支持、高性能、语法糖.多数库多数据源支持、操作便捷简单.

           使用场景:1.NET 2.0; 2.觉得其他Orm性能低;3不喜欢linq;4.想更加便捷用sql

           说明:一下以sqlserver为例.

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.BiggerThanOrEqual(100)).

GroupBy(ScoreSet.TypeName).

Having(ScoreSet.ScoreM.Sum().BiggerThan(300));

 

SELECT SUM([Score].[ScoreM]) AS 'sum',[Score].[TypeName] FROM [Score] WHERE  [Score].[ScoreM]>=@p1  GROUP BY [Score].[TypeName]  HAVING  SUM([Score].[ScoreM])>@p2
@p1=100
@p2=300

2.4 MQL的连接查询

var m1=ClassSet.Select(ClassSet.ClassID,ClassSet.ClassName)
                    .LeftJoin(
                    UserSet.Select(UserSet.UserID))
                    .ON(ClassSet.ClassID.Equal(UserSet.UserID))
                    .Where(UserSet.UserID.BiggerThan(9)); SELECT [Class].[ClassID],[Class].[ClassName],[User].[UserID] FROM [Class] LEFT JOIN [User] ON [Class].[ClassID]=[User].[UserID]  WHERE  [User].[UserID]>@p1
@p1=9

2.5 MQL的Union查询

var mql=ClassSet.SelectAll().Where(ClassSet.ClassID.BiggerThan(1))
                    .Union(ClassSet.SelectAll().Where(ClassSet.ClassID.BiggerThan(2)));   var mql=ClassSet.SelectAll().Where(ClassSet.ClassID.BiggerThan(1))
                    .UnionAll(ClassSet.SelectAll().Where(ClassSet.ClassID.BiggerThan(2)));

 

SELECT [Class].* FROM [Class] WHERE  [Class].[ClassID]>@p1  UNION  SELECT [Class].* FROM [Class] WHERE  [Class].[ClassID]>@p2
@p1=1
@p2=2 SELECT [Class].* FROM [Class] WHERE  [Class].[ClassID]>@p1  UNION ALL SELECT [Class].* FROM [Class] WHERE  [Class].[ClassID]>@p2
@p1=1
@p2=2

3.MQL查询结果预览

public static void Main(string[] args)
        {
            
            using (var db=Db.CreateDefaultDb()) {
                db.TransactionEnabled=true;
                db.DebugEnabled=true;
                Console.WriteLine("---------------嵌套查询---------------------");
                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);
               
                Console.WriteLine("---------------分组查询---------------------");
                var mql=ScoreSet.Select(ScoreSet.ScoreM.Sum().AS("sum"),ScoreSet.TypeName).Where(ScoreSet.ScoreM.BiggerThanOrEqual(100)).GroupBy(ScoreSet.TypeName).Having(ScoreSet.ScoreM.Sum().BiggerThan(300));
              
                Console.WriteLine("---------------连接查询---------------------");
                var m1=ClassSet.Select(ClassSet.ClassID,ClassSet.ClassName)
                    .LeftJoin(
                    UserSet.Select(UserSet.UserID))
                    .ON(ClassSet.ClassID.Equal(UserSet.UserID))
                    .Where(UserSet.UserID.BiggerThan(9));

            }
            Console.WriteLine("---------------Union测试---------------------");
            using (var db=Db.CreateDefaultDb()) {
                db.TransactionEnabled=true;
                db.DebugEnabled=true;
                
                var mql=ClassSet.SelectAll().Where(ClassSet.ClassID.BiggerThan(1))
                    .Union(ClassSet.SelectAll().Where(ClassSet.ClassID.BiggerThan(2))); 

            }
        }   QQAuDD8PrzP8nxNHBlk2qMXB5XAi9cQXQncz7qvM1gZAwBcm5e+XhfspXzRAn1ELAAAeOGwXgcAALgOrNcBAACuA+t1AACA68B6HQAA4DqwXgcAALgOrNcBAACuA+t1AACA68B6HQAA4DqwXgcAALgOrNcBAACuA+t1AACA68B6HQAA4DqwXgcAALgOrNcBAACuA+t1AACA68B6HQAA4DqwXn94lmVJNmqDZpcVluvsAQBgNazXr8AKkV73aiBjtuUVAwAAbIT1+hVYluVJO5cY26Xs27R3+zbzESG6BggAAElYr1+BSiaFarr6qruL1wqRVEf7mQwBAGALrNcviKvWro09zPTK+Nfe0HUAgEGwXr8avQqdWX9Hnl0z28v6RNcBAAbBev2xqSQzqdC3njX3zei3XevbBFxjdB0AYDSs1y+Cu5jW9kKqrVn0isF9fYCuAwCcxaj1uhAA2ndsv7MYpbQt5alm96Q3t315ruU253JnaH1on7MdAMbBev0iuA/Q6Dmbt8/4d5PR+zzcAQAGwefrF8EqpdbOpvQmvaHrAABTwXr9IqzW9WrNPULX7eIeXQcAGATr9YuwZb1+877Hbu1734cv/62CousAAINgvX4FrIImu2x0Ipx3vaoAAIC9YL3+8Ig3vcV74LaXPszgpuRmi64DAAyC9fpLpNR48Ub66OgAALA7rNdhUpqL/qT9iE8E3NdDTVeVwe6vb3jBBAA31uswM11SLT53iD4vsK60pf7EIfNqY4k/7+giGqk9hdgDvDRYr8O8RLKkG12tTb5EaOq06CLsqxcZ2j7PiuQB4PKwXod5SSrrLV6qRivX6OwgXc8bd4GuA4Bl7Hq9+UgdMaTMc3y1H9F+AMfX0421e5Rekoq7okskjYtH01WSKOcmyXOTXzAAAB5CSURBVOQPoBzI0KkoJn8yaGS/yxUBmIGB63V9qw+9f6LH7lKs6vIeMvsHcEo93cfo7lGiuHbILm4vYVYFig7dLjZixpUYZtMm031Jv9kwiGPuC9fzvTETN8rzmPwBjmHUet194JaBh948+v7vjT7D/X9WPZfPMDSKTiDZKNqFH1vY1V2EH4vOtjkK4dA9NZpjJonreXXoqONhRQMYxKj1evPesAbRk6i33XV+a93GSW9n3f9n1bNqjOrm2mtXmS63fl0XRPalwyphN27UJcpql+SjktrEupLZizIxm2R0Zd0RlRfF7ZIMLeqW6ZgZNcCcHLRetwiDzP2m78Ou27iZpHgeHXb/n1XPxSPjf3n+aF5R/LtxslG0u6eqPK2Z7uKGyFwmcbaXruSHsn2OWVe2nvnpl8m2slye03QCMC2TrtebN7Noj07px4q4pfON4zirnvdG68r1X9pH3d18ovpHqYoiRLhORLjolG2PMk/ijiVDPvnRlAOpBhUVPypC2ZJ3Fe2LOucbAR6LWT5fF88F0dhl3AwRMcP9f1Y93Qel8F8aVIfryhUlme+iPVSDjTra/bIamazyNnmSCR9A73wT86H3VDN0JudMdIBHYZbvw0fGvftRS9mYuXVX+B/NKfWM3DbtKzOdvB51tVPtlz6TuP6t23IgUZdMe69NnnJEYlwHkJk/mX17GEWxjZl5JeImPQDMz8l/v25vM3uLuk56292Imqb/jJN9Ob6e4tD1n7HvKt3drW3UXXqNrZkbWjjMjKtr7NqPHuZegfJ0zauoXUySpn1yyM18Mk4AZobfm4OpiR7xwj5vfHtYXY/cLh4jIgLAtPD78DA1riztrutCqvfSdR1oCyg3AJSwXofHo0tZk+v1QdE3xmqCqANABet1mJSuRbmw313Xb/2fDrgGu0syGg8AN9brMDO963L3c2X9ebM9FJa2PdoX/iuH7gCbRCO1pxB7gJcG63WYl0iWdKOrtcmXCE2dFl2EffUiQ9vnWZE8AFwe1uswL0llvcVL1WjlGp0dpOt54y7QdQCwnPz36yOGlHmOr3Dohtie7YpMjqynG2v3KL0kFXdFl0gaF4+mqyRRzk2SyR9AOZChU1FM/t6gtsv2KwIwA7P83ty+RI/dpVjVdbmyj5IdsuzklHqeNXb7sF5i3F7CrAoUHbpdbMSMKzHMpk2m+5J+s2EQenKOiGIbu+JGk2eHLAHOZpbfh98Xff/no1tVOOvmP6uepw/fDRflIHKL/NjCru4i/Fh0ts1RCIfuqdEcM0lczytC2+IcViiAAxi1Xm/eJ9YgehL1trvOb/H9Hz0H7/sz3P9n1bNqjOrm2mtXmS63fl0XRPalwyphN27UJcpql+SjktrEupLZizIxm2R0Zd0RlRfF7ZIMHdXN9e96BnhQDlqvW4SBvlH1vnDedRsnHxbCw76cVc/FI+N/ef7o7Cp+5TzZKNrdU1We1kx3cUNkLpM420tX8kPZPsesK1vP/PRbl2fmCgLMz6Tr9ebNLNqjU8lbunqmuO3NBHbnrHq6BRH+S/uou5uPe+rux2YlihDhOhHholO2Pco8iTuWDPnkR1MOpBpUVPyoCGVL3lW0X4WI6i/yB3g4Zvl8vXlfRTdb3nj1rasfHEknGzmrntaPfg6WBtXhulpFSea7aA/VYKOOdr+sRiarvE2eZMIH0DvfxHzoPdUM3Zvz6rkKMAmzfB8+c4/l70N9//fet5Pc/6fUM3LbtK/MVtet7GUbq8SSuP6t23IgUZdMe69NnnJEYlwHkJk/mX17GEWxjV3zKp8PwMNx8t+v29vJ3qKuk952N2IGkefxN//x9RSHrv+MfVfd7m5to+7Sa2zN3NDCYWZcXWPXfvQw9wqUp2teRe1ikjTte+dV1WudH4AJ4ffmYGqiR7ywzxvfHlbXI7eLx4iIADAt/D48TI0rS7vrupDqvXRdB9oCyg0AJazX4fHoUtbken1Q9I2xmiDqAFDBeh0mpWtRLux31/Vb/6cDrsHukozGA8CN9TrMTO+63P1cWX/ebA+FpW2P9oX/yqE7wCbRSO0pxB7gpcF6HeYlkiXd6Gpt8iVCU6dFF2FfvcjQ9nlWJA8Al4f1OsxLUllv8VI1WrlGZwfpet64C3QdACwn//36iCFlnuMrHLp+xo1CZHJkPd1Yu0fpJam4K7pE0pi57tZVkijnJsnkD6AcyNCpKCZ/b1Cb817XBeBcZvm9uX1xnd8bu0JXN7n7WNmWbJZT6nnWeO3j1X3yuuk1zapA0aHbxUbMuBLDbNpkui/pNxsGoSfniCi2sSuuO7t0IIBHYZbfh98Xff/no1tVOOv+P6ueevgH4IaLchC5RX5sYVd3EX4sOtvmKIRD99RojpkkrucVoW1x7DU9pm4AIxi1Xm/eGNYgehL1trvOb/H9Hz0H7/tiLIfd/2fVs2qM6ubaa1eZLrd+XRdE9qXDKmE3btQlymqX5KOS2sS6ktmLMjGbZHRl3RGVF8Xtkgwd1U3414EAHoWD1uuW5E3Vuy+c6y4rjI+8+c+q5+KR8b88f3R2Fb9ynmwU7e6pKk9rpru4ITKXSZztpSv5oWyfY9aVrWd++vXmGdkAPCKTrtebN7Noj07px0oV2ja62YoB7stZ9XQLIvyX9lF3Nx9RZzdVUYQI14kIF52y7VHmSdyxZMgnP5pyINWgouJHRShb8q6i/SpEs/4brwjADMzy+bp4LojGLuNmiIgZbv6z6mn9LHL9XRpUh+sqFiWZ76I9VIONOtr9shqZrPI2eZIJH0DvfBPzofdUM3Qm5xXdAaZllu/DR8a9+1FL2dh7905y/59Sz8ht074y08nrUVc71X7pM4nr37otBxJ1ybT32uQpRyTGdQCZ+ZPZt4dRFNvYNa9c+14PAHNy8t+v29vb3qKuk952N2IG4S3vZC+Or6c4dP1n7Hvrf/+3atRdeo2tmRtaOMyMq2vs2o8e5l6B8nTNq6hdTJKmfe+8irzlnQDMCb83B1MTPeKFfd749rC6HrldPEZEBIBp4ffhYWpcWdpd14VU76XrOtAWUG4AKGG9Do9Hl7Im1+uDom+M1QRRB4AK1uswKV2LcmG/u67f+j8dcA12l2Q0HgBurNdhZnrX5e7nyvrzZnsoLG17tC/8Vw7dATaJRmpPIfYALw3W6zAvkSzpRldrky8Rmjotugj76kWGts+zInkAuDys12Feksp6i5eq0co1OjtI1/PGXaDrAGA5+e/XRwwp8xxf4VD7P4bj6+nG2j1KL0nFXdElksbFo+kqSZRzk2TyB1AOZOhUFJO/N6hwtUvCAGcxy+/N7Uv02F2KVV2XK3cgBz8CTqmn++zbPUoU1w7Zxe0lzKpA0aHbxUbMuBLDbNpkui/pNxsGccx94Xq+N3bFdWeXiALwQMzy+/D7ou//fHSrCmfd/2fVUwz/GNxwUQ4it8iPLezqLsKPRWfbHIVw6J4azTGTxPW8IrQtzjH5AxzDqPV6896wBtGTqLfddX6Lb93oOXjfd42jKIM4q55VY1Q31167ynS59eu6ILIvHVYJu3GjLlFWuyQfldQm1pXMXpSJ2SSjK+uOqLwobpdk6Khurn8dF+CxOGi9bhEG+kbV+8K57pI3tk+KAzirnotHxv/y/BHZVfzKebJRtLunqjytme7ihshcJnG2l67kh7J9jllXtp756debZxnu4NIB7M6k6/XmzSzao1P6sVKFto1l+y33EN+Rs+rpFkT4L+2j7m4+7qm7H5uVKEKE60SEi07Z9ijzJO5YMuSTH005kGpQUfGjIpQteVfRfhUiqr81WFcHgBmY5fN18VwQjV3GzRAR+sGRdLKRs+pp/SzmgevuL97jMjFQJ59kY3RWe6gGG3W0+2U1MlnlbfIkEz6A3vkm5kPvqWbo3pxXz1WASZjl+/CZeyx/H+r7v/e+neT+P6WekdumfWW2um5lL9tYJZbE9W/dlgOJumTae23ylCMS4zqAzPzJ7NvDKIpt7JpX+XwAHo6T/37d3k72FnWd9La7ETOIPI+/+Y+vpzh0/Wfsu+p2d2sbdZdeY2vmhhYOM+PqGrv2o4e5V6A8XfMqaheTpGnfO6+qXuv8AEwIvzcHUxM94oV93vj2sLoeuV08RkQEgGnh9+FhalxZ2l3XhVTvpes60BZQbgAoYb0Oj0eXsibX64Oib4zVBFEHgArW6zApXYtyYb+7rt/6Px1wDXaXZDQeAG6s12Fmetfl7ufK+vNmeygsbXu0L/xXDt0BNolGak8h9gAvDdbrMC+RLOlGV2uTLxGaOi26CPvqRYa2z7MieQC4PKzXYV6SynqLl6rRyjU6O0jX88ZdoOsAYDn579dHDCnzHF/hUPs/huPr6cbaPUovScVd0SWSxsWj6SpJlHOTZPIHUA5k6FQUk783qHC1S8IAZzHL783tS/TYXYpVXZcrdyAHPwJOqaf77Ns9ShTXDtnF7SXMqkDRodvFRsy4EsNs2mS6L+k3GwZxzH3her43dsV1Z5eIAvBAzPL78Pui7/98dKsKZ93/Z9VTDP8Y3HBRDiK3yI8t7Oouwo9FZ9schXDonhrNMZPE9bwitC3OMfkDHMOo9Xrz3rAG0ZOot911fotv3eg5eN+f4f4/q55VY1Q31167ynS59eu6ILIvHVYJu3GjLlFWuyQfldQm1pXMXpSJ2SSjK+uOqLwobpdk6Khurn+RP8DDcdB63SIMMvebvg+77v+uHG7meSGc7MhZ9Vw8Mv6X54/OruJXzpONot09VeVpzXQXN0TmMomzvXQlP5Ttc8y6svXMT7/ePMtwXfMTYEImXa83b2bRHp3Sj5UqtG10sxUD3Jez6ukWRPgv7aPubj6izm6qoggRrhMRLjpl26PMk7hjyZBPfjTlQKpBRcWPilC25F1F+1WIZv03XhGAGZjl83XxXBCNXcbNEBFd+QzirHpaP4tcf5cG1eG6ckVJ5rtoD9Vgo452v6xGJqu8TZ5kwgfQO9/EfOg91QydyTkTHeBRmOX78JFx737UUjb23rpJ/6M5pZ6R26Z9ZaaT16Oudqr90mcS1791Ww4k6pJp77XJU45IjOsAMvMns28Poyi2sWteufa9HgDm5OS/X7e3t71FXSe97W7EDDrPgzm+nuLQ9Z+x763//d+qUXfpNbZmbmjhMDOurrFrP3qYewXK0zWvonYxSZr2vfOq6rXCCcCc8HtzMDXRI17Y541vD6vrkdvFY0REAJgWfh8epsaVpd11XUj1XrquA20B5QaAEtbr8Hh0KWtyvT4o+sZYTRB1AKhgvQ6T0rUoF/a76/qt/9MB12B3SUbjAeDGeh1mpndd7n6urD9vtofC0rZH+8J/5dAdYJNopPYUYg/w0mC9DvMSyZJudLU2+RKhqdOii7CvXmRo+zwrkgeAy8N6HeYlqay3eKkarVyjs4N0PW/cBboOAJaT/359xJAyz/EuJxtd7cjx9XRj7R6ll4yCrusSSaOdD9ahdZUkyrlJMvkDKAcydCqKyZ8JKoq/10UBOJ1Zfm9uX1zn98ZM6MjGfRZsyLSDU+p51njtE9Y+kZuP5sisChQdJidAxpUYZtMm031Jv9kwCD05R0SxjZm4kY07kTZkCnAms/w+/L7o+z8TPXP/a8HYl7PqWY3x+OdddBXyxtqPLezqLsKPRWfbHIVw6J4azTGTxPXcFToysE6OqRvACEat11fcYNGTqLfddX6L73/3Odi8/0X0EZxVT1GWpr12lely69d1QWRfOqwSduNGXaKsdkk+KqlNrCuZvSgTs0lGV9YdUXlR3C7J0G7dXA+35zPBzRbggThovW4RBvpG1fvCue7iGts7vLz/M3724qx6Lh4Z/1V9uopfOU82inb3VJWnNdNd3BCZyyTO9tKV/FC2zzHrytYzP/10nsJzGVqOGGBeJl2vN29m0R6d0o8VN7Q21jnsy1n1rEYq6mbto+5uPu6pux+blShChOtEhItO2fYo8yTuWDLkkx9NOZBqUFHxoyKULXlX0b6oc2QcBQJ4FGb5fF08F0Rjl3EzRIR7/6/ws4Wz6hmNPfJfGlSH6woVJZnvoj1Ug4062v1qJjSzytvkSSZ8AL3zTcyH3lPN0Pmc1/kBmI1Zvg8fGffuRy1lY+amTcY68v4/pZ6R26Z9ZaaT16Oudqr90mcS1791Ww4k6pJp77XJU45IjOsAMvMns28Poyi2MTOvtucAMD8n//26vbXsLeo66W13I2oy/g+++Y+vpzh0/Wfsu4p2d2sbdZdeY2vmhhYOM+PqGrv2o4e5V6A8XfMqaheTpGmfHHImn+OrB7Aj/N4cTE30iBf2eePbw+p65HbxGBERAKaF34eHqXFlaXddF1K9l67rQFtAuQGghPU6PB5dyppcrw+KvjFWE0QdACpYr8OkdC3Khf3uun7r/3TANdhdktF4ALixXoeZ6V2Xu58r68+b7aGwtO3RvvBfOXQH2CQaqT2F2AO8NFivw7xEsqQbXa1NvkRo6rToIuyrFxnaPs+K5AHg8rBeh3lJKustXqpGK9fo7CBdzxt3ga4DgOXkv18fMaTMc7zLidvllOfm8fV0Y+0epZek4q7oEkmjnQ/NKeF2yfjJk0z+AMqBDJ2KYvJngvZeRIBHZJbfm9uX6I5dilXdCg/Js4M4pZ7uY3T3KFFcO2QXt5cwqwJFh24XGzHjSgyzaZPpvqTfbBiEnpwjotjGTFxtc9j0BhjKLL8Pvy/6/s9EjwyaOjGIs+pZDfaUgScbRbvwYwu7uovwY9HZNkchHLqnRnPMJHE9d4WODA4uF8BQRq3XV9xg0a3V2+46v8X3v/sc1Pkff/+fVU9Rlqa9dpXpcuvXdUFkXzqsEnbjRl2irHZJPiqpTawrmb0oE7NJRlfWHVF5UdwuydBu3VwP2j/Aw3HQet0iDPSNqveFc93FNbbPnWT33TmrnvWjMV3Y5fljtKv4lfNko2h3T1V5WjPdxQ2RuUzibC9dyQ9l+xyzrmw989NP5xldqa6ZCTAtk67XmzezaI9O6cdK191+/P1/Vj3vjdaV67+0j7q7+UT1j1IVRYhwnYhw0SnbHmWexB1LhnzyoykHUg0qKn5UhLIl7yraF3W2jRsvB8AkzPL5unguiMYu42aIiBnu/7Pq6T4ohf/SoDpcV7EoyXwX7aEabNTR7pfVyGSVt8mTTPgAeuebmA+9p5qhMzmv6A4wLbN8Hz4y7t2PWsrGzN27wv9oTqln5LZpX5np5PWoq51qv/SZxPVv3ZYDibpk2ntt8pQjEuM6gMz8yezbwyiKbczMKxE36QFgfk7++3V7m9lb1HXS2+5G1HQlfwzH11Mcuv4z9l1Fu7u1jbpLr7E1c0MLh5lxdY1d+9HD3CtQnq55FbWLSdK0Tw454+f46gHsCL83B1MTPeKFfd749rC6Hrm1+oREAbw0+H14mBpXlnbXdSHVe+m6DrQFlBsASlivw+PRpazJ9fqg6BtjNUHUAaCC9TpMSteiXNjvruu3/k8HXIPdJRmNB4Ab63WYmd51ufu5sv682R4KS9se7Qv/lUN3gE2ikdpTiD3AS4P1OsxLJEu60dXa5EuEpk6LLsK+epGh7fOsSB4ALg/rdZiXpLLe4qVqtHKNzg7S9bxxF+g6AFhO/vv1EUPKPMe7nBycfzKrY/JxY+0epZek4q7oEkmjnQ/WoXWVJMq5STL5AygHMnQqismfCSqKv8sVAZiBWX5vbl9c5/fGTOjI5oDnVyalw+rpPvt2jxLFtUN2cXsJsypQdNicANo+U6iNxSyLo5MZzTH3hev53piJG9kckz/AMczy+/D7ou//TPTZ7v+z6rl8hqFRdALJRtEu/NjCru4i/Fh0ts1RCIfuqdEcM0lcz12hI4Nj8gc4hlHr9RU3WPQk6m13nd/iW9d9Dmbu7SPv/7PqKcrStNeuMl1u/bouiOxLh1XCbtyoS5TVLslHJbWJdSWzF2ViNsnoyrojKi+K2yUZ2q2b60E4BHhEDlqvW4SBvlH1vnCuu7jG9rmTyX8EZ9WzfjSmC7s8f4x2Fb9ynmwU7e6pKk9rpru4ITKXSZztpSv5oWyfY9aVrWd++uk8xZXqmpwAczLper15M4v26JR+rIi7PUo1GtoIzqrnvdG6cv2X9lF3N5+o/lGqoggRrhMRLjpl26PMk7hjyZBPfjTlQKpBRcWPilC25F1F+6LOtnHj5QCYhFk+XxfPBdHYZdwMEZF5uIzmrHq6D0rhvzSoDtcVLUoy30V7qAYbdbT7ZTUyWeVt8iQTPoDe+SbmQ++pZuhMzr19AWZmlu/DR8a9+1FL2Zi5gdfFHcop9YzcNu0rs9V1K3vZxiqxJK5/67YcSNQl095rk6cckRjXAWTmT2bfHkZRbGNmXq3IB+DhOPnv1+3tZG9R10lvuxtR05X8MRxfT3Ho+s/YdxXt7tY26i69xtbMDS0cZsbVNXbtRw9zr0B5uuZV1C4mSdM+OeSMn+OrB7Aj/N4cTE30iBf2eePbw+p65NbqExIF8NLg9+FhalxZ2l3XhVTvpes60BZQbgAoYb0Oj0eXsibX64Oib4zVBFEHgArW6zApXYtyYb+7rt/6Px1wDXaXZDQeAG6s12Fmetfl7ufK+vNmeygsbXu0L/xXDt0BNolGak8h9gAvDdbrMC+RLOlGV2uTLxGaOi26CPvqRYa2z7MieQC4PKzXYV6SynqLl6rRyjU6O0jX88ZdoOsAYDn579dHDCnzHO9ycnD+yayOyceNtXuUXpKKu6JLJI12PliH1lWSKOcmyeQPoBzI0KkoJn8mqCj+LlcEYAZm+b25fXGd3xszoSObA55fmZQOq6f77Ns9ShTXDtnF7SXMqkDRYXMCaPtMoTYWsyyOTmY0x9wXrud7YyZuZHNM/gDHMMvvw++Lvv8z0bc8I0ZwVj0/o4nL0Cg6gWSjaBd+bGFXdxF+LDrb5iiEQ/fUaI6ZJK7nrtCZ3A4rGsAgRq3XV9xg0ZOot911fovv/+gROdX9f1Y9RVma9tpVpsutX9cFkX3psErYjRt1ibLaJfmopDaxrmT2okzMJhldWXdE5UVxuyRDu3VzPQiHAI/IQet1izDQN6reF851F9fYPneqs8LDvpxVz8Uj4395/hjtKn7lPNko2t1TVZ7WTHdxQ2QukzjbS1fyQ9k+x6wrW8/89NN5RlcqcwUB5mfS9XrzZhbt0Sn9WGne7V0J7M5Z9bw3Wleu/9I+6u7mE9U/SlUUIcJ1IsJFp2x7lHkSdywZ8smPphxINaio+FERypa8q2hf1Dkq/saLAnA6s3y+Lp4LorHLuBkiYob7/6x6ug9K4b80qA7X1SpKMt9Fe6gGG3W0+2U1MlnlbfIkEz6A3vkm5kPvqWboTM7JBAAeglm+Dx8Z9+5HLWVj5r5dF3cop9Qzctu0r8xW163sZRurxJK4/q3bciBRl0x7r02eckRiXAeQmT+ZfXsYRbGNmXm1Ih+Ah+Pkv1+3t5O9RV0nve1uRE1v3AM4vp7i0PWfse+q292tbdRdeo2tmRtaOMyMq2vs2o8e5l6B8nTNq6hdTJKmfXLIvXkCPBz83hxMTfSIF/Z549vD6nrkdvEYEREApoXfh4epcWVpd10XUr2XrutAW0C5AaCE9To8Hl3KmlyvD4q+MVYTRB0AKt55+62u7fXXXu3T9RWP2lt6cbPxobbXM5FnKwAATMKTIid5kuxNui4Eu2xcp+vWQ5N1krw9LgAAwAjuIp3ZNul6+VHlXbarzy8rOV+xXnfDlWebNEsWDUfEBQAAOIZRuq4lUyxwK2GO/GjPWlnFq4EuymS2+AEAANiLo9frpRC6qtzUSPH6QLwOEE5ELE2VKqIOAACnc5Cuu6vqar96BRBlHPnRp/JOVrDLqwQAAIDtHKHr1ercXU9HSm+X3dZSnKrSSNKsWq+TvGcAAIAtVLru2uzzPnyJUDgt4bYx0vIjRbQZC10HAIBjsOv1ymDTet3qbnNde2utv5fnq3/hWS+dtVkXCDYAAEyC+z78/ezW78PfWp89C+Vunk16q+htz2D7ovQAAHAK0efrNyPq+7wPH0lvJOF2PX26ruv3Btw3ALa/JQAAAJDhuL9zq1qEyLkS7jpcp+tNGe6l2RddBwCAYzhB16PGFWeTGr+lPQOCDQAAk3Dmen2FxOYX6Og6AAC8QAbqun2/XX/qrN+fr866h9be9XP8+/AAAADH8M7bb338Y2/kt+6/c7vvZN6Q73p/Xoi6cMV6HQAALszrr73au7V1vfc/dWdjY2NjY2M7cVO6nv/v3AEAAGASQl1nY2NjY2Nje8TN0XU2NjY2Nja2x91+Xde7vn3HxsbGxsbGNuf2+muvrvn2HRsbGxsbG9uc2/8HmxObzquLQrIAAAAASUVORK5CYII=" alt="" height="353" width="538" />

 

第二部分 Moo.Orm数据操作篇

1.Moon.Orm初始化说明

1.1 配置文件说明

1.1.1默认配置

<connectionStrings>
        <add name="DefaultConnection"
             connectionString="Server=QSC-E15014A6665\SQLEXPRESS;Database=Test;uid=sa;Password=123456;"
             providerName="Moon.Orm,SqlServer"  />
</connectionStrings>using (var db=Db.CreateDefaultDb()) {}

 1.1.2其它配置

 

<connectionStrings>
        <add name="MyqlConnection"
             connectionString="mysql连接字符串"   

             providerName="Mysql自定义dllName,Mysql"  />
</connectionStrings>

using (var db=Db.CreateDbByConfigName("MysqlConnection")) {}

1.2 通过字符串直接初始化

using (var db=new SqlServer("连接字符串") {

}

2.Moon.Orm开启事务

using (var db=Db.CreateDefaultDb()) {
                db.TransactionEnabled=true;

               //随便写许多逻辑,一个事务都在这个{}中

}

3.Moon.Orm开启调试模式

using (var db=Db.CreateDefaultDb()) {
                db.DebugEnabled=true;

               var mql=ScoreSet.Select(ScoreSet.ScoreM.Sum().AS("sum"),ScoreSet.TypeName).

               Where(ScoreSet.ScoreM.BiggerThanOrEqual(100)).GroupBy(ScoreSet.TypeName).

               Having(ScoreSet.ScoreM.Sum().BiggerThan(300));

                var sql=mql.ToDebugSQL();//可以查看当前查询语句

}

4.Moon.Orm开启缓存模式

using (var db=Db.CreateDefaultDb()) {
                db.StartCache(秒数);//查询用的缓存}

5.Moon.Orm添加数据

using (var db=Db.CreateDefaultDb()) {
                db.DebugEnabled=true;
                Class c=new Class();
                c.ClassName="综合测试ClassName2";
                db.Add(c);

 }

6.Moon.Orm删除数据

    using (var db=Db.CreateDefaultDb()) {
                db.DebugEnabled=true;
                db.Remove(ClassSet.ClassID.BiggerThan(9));
            }

7.Moon.Orm更新数据

using (var db=Db.CreateDefaultDb()) {
                Class c=new Class();
                c.ClassName="综合测试ClassName2";
                c.WhereExpression=ClassSet.ClassID.BiggerThan(9);
                db.Update(c);
            }

8.Moon.Orm查询数据

8.1无实体类时,使用代码生成器生成实体类

List<T> ExecuteSqlToOwnList<T>(string sql)where T:new() List<T> ExecuteSqlToOwnList<T>(string sql,params object[] values)where T:new()List<T> GetOwnList<T>(MQLBase mql) where T: new()

8.2无需实体类

//-----------------------------1.用MQL-------------------------------------- List<Dictionary<string,MObject>> GetDictionaryList(MQLBase mql)var m1=ClassSet.Select(ClassSet.ClassID,ClassSet.ClassName)
                .LeftJoin(
                    UserSet.Select(UserSet.UserID))
                .ON(ClassSet.ClassID.Equal(UserSet.UserID))
                .Where(UserSet.UserID.BiggerThan(9));

var list2=db.GetDictionaryList(m1);

//-----------------------------2.用sql语句------------------------------

List<Dictionary<string,MObject>> ExecuteSqlToDictionaryList(string sql)List<Dictionary<string,MObject>> ExecuteSqlToDictionaryList(string sql,params object[] values)//支持参数化DataSet ExecuteSqlToDataSet(string sql)DataSet ExecuteSqlToDataSet(string sql,params object[] values)int ExecuteSqlWithNonQuery(string sql)

8.3使用存储过程

DataSet ExecuteProToDataSet(String procName,params DbParameter[] parameters)int ExecuteProWithNonQuery(String procName,params DbParameter[] parameters)List<T> ExecuteProToOwnList<T>(String procName,params DbParameter[] parameters)where T:new() 

 

第三部分 MQL的邀请

MQL的现状:

1.目前基本完成了sqlserver的开发工作. 还需要oracle、mysql、postgreSQL、sqlite、db2的核心功能的开发,当然接口和核心模块都写好了,各类型数据库的模块我们需要实现基类即可.再次发出邀请,请您加入,发邮件给我 qsmy_qin@163.com

2.目前我们写代码生成器,我会定核心接口,您的加入只需实现此接口

您的参与,将奖励:

该版本的源代码

 

5.0之前的所有版本,我立即向大家开源,因还没有整理好,有需要者留言(关注我的博客),我发下载链接给您.