Devart Forums

Code: Select all

CREATE DATABASE foodb1;

CREATE TABLE foo (
    id integer NOT NULL primary key,
    name text
);

Code: Select all

public partial class foo {

        public foo()
        {
            OnCreated();
        }

        public virtual int id
        {
            get;
            set;
        }

        public virtual string name
        {
            get;
            set;
        }
    
        #region Extensibility Method Definitions

        partial void OnCreated();
        
        #endregion
    }

Code: Select all

public partial class FoodbModel : DbContext
    {
        private readonly string _host;
        private readonly int _port;
        private readonly string _database;
        private readonly string _user;
        private readonly string _passWord;

        public FoodbModel(string host, int port, string database, string user, string passWord) :
            base()
        {
            _host = host;
            _port = port;
            _database = database;
            _user = user;
            _passWord = passWord;
            OnCreated();
        }

        //public foodbModel(DbContextOptions<foodbModel> options) :
        //    base(options)
        //{
        //    OnCreated();
        //}

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            var connectionString = new PgSqlConnectionStringBuilder()
            {
                Host = _host,
                Database = _database,
                Port = _port,
                UserId = _user,
                Password = _passWord,
                LicenseKey = "PUT_YOUR_LICENCE_KEY_HERE"
            }.ConnectionString;

            if (!optionsBuilder.Options.Extensions.OfType<RelationalOptionsExtension>().Any(ext => !string.IsNullOrEmpty(ext.ConnectionString) || ext.Connection != null))
                optionsBuilder.UsePostgreSql(connectionString);
            CustomizeConfiguration(ref optionsBuilder);
            base.OnConfiguring(optionsBuilder);
        }

        partial void CustomizeConfiguration(ref DbContextOptionsBuilder optionsBuilder);

        public virtual DbSet<foo> foo
        {
            get;
            set;
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            this.fooMapping(modelBuilder);
            this.CustomizefooMapping(modelBuilder);

            RelationshipsMapping(modelBuilder);
            CustomizeMapping(ref modelBuilder);
        }
    
        #region foo Mapping

        private void fooMapping(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<foo>().ToTable(@"foo");
            modelBuilder.Entity<foo>().Property<int>(x => x.id).HasColumnName(@"id").HasColumnType(@"int4").IsRequired().ValueGeneratedOnAdd();
            modelBuilder.Entity<foo>().Property<string>(x => x.name).HasColumnName(@"name").HasColumnType(@"text").ValueGeneratedNever();
            modelBuilder.Entity<foo>().HasKey(@"id");
        }
	
        partial void CustomizefooMapping(ModelBuilder modelBuilder);

        #endregion

        private void RelationshipsMapping(ModelBuilder modelBuilder)
        {
        }

        partial void CustomizeMapping(ref ModelBuilder modelBuilder);

        public bool HasChanges()
        {
            return ChangeTracker.Entries().Any(e => e.State == Microsoft.EntityFrameworkCore.EntityState.Added || e.State == Microsoft.EntityFrameworkCore.EntityState.Modified || e.State == Microsoft.EntityFrameworkCore.EntityState.Deleted);
        }

        partial void OnCreated();
    }

Code: Select all

class Program
    {
        static void Main(string[] args)
        {
            try
            {
                //database foodb2 doesn't exists at localhost:5434
                using (var fooMd1 = new FoodbModel("localhost", 5434, "foodb2", "postgres", "put_password_here"))
                {
                    fooMd1.foo.Add(new foo() { id = 1, name = "Test 01" });
                    fooMd1.SaveChanges();
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.ReadKey();
            }

            //Try connect in another database

            try
            {
                //database foodb3 doesn't exists at localhost:5434
                using (var fooMd2 = new FoodbModel("localhost", 5434, "foodb3", "postgres", "put_password_here"))
                {
                    fooMd2.foo.Add(new foo() { id = 2, name = "Test 02" });
                    fooMd2.SaveChanges();
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                Console.ReadKey();
            }
        }
    }

Code: Select all

	
SELECT

	  a.conname as CONSTRAINT_NAME,

	  ns.nspname as CONSTRAINT_SCHEMA,

	  mycl.relname as TABLE_NAME, 

	  b.conname as REFERENCED_CONSTRAINT_NAME,

	  frns.nspname as REFERENCED_SCHEMA,

	  frcl.relname as REFERENCED_TABLE_NAME,

	  a.confupdtype as UPDATE_RULE,

	  a.confdeltype as DELETE_RULE, 

	  b.contype as REFERENCED_CONSTRAINT_TYPE

	,

	  a.conkey as CONSTRAINT_KEY_INDEXES,

	  a.confkey as REFERENCED_CONSTRAINT_KEY_INDEXES

	FROM 

	  pg_constraint a

	INNER JOIN

	  pg_constraint b ON (a.confrelid = b.conrelid AND a.confkey @> b.conkey AND array_length(a.confkey, 1) = array_length(b.conkey, 1))

	INNER JOIN 

	  pg_namespace ns ON a.connamespace= ns.oid

	INNER JOIN 

	  pg_class mycl ON a.conrelid = mycl.oid

	LEFT OUTER JOIN 

	  pg_class frcl ON a.confrelid = frcl.oid 

	INNER JOIN pg_namespace frns ON frcl.relnamespace= frns.oid

	WHERE a.contype = 'f' 

	  AND (b.contype = 'p' OR b.contype = 'u')

	AND

	  ns.nspname = frns.nspname

	AND

	  ns.nspname = 'public'