Best practice for establishing SDE Connection once in session for ArcGIS Pro Add-in?

succip — Tue, 10 Jan 2023 17:55:05 GMT

Hello,

I'm developing an add-in with a range of tools and many of them access our SDE database (mostly for reading but sometimes writing). I've been told I should only access it once per session but I'm wondering if there's any examples on the best practice for this.

Currently I've separated it out into a "Data" class, but my implementation feels overcomplicated because I want it to use a different connection string based on the development or production build. Does anyone have any guidance here? Any examples in the documentation?

Here's my current Data class:

public static class Data { private static DatabaseConnectionProperties _dbConnectionProperties = new DatabaseConnectionProperties(EnterpriseDatabaseType.Oracle) { AuthenticationMode = AuthenticationMode.DBMS, User = GetCredential("user"), Password = GetCredential("password"), Instance = GetCredential("instance") }; public static DatabaseConnectionProperties dbConnectionProperties { get { return _dbConnectionProperties; } } private static Geodatabase _sdeGeodatabase = new Geodatabase(_dbConnectionProperties); public static Geodatabase SDEGeodatabase { get => _sdeGeodatabase; } private static string GetCredential(string credential) { DbConnectionStringBuilder dbConnectionStringBuilder = new DbConnectionStringBuilder(); dbConnectionStringBuilder.ConnectionString = Settings.ConnectionString; if (credential == "user") return dbConnectionStringBuilder["User ID"].ToString(); if (credential == "password") return dbConnectionStringBuilder["Password"].ToString(); if (credential == "instance") return dbConnectionStringBuilder["Data Source"].ToString(); return null; } }

Thanks in advance.

Re: Best practice for establishing SDE Connection once in session for ArcGIS Pro Add-in?

RichRuh — Tue, 10 Jan 2023 23:35:50 GMT

I'm not sure I understand the question. You could read the connection string from a registry key or configuration file or something like that (please don't store a password there 😀).

There's no problem connecting to a single geodatabase multiple times through the Pro SDK. The underlying code will share a single connection.

--Rich

topic Re: Best practice for establishing SDE Connection once in session for ArcGIS Pro Add-in? in ArcGIS Pro SDK Questions

Best practice for establishing SDE Connection once in session for ArcGIS Pro Add-in?

Re: Best practice for establishing SDE Connection once in session for ArcGIS Pro Add-in?