# ORM LINQ **Repository Path**: terran-hero/basic ## Basic Information - **Project Name**: ORM LINQ - **Description**: 数据库持久化 ORM 开发框架,支持多种数据库(MSSQL,MYSQL,ORACLE,DB2等)。 支持Linq表达式动态查询数据。支持快速分页。 - **Primary Language**: C# - **License**: MIT - **Default Branch**: master - **Homepage**: https://gitee.com/terran-hero/basic - **GVP Project**: No ## Statistics - **Stars**: 10 - **Forks**: 0 - **Created**: 2023-01-31 - **Last Updated**: 2025-10-02 ## Categories & Tags **Categories**: database-dev **Tags**: ORM, LINQ, visual-studio, 插件, 代码生成器 ## README ## basic ORM Framework & Designer basic ORM 于2012 年发布、2023 年正式开源,该组件已在数百个成熟项目中应用。 经过数十个版本的更新迭代发布全新v6.0版本,支持动态条件查询(Lambda) 数据库持久化 ORM 开发框架,支持多种数据库(MSSQL,MYSQL,ORACLE,DB2,PostgreSQL等)。 支持Linq表达式动态查询数据。支持快速分页 简单的事务处理,自动化事务提交,回滚 ### 设计器文件目录 - 设计器文件(*.dpdl) - 数据持久类代码(xxxAccess.cs) - 数据持久类代码(xxxAccess.designer.cs) - 业务逻辑类代码(xxxContext.cs) - 业务逻辑类代码(xxxContext.designer.cs) ![添加持久类截图](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAlgAAAGQCAIAAAD9V4nPAAAABGdBTUEAALGPC/xhBQAANDVJREFUeF7tnVuTHdd1mM+Df0Ukv8kpuVKSRZPlSsoPqTwkcZxEeVDZll0hUyaUOKItKbZslxNb0qmIoiSGE8uJTFkTMZZ1sQ3AkjVCRlFMyaIkcgAaF4IAiQGGAAhgAOI6gwFxI8UhmbX3Xt370rtnZgNnMHO6v69WYbpXr7V3n6HQn3afgz6DV1555ebNmzdu3Lh27dqVK1cWFhbOnz//b3/lvQRBEATRsTh16tTZs2cvXry4uLi4tLT08ssvX716deAseP36ddm5fPnyhQsXzpw5I9X/6ud/jiAIgiA6E6K2Y8eOzc/Pnzt37tKlS6I8caGsAAfOgrIcFDGKIWU5KMJEhARBEETHQtQ2Nzd38uTJl156SVZ9CwsLzoUqQlkOyo4YUtaMJ06cQIQEQRBEx0LUNjs7e/z48XpRKMs/ceGgXg7KzsWLF8+cOSNFiJAgCILoWIjannvuuaNHj546dcotCp0LB2JBWQ5euXLF3Rc9ffr0sWPHECFBEATRsRC1HThwYG5u7sSJEyI7WRTK8m9hYWEgFpTloPu8qGRlwSi2RIQEQRBEx0LUtn///sOHD7u7o2fPnnWLQhVh/QbhyZMnxZaIkCAIguhYiNqeeeaZQ4cO1XdH3aJw4JaD7g1CycqC8ciRI4iQIAiC6FiI2vbu3fv888+/8MIL7u6oWxSqCBcXF92/IHzxxRdl2YgICYIgiI6FqG3Pnj0HDx6U9Z7Ibn5+XpZ/58+fH4gFl5aWnAhFj8ePH5+dnV1JhI/sfPPNnRNm++FdbzZxhyQe2D5fb+fiN7bu2vZAXfbBbfO7HrGD73w4KZu3mQmZtoFpCWrq0NGCjIaMP7/1g0myDvPS5rf/htme2Kkb9mXW2wRBEMRGxpHZ2Yn/FmvChiTlUJJMQtS2e/fuAwcOuLcJT506Jcu/c+fOqQjdk9VEj8eOHTt06NAqK0IRjxdezl4mYhGaFo+zlNWVKdu+bX7eSDEnMC/C1EaixkIRylxvuonaQhqdKavpjOzntz38QURIEASxCUKE96NXbiYuzCabIWp7+umnn332WVnviexOnjzp7o4aEV6+fDkU4fPPP7+KCOPwQqrC6CRELCWuqpZizlJpjbFjvMSc37rdrwJ37lrLitAs6RK8jJszriDFpncJgiCIzRCJ9tZoQQlR265du/bv3+8+L1O/TTiQ5aCI8NKlS+7fTqwqQtGe80f2XmUgHrGa3XaWaohQR9u2c5foyR4yotKaqrduN9PlzRSchi8Ip9CwjgyTib9bXo5n5aUkQRAEcceilt/aLSghatu5c+czzzxTf17GvU1YLEKJ2oV+O3N3dFURmhuV7tboxCM757c9vH2nSLFqqYozIgyPRjXxgrLGFMuhxKOBa6Mwg8grUi+mL4ogCILYFOEUuHYLSoxShFWoM9xusJ6rj1rTGMk90BRhJTb3VuID23eaox/cttMkXYsbRxqtzILbpAFuTFeTF1s+QpfbMFa26CBq6/BeK1IkCILYNLHBIhSL7Nom7tE1lr8PaYXkt52lWkRoaox+4oWaXVma8aslY2WgoDIYKq5xmTra1nyqt1iEafAeIUEQxKYNZ0H5s95ICrIxQhF6J4nSRCdGbOJFu2irDKdKcxtZEeq9xxo9asXmPWe1Z8YxVtueftolUKPKUg9EhKNJGAuKIGXAUHUtvQEri5MgCIK4M5HIb+0uHKEIH96latEllxWbteMjsiLURVi1qmsVoclosZFQZVAZMydC2z7hl5ImoncNdUX4QPDvHDIrQmvfKulPoBEiS/ldtB0lCIIgNiiy2lujC0cnwso6bjnoNsRPbleTRiReeypCu65yRNpzyJj2jqUbyrvQTicCc4O72oqMCIMFZSxCdwJaVkU1Y5IJRjA96JAgCGKTxG3+g/rRiFDF5nadNtIPZNrVoWTCo+KhQI3iHrs4CxpNcaAc2a0+IDO/batbg7pGLahWhO4Wqz8lE5VfqxmjhWAa1p07t+qt0aolCD9anCcIgiDGKUa3IiQIgiCIMQxESBAEQfQ6ECFBEATR60CEBEEQRK8DERIEQRC9DkRIEARB9DoQIUEQBNHrQIQEQRBErwMREgRBEL0OREgQBEH0OopF6B4rBgAA0A0QIQAA9BpECAAAvQYRAgBAr0GEAADQaxAhAAD0GkQIAAC9BhECAECvQYQAANBrECEAAPQaRAgAAL0GEQIAQK9BhAAA0GsQIQAA9BpECAAAvWZ9RfjR/3OBIAiCIDY21EktrLsIL11bJgiCIIiNio0X4cWrywRBEASxUbHxIrxwdZkgCIIgNio2XoTnry4TBEEQxEbFJhDhy8suLl1bvvrK6zdfe0Pi2qsEQXQqrv/I/dV+feHa6/XfeoLYDLHxIjz38rLE9Vdf1xQAdJ1XX3vD/cUnbOz4lcH9X02TtxCjGqd3sfEiPHsFCwL0jr0vLsnf/SBmh3cNAu7/SnT09kMkofzK9uTQhsVTD909uG+HPbeRvF4d5yv3DX7qodnGUaI1Nl6EF64u6w4A9InF66+/dGW5CiNCUZTubr/fGSsoSCKuXyWMBatiabz/y9HRDYp9j/zUXY88ZbaNwEZxSvU48hrvHu4LD/U6Jr+0td5+4aWlx5/cW++62HgRvvwKy0GAPnLztTfOXFmuYvZjdw1+eXu9u3xGPGEv6z4TRaN+hbDKeTJJbnR8+b76/Hf88kqvdO0RjCP/T+K+HfHR/saP/diPiQtlY+6lpZ/5Rz/7h48+Fh6V2HgR3vjRG7oDAH3i1eU3z+wV2939sb3LZ5as2LbJRh1BxpQpNiNX/AoxXKYgCVPflq+4/8suaYZqbruTsfVuxqD3pz4xm4xWZZaf/MTdmqqoDsmA7oW7xmrG7CnFeR0h85KDceSoniex/O/f/yFxofjvZ/7hz77t77/9mSOnk4KNF+Ery6kIX19+bf/+/U9EHD63LH9trr+4R/efeGLPi1fNXyQbJn/owpuvXjgcVmpmz/ySKzNHBVdg4+r87nocX3npkB/czVi1xOPn8tJrN8zIdeaJ3Sev29FcXH9xNjwlP6A5Ydlu641meeKJ2UtVcfircOFHWzopJ2q7/AvMnoAd0xWYZDh+XRD9WvRsW8P9ihLcUOGhEf93PDdb/8ZyvyX/coKXECbzv5lgLhfh+USx2n/cVaYw59z2X9yPIL+9/Oxh2LIUfz4Vo/j9NyP3e27+H95ry2+c3vvIOwd3f3Tv8uml2Y9a7Z1eqqPOzH70vkd+6JLb7hc9fCk62lYQh8kL4SGjlnd+YjYosEfNKVVlfttMF7THvZpxL0Si+VqaYaQVjOa2W04pM132JWfHJEy87/0fkv9+zoLJIYmNF+HN11gRAvSR09feFLtWofKIM0YtbvcHfml1/5/l6hsFmdCa+3aYXfHHXY/8wB+tBrTy0xH8djxd2mszMeItf7QZMrIfwUjLzNJ2Ss3pbDRecjWOiei3R0j83sc+se/I6STpYuNFeO1VRAjQR1648sb85eUqqot+nXFXf9nYIzYavPPBWZM02/f/mSkI6vMFbWFWV94uPm/NsSceITudRNqby9j4wYPprVE9T3Ma9XlW222n1Bw8/5JzYxJriI0X4YWrfFgGoI8cvfH6qcvLVcx+5K7Be7dVu3LpH9z9kT3V9l2PfN/mv2+8cv8Xk/p8QRCiint3VLs73qsjy4ZxiebrQYxXdOr8dCZMb7W74yNmkDCz/MV7G+eQRn0abtvVt5xSc7r8S67Hca9i1XMgNDZehCcvL7/2OotCgH7x2htvnlpaPlldr09a03jueuQJk3ThD73z3vur+uUn3GLLVOYLwtBiixilyhvBVPiuujgYTUVYNbozd1SNPhNXtsQX763LVGDVdk3wQtLpsi85GEdMee8O7SVWi40X4YnFZQlUCNAf5O/7/JL5i39iq7leu4tA72K3eZvwe0lyNDH7B3fd/Qe7kyTRGhsvwhcXl10s3nj9xmtvvLps/nXR0itvXL657vHM14fbn0uTcVz82z/J1rTliQ2INfx3HPeQ/71NPaPbR7YPh4/+4GJcMAZR/+2+fOP1E5f1b/3/vnfwS1t1u4fxPVl63rsjSd5+yG/1HQ/OJklihdh4ER5fWN7EMfv77xr80l8mSYm2PEGsT+x+5B16J2zwjo/PpkcJgriNQIQEQRBEr2PjRXhsYZkgCIIgNio2XoRHLy0TBEEQxEbFxouQIAiCIDY21EktrK8IAQAANjmIEAAAeg0iBACAXoMIAQCg1yBCAADoNesrwu1f20EQBEEQdzhUQmtj3UWoWwAAAHcERAgAAB3hejnShQgBAKAjqNxKkC5ECAAAHUHlVoJ0IUIAAOgIKrcSpAsRAgBAR1C5lSBdiBAAADqCyq0E6UKEAADQEVRuMZcvL33jm9+5ePGS7sdIFyIEAICOoHILuHr16lf/YsdDn/78Y3/6V2JEzQZIFyIEAICOoHKrOH/h4l9PPS4WdCHbktFjFdKFCAEAoCOo3Cyy/pv+1hO1BV1IJlkXShciBACAjqByszz+nacSC7qQvFZYpAsRAgBAR1C5lSBdYyHCK4e+83d/t6g7AQszk8OpOd0x+ER4aG5qGJd55NDkzILuBDRGzhcmI8tu2JSb1+eCKezgM/UMdtduNU7DsMaXBgDQO1RuJUjXeKwI5ybuGQzumaiv+NNb7I5Jb5nWnMEnokNmJ+gOaRnZ5esBprfURXLATyn5cFzZbZxOWBANanaqbTO+P+JHDWtqoqTZCU8BAKDHqNxKkK7xEKHBycKhHmh4wieSQ2Y3Lg3IjGwI06Fr7FhKPKR0NOYIqxvD1NXRTizCAJeNarWmMS0AQA9RuZUgXeMjQgAAgBVRuZUgXYgQAAA6gsqtBOnqlQjDm50GbigCAHQJlZvlBz98ui20wiJdrAgBAKAjqNwsifzC0AqLdCFCAADoCCo3SyK/MLTCIl2IEAAAOoLKzZLILwytsEgXIgQAgI6gcrMk8gtDKyzShQgBAKAjqNwsifzC0AqLdCFCAADoCCo3SyK/MLTCIl2IEAAAOoLKzZLILwytsEgXIgQAgI6gcitBuhAhAAB0BJVbCdLVOxGe0Z9Nmk+vjp55HT+GJvOo6+i5Nf7x2m6Q8HHb4WO1LdE8rQdWGdNgTyFKN8/TZHikDgB0EpVbCdLVOxFe058NRBBC5AiTUqsYfQSGyRRHdjNG0oNWPFsa39cUlcYje3PZ3mqOZExzAsGQgm1tmDQ9z2hMAIAuoXIrQbp6J8Kb+jPFKGNiTmQTSMLldCeUV644LQiltWXa/JkbS7YaWvK5YBjBz2fzE9FBPamJyLg21XxRURsAQGdQuZUgXWMtwoWZSftV7v4r3V3SfGl7lAswLzqDU0ZsszppCY5ki5OCWjbVtvlZJevSeISKOpuOk4wfdbudKCVldidN1mMCAHQKlVsJ0jVOIvzCF75gbv3VV3F/fQ+v9NWFXnKDLdXV37OoP2Nah6q2zajVdr7YTljj0148Zstt1n3RADV1i+1QwrqqwEzpx9ZMXei3w2w9OABA11C5lSBdY7wizF/zY4s0F4WZReKKQ1XUx9uKo22zkyiq2jY7dWnUUyNlLut7/XiGOm82TGluwHDsYNuPCQDQMVRuJUjX+Irw+9t++7e/aHnwwQc/85nPfPGLT9kr/Ul/oZ/eMpycsVuenAiNZWLcALWQQtqKI/EEe7F4zF742RkzWqolnwt7w8ogb+fx7wzW09r6mOaYAACdQuVWgnSN8YqwjVO7/7aWx9Rw6LZqMiIMFWOo98UZgdocrcVmy1f7dCoesy9UpXY3mMXuV/VRr9nRwjBvZvId9Un4E3DU+9GYAABdQuVWgnSNkwiHw6Fc8v/oj/5S99s5cUU3FmYmdauiKcJUGT4jzggUZWkvthueuqgpHpMJ3ecSFemBoNfWmf0oH+3ISdgB2s8zmiyaDQBgzFG5lSBdHVwRAgBAP1G5lSBdiBAAADqCyq0E6eqhCOeiW5jpHUQAABhXVG4lSBcrQgAA6AgqtxKkCxECAEBHULmVIF2IEAAAOoLKrQTpQoQAANARVG4lSBciBACAjqByK0G6ECEAAHQElVsJ0oUIAQCgI6jcSpAuRAgAAB1B5VaCdCFCAADoCCq3EqRrnEQ4tOhOxczkMPtsmNy30xta0kL9SOua6PnU1ZGWh1ZH6dYnagdHXL750Gv77O4obSuDE4uf7m3h6TgAAL1dEU5OTt6T+yb65lfyOlpFKLoRIqWYlBrJyMhtm63UO0ZNgbsic0X1wZdC2BGF2IS2tWHS9MQcMlgzCQDQX1RuJUjX+ItwZkGEMBXZxDA5nMpKok2ERjcTc7FbXE535JDdMaqK/RPYrcbn4no/gc1PJIPZGf3X7BrcScQn5sjlAAB6jMqtBOkaexGahV/um+jnpoaBTTwtInS6sXLxbVXSUh2xAgv9E7XU1Nmw3mxXtZqPut1OlKrOITOLpBAhAIBH5VaCdI2TCLPvEVqxTU8N0y/gFRPKmiw2hyEvQq+ZUDiVhNym5s1WjUllFCWo5+L6sK4qkHb1WZCpC/Mn5pAMIgQA8KjcSpCusV8ROmT9p1ueBfFK853CrAjz6sk7rDZcRdNQBilzWV8vhUFnnTcbprQeJxgwHLsxjyQQIQCAR+VWgnSNvQhljSiaaq4UDblbpjkRilESnGBqmYV4sVWY9tRIPhfWh5VBXtLhO4N2t9pKCOeRo+EuAEDfUbmVIF0dWRGKV/RnxPRU/lZqTKgnQ72/RhHaVLhas/tVTVRvdrQwzDvhBXuupvXEHLIbHgUA6DsqtxKka5xEaN8izK382lmYSd87bIow1Y3PiKvWJEKDSdeEXUm9rdPBfT7akentAO0n5pC9+DAAQL9RuZUgXZ1ZEQIAQN9RuZUgXYgQAAA6gsqtBOnqoQjntugNTIXbiwAA3UDlVoJ0sSIEAICOoHIrQboQIQAAdASVWwnShQgBAKAjqNxKkC5ECAAAHUHlVoJ0IUIAAOgIKrcSpAsRAgBAR1C5lSBdiBAAADqCyq0E6UKEAADQEVRuJUgXIgQAgI6gcitBusZJhNmHbs9MDrPPhml8EaHSkhbqx2HX2ExFdSR6PnZA2m4ekJ1gjkZjxvMFHWE66kgf5x1n7BiaiCeqnuIdV4c1udcEADBWqNxKkK6xXxFOTk6KmMKru6P5lbyOVhGKFIRUQZU4jDLcttnKSCPT7ki+I6Kl3UrQ56e36MQmH8jLdNdldqgtsdxiESYTRSKMhhLqKQEAxhWVWwnSNf4inFmQ6/tU4xI+OZxq6kZoE6F4QUQgQwVucDndqSySEYyQa3ckuWy71GTGzOd9zg1l/myeZXYif7DlVQAAjDUqtxKka+xFaBZ+uW+in5saej0EtIhQxGDLA1f4pKU6klVItt0hqbA8157psuTzdbYayvysxvQtmYmig9kZAQDGGZVbCdI1TiLMvkdoxTY9NUy/gFdMKHZoXuvzIvSKCOUT6MJoxW1nBNPS7pBMWG7aPe5Is8mRz9cn4M/EDmo3fUs0kcv5g+HIvjA8TwCA8UPlVoJ0jf2K0CHrP93yLMgFvvlOYVaEoReC7dAlkTcSY7S0OyQRlmfamz1KPi8juGw4lD1V2fEtK55nZmRJpecFADBeqNxKkK6xF6GsEUVTzZWiIXfLNCdCcUCCU0KtnJCmYNraHYlgMn6yNc2JBDNyWuxz8VBmL/zsTGaiYJrmjJJpnBcAwFihcitBujqyIpTrvv6MmJ7K30qNSXVT74tL1iDC1nZHIpiMnwRrsWCu6iOcad7uV+3pUPZgXZ4eFeRU6rHSkdPzBAAYP1RuJUjXOInQvkWYW/m1szCTvnfYFGEqMp8RWYSqcKhulHsmJlrbHYlg4vZQRaatorUjPB9zIJ7ZlmpJ86iZIXo98bk0XyoAwHihcitBujqzIgQAgL6jcitBuhAhAAB0BJVbCdLVQxHOBbcgDcn9QwAAGFNUbiVIFytCAADoCCq3EqQLEQIAQEdQuZUgXYgQAAA6gsqtBOlChAAA0BFUbiVIFyIEAICOoHIrQboQIQAAdASVWwnShQgBAKAjqNxKkC5ECAAAHUHlVoJ0IUIAAOgIKrcSpGucRJh96PbM5DD7bJjGFxEqLWnBPoI6GCp8CLbij6bFQlTvn2DtnmwdP9E6efp19PDr1gOrjGmwpxClm+dpMrlfGADA2KNyK0G6xn5FODk5KRf21AiSbzFhqwhFEELGEWKXRjJXHNrNGEkPWvH4rwm0pKXBschckbSSMc0JhMrT1oZJ0/OMxgQA6BIqtxKka/xFOLMghpiKjGCYHE5lr/ZtIjTKmJiToRqSyOSyxbJbOyiwjds0f3pD+VLZaozuc8Ewgp/P5ieig3pSE5FxbSo5z3hMAIAOoXIrQbrGXoRm4Zf7Jvq5qWFgBE+LCJ0yQkXVxB4x5IuDvVA21bb5WSXr0sx0Qp1Nx0nGj7rdTpSSMruTJusxAQA6hcqtBOkaJxFm3yO0YpueGqZfwCsmFO9UV39PXoReFZE0LJKJxdFSLDuenHjMltus+6IBauoW26GEdVWBmdKPrZm60G+H2XpwAICuoXIrQbrGfkXokPWfbnkW5IrffKcwK8K8PhRJROJoK44aZSdRVLVtdurSqKdGylzW9/rxDHXebJjS3IDh2MG2HxMAoGOo3EqQrrEXoawRZbnUXCkacrdMcyI0lokJTSFHk90EPRqKJ9iLxWP2ws/OmNFSLflc2BtWBnk7j39nsJ7W1sc0xwQA6BQqtxKkqyMrQrm+68+I6an8rdSYUDGGZF92472WYtnyIvTpVDxWhf5Op931fW6/qo96zY4Whnkzk++oT8KfgKPej8YEAOgSKrcSpGucRGjfIsyt/NpZmEnfO2yKMFVGmpG9aKet2Gx46qKmeEwmdJ9LVKQHgl5bZ/ajfLQjJ2EHaD/PaLJoNgCAMUflVoJ0jVSEey6/a3BpMDg3GMwPBsfe87k7uSIEAIC+o3IrQbpGJ8J9S3cNLv/Xv6tWhN899g8GiBAAAO4cKrcSpGvEIvyLDXuPcO3MRbcw0zuIAAAwrqjcSpCu0YlwaWnrvZcH7tboezezCAEAoJuo3EqQrlGKsP6wzHvte4QDbo0CAMAdROVWgnStiwjdrdH3IEIAALiDqNxKkK7RiXD70iB8j5APywAAwJ1F5VaCdI10Rbi1eo/Q3hr93W8hQgAAuHOo3EqQrpGKcCOfLAMAAH1H5VaCdCFCAADoCCq3EqQLEQIAQEdQuZUgXYgQAAA6gsqtBOkaJxFmH7o9MznMPhum8UWESktaqB9prcQP0bb4o8FBTUbPvjakiXR8zSTPva6eml3hahx1c5gUokEBAHqLyq0E6Rr7FeHk5KT4pvkVCs2v5HW0ilDkImSkImqKk1aCPjW9xZrLyCmqSxKZ8W2F/25CSyhCczxs0JkycwEAQH9FOLMg7phqmHByOJU1RZsIjacm5hrSE5Kc0WBOQg05xYnc+K7C/OlVKBWr226FQwAA/UXlVoJ0jb0IzcIv9030c1NDb5eAFhE6T4UeqonllSlwNOQUJbLjVxXmZ1VaF1QdOaKhAQDAoXIrQbrGSYTZ9wit2KanhukX8IoJRS5NkeRF6P3UFJ1kAuk0jyvWZilVY3587zOvwvp4WhgOGM8VnB0AQJ9RuZUgXWO/InTI+k+3PAtii+Y7hVkRhtIJty2SCFTTOFzhraYEiZbxwxbrNtmpD2cmkpQrb8wFAAC9FaGsEWVR1FwpGnK3THMiFMEkhJap9ePICMqyggjbxo9bnAr9Z2eaE9VngggBADKo3EqQro6sCMUN+jNieip/KzXGeCrUSrJf60exwgoUteqnRlvHT1vsyH7sdCJ/Jo25AACgt+8RrszCTPreYVOEqafSTK2fAFNRoQcbcqoS7eM3fdZwn03URIr0hA0AAP1F5VaCdHVmRQgAAH1H5VaCdCFCAADoCCq3EqSrhyKcC25rGuKbkwAAMK6o3EqQLlaEAADQEVRuJUgXIgQAgI6gcitBuhAhAAB0BJVbCdKFCAEAoCOo3EqQLkQIAAAdQeVWgnQhQgAA6AgqtxKkCxECAEBHULmVIF2IEAAAOoLKrQTpQoQAANARVG4lSNc4iTD70O2ZyWH22TCNLyJUWtKCfZJ1MFT4YG3FHw0OarLxBO00kY6vmeSR2TJwlHA1jro5TAouHyf9IOmIplATpiU6o/zIgn+9cT0AwCZC5VaCdI39inByclIu5uF13tH8Sl5HqwiNHu5JvWAQB8RJKwWfWvVrmByZ8W2F/wJCS6gtczxs0JkycxmipDlH3QlHtJgzaRsnO3IwmCloHAcA2Byo3EqQrvEX4cyCXKenwgu9ZXI4lb1et4nQ2UGGymkgzIVWCGkoJE7kxncV5k9vKqlotVRN9lCc9DP5ERUpbJ0iN7KvBwDY1KjcSpCusRehWfjlvol+bmqYvXq3iLC62DesESrFkClwNBQSJbLjVxXmZ1VaF1QdOaKhK8Kk2a66G2fsR26Okx1ZRmgmAQA2HSq3EqRrnESYfY/Qim16aph+Aa+YUK7eTZHkRehl0dCGyQQWaB5XjEIaVI358b11bLPdrI+nheGA8Vw6SZgMT7FxxlKoCdNSnaIjO7IdI9oHANiMqNxKkK6xXxE6ZP2nW54FuaY33ynMijB0RcMbkggE0Dhc0ZBKkGgZP2yxBpKd+nBmIkm58sZcBp+UuuBwYyAp1ERznOzIijmGDQFgE6NyK0G6xl6EskaUi3NzpWjI3TLNidCIIya82Nf6cTS8ojQU4hNt48ct1jPBZ2eaE9Vn0pjLECbNjNV2o9gP3BwnO3JIODIAwOZC5VaCdHVkRShXcP0ZMT2Vv5Uak17bk33Zja78xhWholb91Gjr+GmLHdmPnU7kz6QxlyFKmp1onPqImT08Eo+TG1lyPiXt4SkBAGwiVG4lSNc4idC+RZhb+bWzMJO+d9gUYeqpNFPrJ8BUVOjBhkKqRPv4eQ9ForGJmkhtHpdORrM11X54vsHwzdGzI0fZ+IQBADYRKrcSpKszK0IAAOg7KrcSpAsRAgBAR1C5lSBdPRThXHCb0MC9PgCAbqByK0G6WBECAEBHULmVIF2IEAAAOoLKrQTpQoQAANARVG4lSBciBACAjqByK0G6ECEAAHQElVsJ0oUIAQCgI6jcSpAuRAgAAB1B5VaCdCFCAADoCCq3EqQLEQIAQEdQuZUgXeMkwuxDt2cmh9lnwzS+iFBpSQvRU6qF8EHVij+afQx18xnWAdHB8JjME5dKZeZh1zwBBwBgFVRuJUjX2K8IJycn78l9E33zK3kdrSI0+rkn/TYIg4gqTlo9BSn9HiZ3oM5XXzFR7wS2i0ZYWYTVIdMSlwEAQIzKrQTpGn8RziyISaYahpgcTkX2qmgToXNOQ3pCkjNGatQ44kO+T7YaLT4nW2sQYaYOAAAiVG4lSNfYi9As/HLfRD83Ncxqo0WElXIytpFUYLHITQmhCM22FuYNVmcbh/0U0WT5YQAAoELlVoJ0jZMIs+8RWrFNTw3TL+AVE8qSq+mNvAi9ZJq6kUwgwvC4kV34/p3fj26E5g1mim1b43BWhKY8MwoAANSo3EqQrrFfETpk/adbngVRR/OdwqwIQxc1vCSJFhEqdUHtNpPyTZkWoZZc43AkQvVq47M3AACQonIrQbrGXoSyRhRLNFeKhtwt05wIjbZiAvOZo8lu4qS6wIvQjZnbrvC5sMviZ/BKBACAVVG5lSBdHVkRijP0Z8T0VP5WakzqqWRfdiNP2WVa6Ke6IFKa2amq0ha7H1X6PTN70IcIAQDWisqtBOkaJxHatwhzK792FmbS9w6bIkw9mGZSERqsu2pC3wWlGd1VpHozM1bEwkSEAABrReVWgnR1ZkUIAAB9R+VWgnQhQgAA6AgqtxKkq4cinAtuQxoa9z0BAGAsUbmVIF2sCAEAoCOo3EqQLkQIAAAdQeVWgnQhQgAA6AgqtxKka2Qi/MTEYPB7g8HvDga/PRj81mDwocHg1weIEAAA7hgqtxKka5QivGvHHlaEAACwUajcSpAuRAgAAB1B5VaCdCFCAADoCCq3EqQLEQIAQEdQuZUgXaMUIR+WAQCADUTlVoJ0jdOKMPvQ7ZnJYfbZMI0vIlRa0kL8jOz4QdiKPxo+Qjv/XO30wdqtD92WeeJS/6jtqCd+lcHZhQdaZ3EHknMS7DirT2cPRancgNVLMYMGxaa0OTMAwKhRuZUgXeMkwiyTk5P35L6JvvmVvI5WEcrVWkiu/wa5qq8shektgUjqfCQDsxOoIBqhskeNOZN6wOqQaam2zWjBCdTzrzSL7Rf8YYMtCUVYHQ+nE8yR5JdjKrZsic+9filRe+MFAgCsDyq3EqRr/EU4syAX2qnGdXZyOBVctT1tInQSkKHCi70lyVkBZIdODvk+2Wq0+JxsxZ5wpxJvCVVdbjTDyrPYc5tIzt2OP1HPn53O4A5IJmi2A06bP3M9QT4cCABgPVG5lSBdYy9Cs/DLfRP93NQwe/ltEWHlgMxVu3H9b72sOzf4bS3Mm6DONg77KaLJtC4/2qqz6LlFVW7Hp3LTGap81KwD2p/Vqw4LdLsqAwBYf1RuJUjXKEW43h+Wyb5HaMU2PTVMv4BXTCjX5+qq7cmL0F/Bo4u9RTLBlTw8bh1gcQV+P7pF2RzSUBuicViOaMJv2XK7nR9t1VmqDSkLzlYzK0wn+IJwjnpku+U2o3OwBbIG9RkAgPVF5VaCdI1MhBv7rFFZ/+mWZ0EuxM13CrMiDC/g0cXcIAl3wbc0DgcF3g2S8k2ZFkGKXbZxuD7iFKNUNfnRVp2lPjezYVJ1vW/MTRcPHGzXA+q22UnOQXaDXwMAwHqjcitBusZehLJGlKttc6VoyN0yzYnQXrAjwqu3HE12w4u9UBeEbjBj5rYrfC7ssvgZ5FAyl+APx6x5FjuAf2dw9ekScqdt9hqfnTG96RkBAKwfKrcSpKsjK0K5EuvPiOmp/K3UGG8LR7KfXs3tNT+83tcFkRvMTlWVtjhthJV+z8we9EVicaSjVZ8aXXEWs1Ntmyn8EdnTptx0prY+N6HeDwc02NniX4wpDksAANYXlVsJ0jVOIrRvEeZWfu0szKTvHTZFmF7q00zuaq5XfaW6+CdusEX1ftSS+sbMWBEck56GmRxhQ3h2rbNE5xbtyFBamJku/lUYqkw0hsXOHQ0gtXEJAMB6onIrQbo6syIEAIC+o3IrQboQIQAAdASVWwnS1UMRzgV3FQ3cvAMA6AYqtxKka2QinPvSP//Au3/81//1j7//X771137+rf/9a6wIAQDgjqJyK0G6RibCD7z7Az+sV4Tf/LX3/dxbfucz30aEAABwx1C5lSBdIxPhk/Gt0V1//E9+9d99DBECAMAdQ+VWgnSNTIR8WAYAADYWlVsJ0oUIAQCgI6jcSpCuUYvwwMTH7Idl3vdzb/nVf/qPESEAANwxVG4lSNe6rQif/PjvIEIAALiDqNxKkC5ECAAAHUHlVoJ0jUyEyadGESEAANxhVG4lSNfIRNj8d4Qj/+cTw+Hws5/9rO5ULJ44PJzKPJd67qpuJGS/j9BinxkdPGYmfK614o/aYqXOhsnGg7Wjg+Ex/9BrRSo1EfVU07TNEuf9WfnXUaVWmdG/ylV+CQAAmwuVWwnSNTIRLn33A5vqyTIHX7qpWzGtIjQyuCf9QgWDuCBOWuMEqeprkGKLGIVEO4F7ohFW1lJ1yLS47bZZonxFeBZS4DZXnrE5iCAtuTQAwGZC5VaCdI1OhJvsn0/MfPtg9sLdJkLngtz1Psm1qUKID/k+2Wq0+JxsraAlf6iqa5sld2LRADUrz9gYxOCnAQDYtKjcSpCuzorw+b/4UEYBrSKsVNBwROqAvFocoUXMthZmxhTqbOOwnyKarKprmSXK10hTNrnCjM16QVpyaQCAzYTKrQTpGicRDofDwWDw4sUbut/OjdfefPP//kdRQHi1d+RF6NXQkETigPC4sYbDFfj96EZoc0hDrZzG4UhL1SFT7rZbZonygf1k+GhfWHnGqLRCWnJpAIDNhMrN8vh3nnro059vhuS1wiJdHVwR/ujG1d96XH6aa/rkTCq+rAhDMzQsETugcTgo8BaRlG/KtAi1fBqHYy1V1DUtswT5JjqQHl5lxtwg0tI2NgDAZkHlZrl8eWn6W08kFpSM5LXCIl3jK8KL548ePXv27PHjx5988smjZnvJvKA3b+x67EH9GOnc1L7D5+2WJ/dhUiOUmPCinzigYRFfEFrEjJnbrvC5hnv8DF5QAW2ztDmspi5eecbsIFKx4tgAAJsAlVvF+QsX/3rq8dqCsi0ZPVYhXR1cEa5M5rOkoU0MyX7qAOOKyIV1QWQRs1NVpS12P6r0e2b2oC+cyGHKc7NEeUVyPiUjB6WtMzYGMaS/BACATYjKLUDWf4/96V+JBR/9/J9fvHhJswHS1TsR2lVjhPFAfJGPMzkHWJPUtFgk1k3UkurNzFgRHJOetLJ9lmiCepgwG76M9hk1afAHcr8EAIBNhsotRvz3pa984/Tps7ofI129EyEAAHQVlVsJ0oUIAQCgI6jcSpCuHoowvClo4JYfAEA3ULmVIF2sCAEAoCOo3EqQLkQIAAAdQeVWgnQhQgAA6AgqtxKkCxECAECv2XQiJAiCIIg7HCqhtbG+IgQAANjkIEIAAOg1iBAAAHoNIgQAgF6DCAEAoNcgQgAA6DWIEAAAeg0iBACAXoMIAQCg1yBCAADoNYgQAAB6DSIEAIBegwgBAKDXtIrwJz/91bd/6ivv/vZxEeHWL33hJx774UhFOL1lcM/EnO5kmJu4ZyBsmbal5gcAAMA6sNKKcP/ffOPtD/3N12RF+P0dP/GRr//pyEQoasvgxKgGrN1n9vEgAACsFyuJ8PLRne9+6Ot/eOjc/PzTD3zkc/9hegQidJ5LzSbZaH0o+66k0mLAigtJAACAMlpF6G6Nvl1FOP/EX335bX/y3dsUodGa9dj0lkBn0V3SpvkiaXKbFAAARssaV4Tzx3Z/+5/957+8/RVhhbk7KkrTHym176YnrCJ1xag/AAAARsaKItz9nXpFeOzY/o9/6n+MToS69Msv74wehWidiAEBAGA9aBfh8af/TXBr9NixY//vzx8biQhVcw0q1c1NbNmyxbxHaG+g2sWhFeG0qDMvTgAAgFulVYQ/+emp/3n04G8+9KUPPaUifP7Jb96mCJ0C7xGay7vqbcPKeXpr1N0jrVaEsptpBQAAuGXaV4TNf1B/2yJ05O9zViKc3iLmkxL3py4BfQsqBACAkVIgwlHdGjV+yxEIzonQ40UIAAAwUtYmwmf/9l985HNv+9SdWBFaAhG626ltH6sBAAC4PQpWhFIxEhECAABsHhAhAAD0GkQIAAC9BhECAECvQYQAANBrECEAAPQaRAgAAL0GEQIAQK9BhAAA0GsQIQAA9BpECAAAvQYRAgBAr0GEAADQa9ZXhNu/toMgCIIg7nCohNbGuotQtwAAAO4IiBAAAHoNIgQAgF6DCAEAoNcgQgAA6DWIEAAAeg0iBACAXoMIAQCg1yBCAADoNYgQAAB6DSIEAIBesx4iPPjJ9/zmW971wb/3zgcQIQAAbHJGJsIPfMuJcPbhX/jwWz/8XVaEAAAwFox6Rbjjsbf+9P/6c26NAgDAmDBiEe7944ff+tMffutd3BoFAIDxYB1E+Atff4oVIQAAjAkjFqG9NfrJT+5EhAAAMB6MTIQ//l92+Q/LvGfb925VhARBEARxh0MltDZWWxHe3j+fAAAA2OSsRYS3/g/qAQAANjmIEAAAeg0iBACAXoMIAQCg1yBCAADoNYgQAAB6DSIEAIBegwgBAKDXIEIAAOg1iBAAesHXvjnd7dDXuTb+U9fR17k2ECEA9AJRxbXucgsilKt6V0GEAAAZEGEIIgxBhADQCxBhCCIMQYQA0AsQYQgiDEGEANALEGEIIgxBhADQC25FhPu2fvzjW/dVWw3coRU48fijq9aMhjsvwsd+cRDzjt//rh5aHdP8i4/Zjartu7//DpsJt24VRAgAkOEWV4TislB4IsQCtcUiNEN5RmvIjVgRirDUYlZdiRlX9aLUm5pKe8HPEqVmQYQAABluUYQxa/dgbD3rPUk9+viJ6mjnRFirzCXWbrOwOxjjNkCEAAAZbkGEoj1nruyN0TUs6ipvOu91UIS6+hOMvvx9Tr+VRReDEaNRoAMRAgBkuLUVYe1Cv13ZbQ10XoTRitC7bA1SkxIjT/Mjw20qERECAGS4NRFWiNK8EUVjfmclKhHu22rKOyhC9ZZg1aUCXIMHK6R0HdaGiBAAIMMtrwi3Pu695wVmZLjayrA2X2dFGK8IdWNNItNm+aEmjUCEAACj55ZE6N3ltozAxIuPPv74Wu6P1jdRuyzC4MOiRl9mt7HGyyB1plx9GLEmka4IIgQAyHBLInQGsxvWaVZgVmj7ZEW4istqD7aKUH64tWZzo5A7LsJ6Kac6U3U5La7uMfWgHyYGEQIAjJ5bEaH6yvx0dnIJt1sn84gGq8NaKT/046aGMRdhhBOhkZpd3pmNlVUmFW4hWG8EuNFuB0QIAJDhFkSoAnOI2AxrtFTVGnYFw8mmLhZHxIaLMFnHrexCfzQUoY4iNNxYCCIEAMhwKyvC8WFjRbjZQIQAABkQYQgiDEGEANALEGEIIgxBhADQCxBhCCIMQYQA0AsQYQgiDEGEANALRBXdDn2da0NU0W30da4NRAgAAL0GEQIAQK9BhAAA0GsKRPjcc88hQgAA6BihCOfm5l588cW8CI8ePYoIAQCge4jaZmZm9u3bJ5pzIjx16pSKcHFxERECAEC3WUmErAgBAKDzrFWEvEcIAACdRNS2pvcI+dQoAAB0klCE0adGr1y5IiJcWFg4f/48IgQAgK4iatu1a9f+/fsPHTp09OhREeHp06fPnj1rRCiLwlCEUoEIAQCgY4jann766WeffXZ2dlZkd/LkyUiEi4uLFy5ckNTx48elAhECAEDHELXt3r37wIEDhw8fFtmdOnXqzJkz586dG7z88sviQidCSclSUSoQIQAAdAxR2549ew4ePHjkyJH6kzLnz59XEbrPy8gKUZaKc3NziBAAADqGqG3fvn3JG4SyCBxcvXpVXOjeJqz/KSEiBACAjiFqe/bZZw8fPnzs2DH3LwjFehcvXlQR1ndH5YB4UqoJgiAIomMR/gtCtxy8dOnS4Nq1a/XdURGjHJDDx48fP3LkiKwfDx48uH//fllL7tmzZ/fu3U8//fSuXbtmZmaeeuqpJ5988ocAAACbDNGTSEpUJcISbYm89u7dKy577rnnRG3u86LuYzIiwoWFhcH169dlUeg+Oyr7knUuFGEePXpUzDk7OysKlf4DBw7IQM8884yMKDg1AgAAbCpET85TIizRlshLLCYuE6OF/2rCLQcXFxcHN27cCBeFtQul7tSpU6JDaXvhhRek//Dhw7JGlOFkmSjI0M8CAABsMkRPzlMiLNGWyEssJku748ePOwu6D4tevHhRlCfiMyJ0i0L3kRn38VFxoawZpVSWhqLDEydOSH9tRFlayrhiVwAAgM2ACM/hdkVSoioRlmhL5CWLOhGZ6MytBUMLivgGN2/ebLpQDkuRlEqD6FA6xYgiUhlIhnNSFLvKBAAAAJsK0ZNISlTl/CfyEoW5hWDTgiK+wSuvvOJceO3atcSF9dIw1KEY1RnRSREAAGBT4QwlqhJhhQp0n44RtYUWFPENXn31VedCWRQ6F7oPziwuLtYuFH/WOjxz5owM6qQIAACwGRDnOdyu85QIq1agiKy2oAhONCeyE+Vdu3bt/wMPVPKxtinyTQAAAABJRU5ErkJggg==) ### NuGet packages | 包名称 | 包说明 | 状态 | | ---- | ------- | ------ | | Standard.EntityLayer | 实体模型包 | [![NuGet version](https://badge.fury.io/nu/Standard.EntityLayer.svg)](https://badge.fury.io/nu/Standard.EntityLayer) | | Standard.DataAccess | 基础数据库持久包 | [![NuGet version](https://badge.fury.io/nu/Standard.DataAccess.svg)](https://badge.fury.io/nu/Standard.DataAccess) | | Standard.SqlClientAccess | SQL Server 数据库持久类支持包 | [![NuGet version](https://badge.fury.io/nu/Standard.SqlClientAccess.svg)](https://badge.fury.io/nu/Standard.SqlClientAccess) | | Standard.MySqlAccess | MySql 数据库持久类支持包 | [![NuGet version](https://badge.fury.io/nu/Standard.MySqlAccess.svg)](https://badge.fury.io/nu/Standard.MySqlAccess) | | Standard.OracleAccess | Oracle 数据库持久类支持包 | [![NuGet version](https://badge.fury.io/nu/Standard.OracleAccess.svg)](https://badge.fury.io/nu/Standard.OracleAccess) | | Standard.PostgreAccess | PostgreSQL 数据库持久类支持包 | [![NuGet version](https://badge.fury.io/nu/Standard.PostgreAccess.svg)](https://badge.fury.io/nu/Standard.PostgreAccess) | ### 不使用分布式事务 ```c# using(xxxAccess access = new xxxAccess(connectionstring)) { access.Create(entity); await access.CreateAsync(entity); await access.BatchAsync(entity); await access.BulkCopyAsync(DataTable); } //使用 Lambda 表达式查询数据 using(xxxAccess access = new xxxAccess(connectionstring)) { var queries = access.GetEntities(0,0); queries.Where(m => m.Enabled == true).Where(m => m.Key >= 1); return queries.ToPaginationAsync(); } ``` ### 使用分布式事务(xxxContext.cs) ```c# using(xxxAccess access = new xxxAccess(connectionstring, true)) { access.Create(entity); or await access.CreateAsync(entity); access.SetComplate(); } using(xxxAccess access = new xxxAccess(connectionstring, TimeSpan.FromSeconds(60))) { access.Create(entity); or await access.CreateAsync(entity); access.SetComplate(); } ``` ### 使用日志 在 Program 文件中设置应用停止时缓冲区没有写入的日志信息 ```c# app.Lifetime.ApplicationStopping.Register(() => { LoggerWriter.FlushAllAsync(); }); ```