The method for connecting to the PostgreSQl database by using Abp. nhib.pdf,

The method for connecting to the PostgreSQl database by using Abp. nhib.pdf,

You can connect to the PostgreSQl database using the dynamic library of Abp. nhib.pdf. The specific content is as follows:

When I first came into contact with the Abp framework, the methods encapsulated in the framework for operating various types of data are still very useful. I am still learning about it and will use it. the methods used to operate PostgreSQL data in the nhib.pdf class library are recorded. If there are any deficiencies, let the comments give pointers and throw bricks.

If you don't talk much about it, simply start:

1. vs create a project (Form, console program, or test program)

2. NuGet obtains the class library (adp. nhib.pdf)

You also need to install a driver corresponding to pgSQl

3. Create a class that inherits the AbpModule to configure the database connection information and object ing information.

Using System. reflection; using Abp. configuration. startup; using Abp. modules; using Abp. nhib.pdf; using fluentnhib.pdf. cfg. db;/*** namespace: abpPgtest * function: Configure database * Class Name: NhHibernateModel * OPERATOR: Dong Teng * Time: 17:04:27 */namespace abpPgtest {[DependsOn (typeof (AbpNHibernateModule)] public class NhHibernateModel: AbpModule {// override PreInitialize method public override void PreInitialize () {var pgStr = "Server = localhost; Port = 5432; Database = DTDB; User Id = DT; Password = DT"; var config = Configuration. modules. abpnhib.pdf (). fluentConfiguration. database (PostgreSQLConfiguration. standard. connectionString (pgStr); config. mappings (a =>. fluentMappings. addFromAssembly (Assembly. getEntryAssembly (); // base. preInitialize ();} // rewrite the Initialize method public override void Initialize () {IocManager. registerAssemblyByConvention (Assembly. getCallingAssembly (); // base. initialize ();}}}

4. Create object and object ing

Using System; using System. collections. generic; using System. linq; using System. text; using System. threading. tasks; using Abp. domain. entities; using Abp. nhib.pdf. entityMappings;/*** namespace: abpPgtest. testModel * function: Database Table entity and ing * Class Name: testModel * OPERATOR: Dong Teng * Time: 17:21:19 */namespace abpPgtest. testModel {public class testModelMap: EntityMap <testModel> {public testModelMap (): base ("dt_tb_test") {// Id (x => x. id ). generatedBy. increment (); // an Id Map (x => x. company); Map (x => x. name); // References <userModel> (a =>. id ). not. lazyLoad (). column ("foreign key ID"); // used when there is an associated table in the database} public class testModel: Entity <int> {public virtual int Id {get; set ;} public virtual string Name {get; set;} public virtual string Company {get; set ;}}}

5. Create a table dt_tb_test in the database.

6. Register and initialize the abp connection

var bootstrapper = AbpBootstrapper.Create<NhHibernateModel>();bootstrapper.Initialize();var resp = bootstrapper.IocManager.Resolve<IRepository<testModel>>();

7. add data to the database

// Add data var model = new testModel {Name = "Dong Teng", Company = "Dong teng technology"}; resp. Insert (model );

Open the database to view the results:

8. Update Data

// Update the data var m = resp. Get (1); m. Name = "Dong Teng 1"; resp. Update (m );

View results

9. query data

Query all data

var allList = resp.GetAllList();

Query by condition

10. delete data (you can delete data in multiple ways by using the id or where condition)

// Delete data. The where condition is used to Delete Expression <Func <testModel, bool> where = a => a. Id = 3; resp. Delete (where );

A Data Entry with id 3 is deleted.

11. Conclusion:

Abp. NHibernate is only an encapsulation of NHIbernate In the ABP. As long as the database is correctly registered and accessed, the rest is the ORM operation, which is simple. Other relational data can be used in a similar way.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.