EF Core helps Xinchuang domestic database

EF Core helps Xinchuang’s domestic database

Foreword

As an important link in localization substitution, domestic databases have accelerated development under the guidance of my country’s Xinchuang Industrial Policy. Our domestic databases have entered a period of rapid development where a hundred flowers are blooming. I believe I am especially familiar with children’s shoes that come into contact with government projects. At the same time, some of us are also using various open source ORMs that have already supported mainstream domestic databases. Some of us are also using official EF Core but do not have unified management and management of domestic databases. Support, last year I wrote an article on how to use EF Core to adapt and support Renmin University of Finance and Economics. In this case, I will use my spare time at work to adapt it and open source it, so that everyone can contribute together

Introduction to Renmin University of Finance and Economics and Huawei Gaussian Database

The bottom layer of Renmin University of Finance and Economics and Huawei’s Gaussian database are both based on PostgreSQL. There will be no further elaboration on the features that will be added based on the database itself. You can go to the official website to learn more. . The features I am talking about here only describe the basic features of our tables, which are also needed for our operations of adding, deleting, modifying, and checking. According to my understanding, Renmin University of Finance and Economics is constantly adapting to new versions of PostgreSQL. The latest version should be It is PostgreSQL 12.0, so for the new version of NPC, we may directly use Npgsql, but for the old version, it may not work. Of course, some of the new features of the new version of PostgreSQL will naturally correspond to NPC. Inherited, such as primary key auto-increment, newly added in PostgreSQL 10.0, corresponding to NPC Jincang itself, corresponding expansion of column types, etc. The bottom layer of Huawei Gauss Database has been stuck in PostgreSQL 9.2.4. Therefore, the self-increasing primary key Identity newly added in PostgreSQL 10.0 cannot be supported. It can only be created through Squence. This can also be confirmed through the OpenGaussDB official website.

Supports Renmin University of Finance and Economics and Huawei Gaussian database

Under my current superficial understanding, Xinchuang’s domestic database Renda Jincang and Gaussian database are more prominent, so I have given priority to adapting to Renda Jincang EF Core 6 .x and Huawei Gaussian EF Core 8.0 versions have been released to NuGet. The open source addresses are our native .NET NCC community: https://github.com/dotnetcore/EntityFrameworkCore.KingbaseES and https://github.com/dotnetcore/ EntityFrameworkCore.GaussDB. For specific usage, please see README

Follow-up plan

Next, we will support Gaussian 6.0/7.0 and Renmin University of Finance and Economics 7.0/8.0. As for the release time, no one mentioned ISSUE, so it depends on my personal free time. If necessary, corresponding priority adjustments will be made based on specific feedback. I still hope that more colleagues can participate. I mean joint participation and contribution, rather than mentioning ISSUE. After all, my personal time and energy are limited, haha

Basic specifications for ISSUE processing

By the way, the problem may need to be reproduced, please allow me to say it in advance: Guys, I’m going to need a concrete code sample which reproduces the issue , otherwise I’m not going to be able to investigate. If you throw in a bunch of code that has nothing to do with the problem, and you still need me to build various environments and peel off the cocoons, I’m sorry, I will ignore it. Of course, if you pay by the hour, It’s not impossible. I’m happy to build it even if it takes a week. This is a great honor for me

Translation

Search

Copy

What you see is not the thing itself, but the meaning given by interpretation.