[open source]. Net uses ORM to access Shenzhou general database (Shentong)

preface Tianjin Shenzhou General Data Technology Co., Ltd. (hereinafter referred to as "Shenzhou general company") is subordinate to China Aerospace Science and Technology Corporation (CASC). Is engaged in the domestic database, big data solutions and data mining analysis product research and development of professional companies. The ...

Posted by cbailster on Sat, 27 Jun 2020 17:55:00 -0700

FreeSql uses ToTreeList/AsTreeCte to query infinite level classification table

On infinite class The first option: Recursion algorithm is also the most frequently used, and most open source programs do the same, but generally only use four levels of classification. The database structure design of this algorithm is the simplest. A field ID and a field FID (parent id) in the category table. In this way, we can judge the up ...

Posted by jwoo on Sat, 27 Jun 2020 17:13:04 -0700

Production environment database backup scheme

1, Introduction After the product goes online, our data is very important. It's not allowed to be lost. We should be well prepared. If one day is hacked or deleted maliciously, it will crash. So we need to do full backup and incremental backup for our online database regularly. For example, make incre ...

Posted by lauxanh on Sat, 27 Jun 2020 01:35:14 -0700

Spring Security's remomberme automatic login

Automatic login is a mechanism that saves the user's login information in the cookie of the user's browser. When the user visits next time, it automatically realizes the verification and establishes the login state. Spring Security provides two very good types of Tokens: Hash algorithm encrypts user's necessary login information and generates ...

Posted by exec1 on Sat, 27 Jun 2020 01:18:49 -0700

Triggers and views in MySQL

The keyword "delimiter" is used to declare the delimiter of SQL statement and tell mysql interpreter whether the command has ended and whether mysql can be executed. By default, delimiter is a semicolon;. In the command line client, if a line of commands ends with a semicolon, mysql will execu ...

Posted by danielrs1 on Fri, 26 Jun 2020 18:30:09 -0700

SQL Base Notebook 2 View Stored Procedure

  View CREATE/ALTER/DROP VIEW ViewName as SELECT(...) You can continue to create a view based on it, that is, you can place the previously created view as a table name in the select statement of the new view Format data using views (that is, reassemble and stitch fields) CREATE VIEW View_player_team AS SELECT CONCAT(player_name, '(' , t ...

Posted by Izzy1979 on Fri, 26 Jun 2020 09:58:46 -0700

How to recover page level in SQL Server

In today's article, I want to talk about an important topic that every DBA should know: how to perform page level restore operations in SQL Server. Suppose you have a damaged page in SQL Server. You want to restore only the page in question from the latest database backup, not the entire database. 1 ...

Posted by Cut on Fri, 26 Jun 2020 01:43:33 -0700

My first ASP.NET Project summary

My first ASP.NET Project summary Recently, I was busy at the end of the term and didn't have time to update my blog. Here's one I'll do for myself ASP.NET Project (equipment management system) to summarize, the page template is the master, which greatly reduces the amount of code. Finally, the source code and database of the project are atta ...

Posted by stanleyg on Thu, 25 Jun 2020 23:34:59 -0700

Design of universal interface for accessing c + + relational database (JSON-ORM c + +)

Re operate the old c + + business and get used to the usual database operation mode, so take the time to encapsulate a C + + version of JSON orm. Now it supports sqlit3 and mysql, and postgres is ready. Design ideas Our general ORM, the basic pattern is to want to break away from the database, almost all in the programming language level model, ...

Posted by thedarkwinter on Thu, 25 Jun 2020 22:42:57 -0700

Akka typed - cqrs read write separation mode

Event source and cluster are introduced earlier. Now it's time to discuss CQRS. CQRS is the mode of separation of reading and writing, which is composed of independent writer program and reader program. The specific principle has been introduced in previous blogs. Akka typed should naturally support ...

Posted by dustbuster on Thu, 25 Jun 2020 19:26:59 -0700