CRL is an object-oriented lightweight ORM business framework
Data processing uses Object/Data ing, and data operations are expressed using lamada expressions. This increases the programmability and reliability, reduces the chance of errors, and enables queries or operations using native SQL.
Data connections are configured programmatically and support multiple databases. See the implementation in global. asax. Change the data connection in localsqlhelper. createdbhelper for the first time.
Business reuse is achieved through encapsulation and Inheritance of business objects. Common packages include: Member/account system, Dictionary configuration, classification system, online payment, order/shopping cart, permission verification/menu system, etc. Of course, you can also write your own business encapsulation.
Efficiency problem: cache processing is performed on Object ing, and the query efficiency is almost the same as that of handwritten SQL. Note: The default query efficiency for CRL objects is with (nolock)
Dynamic stored procedures support and query conversion, greatly reducing database maintenance and increasing development efficiency
Log binding: an error occurs when data is operated through CRl. A corresponding error log is generated, including the executed statements and parameters.
CRL depends on corehelper. dll. This dll is a function class library, including data access and logging.
More functions and implementations will be added later. The current version isDebugVersion 2.0 is only available in a small range. If you have any questions or suggestions, contact me.
Supported databases: SQL2000 and above (other databases can be sorted out after time). Net Framework 3.5 and above are recommended to be used with MVC. object-oriented development saves a lot of trouble
Test Project/example click to download
Test Project Preview