Is there a way to specify port on the connection string?

[OutOfTouch6947]

I was wondering if there is a way to specify port the connection string?

I have another question not sure if it belongs here or EntityDeveloper section.

I just converted an application that was using EntityDeveloper with LinqToSql to use EnityDeveloper and DotConnect for PostgreSQL.

My app stores the connection string enrypted in the web.config and it was retrieving it and decrypting it and setting the base Connection objects connect string to this value in the DataContext OnCreated() method, I created my own partial class to do this so that when the model regenerated I don't lose this code. Problem is this Connection in old code was of type Devart.Data.Linq.DataContext.Connection this now needs to be PgSqlConnection but I don't see where this is created so that I can do the same as before.

Code: Select all

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using Stauer.Utilities.Encryption;

namespace DigitalPaperOrderContext
{
    public partial class DigitalPaperOrderDataContext
    { 

        partial void OnCreated()
        {
            //Decrypt the connection string here and set the base connection string to this value.
            string pwd = "somePassword";
            string connString = WebConfigurationManager.ConnectionStrings["DigitalPaperOrderEncrypted"].ConnectionString;
            connString = AESGCM.SimpleDecryptWithPassword(connString, pwd);
            Connection.ConnectionString = connString;
            this.CommandTimeout = 120;
        }

    }
}

I am not sure if this code will still work or how DevArts code interjects it's PgSqlConnection in place of the Devart.Data.Linq.DataContext.Connection object.

[Shalex]

I was wondering if there is a way to specify port the connection string?

1. Please set the port number via the Port connection string parameter: https://www.devart.com/dotconnect/postg ... tring.html.

Problem is this Connection in old code was of type Devart.Data.Linq.DataContext.Connection this now needs to be PgSqlConnection but I don't see where this is created so that I can do the same as before.

2. The question is not clear.

LINQ to SQL template works with System.Data.Linq.DataContext, its metadata:

Code: Select all

namespace System.Data.Linq {
    public class DataContext : IDisposable {
        public DataContext(string fileOrServerOrConnection);
        public DataContext(IDbConnection connection);
        public DataContext(string fileOrServerOrConnection, MappingSource mapping);
        public DataContext(IDbConnection connection, MappingSource mapping);

        public ChangeConflictCollection ChangeConflicts { get; }
        public int CommandTimeout { get; set; }
        public DbConnection Connection { get; }
[...]

LinqConnect template works with Devart.Data.Linq.DataContext, its metadata:

Code: Select all

namespace Devart.Data.Linq {
    public class DataContext : IDisposable {
        public DataContext(IDbConnection connection);
        public DataContext(string persisterConfigData);
        public DataContext(IDbConnection connection, MappingSource mapping);
        public DataContext(string connectionString, MappingSource mapping);

        public ChangeConflictCollection ChangeConflicts { get; }
        public int CommandTimeout { get; set; }
        public DbConnection Connection { get; }
[...]

Constructors of both DataContexts accept connectionString of the System.String type. Why can't you pass connection string to the constructor of Devart.Data.Linq.DataContext? If you receive some error, please specify its exact text and full stack trace.

[OutOfTouch6947]

I was wondering if there is a way to specify port the connection string?

1. Please set the port number via the Port connection string parameter: https://www.devart.com/dotconnect/postg ... tring.html.

Problem is this Connection in old code was of type Devart.Data.Linq.DataContext.Connection this now needs to be PgSqlConnection but I don't see where this is created so that I can do the same as before.

2. The question is not clear.

LINQ to SQL template works with System.Data.Linq.DataContext, its metadata:

Code: Select all

namespace System.Data.Linq {
    public class DataContext : IDisposable {
        public DataContext(string fileOrServerOrConnection);
        public DataContext(IDbConnection connection);
        public DataContext(string fileOrServerOrConnection, MappingSource mapping);
        public DataContext(IDbConnection connection, MappingSource mapping);

        public ChangeConflictCollection ChangeConflicts { get; }
        public int CommandTimeout { get; set; }
        public DbConnection Connection { get; }
[...]

LinqConnect template works with Devart.Data.Linq.DataContext, its metadata:

Code: Select all

namespace Devart.Data.Linq {
    public class DataContext : IDisposable {
        public DataContext(IDbConnection connection);
        public DataContext(string persisterConfigData);
        public DataContext(IDbConnection connection, MappingSource mapping);
        public DataContext(string connectionString, MappingSource mapping);

        public ChangeConflictCollection ChangeConflicts { get; }
        public int CommandTimeout { get; set; }
        public DbConnection Connection { get; }
[...]

Constructors of both DataContexts accept connectionString of the System.String type. Why can't you pass connection string to the constructor of Devart.Data.Linq.DataContext? If you receive some error, please specify its exact text and full stack trace.

Can you provide me an example of overriding the constructor and setting the connection string in a partial class.

[Shalex]

There is no way to override a constructor from a partial class. Please define a constructor with a new set of parameter(s), for example:

Code: Select all

    class Program {
        static void Main(string[] args) {
            using (var connection = new Devart.Data.PostgreSql.PgSqlConnection()) {
                connection.ConnectionString = your_method_to_get_decripted_connection_string();

                using (var context = new YourDataContext(connection)) {

                    var a = context.Depts.ToList();
                }
            }
        }
    }

    public partial class YourDataContex : Devart.Data.Linq.DataContext {
        public YourDataContex(Devart.Data.PostgreSql.PgSqlConnection conn) : base(conn) { }
    }

[OutOfTouch6947]

There is no way to override a constructor from a partial class. Please define a constructor with a new set of parameter(s), for example:

Code: Select all

    class Program {
        static void Main(string[] args) {
            using (var connection = new Devart.Data.PostgreSql.PgSqlConnection()) {
                connection.ConnectionString = your_method_to_get_decripted_connection_string();

                using (var context = new YourDataContext(connection)) {

                    var a = context.Depts.ToList();
                }
            }
        }
    }

    public partial class YourDataContex : Devart.Data.Linq.DataContext {
        public YourDataContex(Devart.Data.PostgreSql.PgSqlConnection conn) : base(conn) { }
    }

I must have misunderstood you before when you said use the constructor I thought you implied overriding it which I also know there is no way to do that from a partial class.
This approach you suggested here is good, I will consider changing to it from what I am currently doing in the OnCreated() method.
Thank You for the help.