Allow dapper to support Oracle

The previous project data used MSSQL and MySQL, and the orm used a lightweight dapper, which was very convenient and had better performance than ef. The key was the flexible syntax and ease of use, I feel very good when I develop several websites using this framework.

However, if Oracle is to be used in the new project, a problem occurs. The keyword "@" in dapper is not supported in the Oracle database. After checking some information, you should change "@" to ": ", because the keyword in the Oracle database is": ", it is still not supported and cannot be modified by yourself. The effect after the transformation is as follows.

In addition, there are many experts in the garden under the project framework, and I hope to give you some advice on the shortcomings.

After the webapp is expanded, the effect is as follows.

Shows the expanded commonlibrary.

The entity layer and Dal are automatically generated using code Smith.

The interaction with other systems is based on WCF and uses ESB.

This project is a company asset and does not provide source code. However, if you have other small projects, contact me if you need it.

Please be highly recommended.

 

In my spare time, I am developing a website: www.urlshou.com to facilitate the quick collection and archiving of various websites. You are welcome to use it and give more valuable comments.

 

Add the code Smith template file as required by Boyou to facilitate entity generation and Dal. Click to download.