HealthMonitoring.Persistence.MySqlDatabase.OpenConnection C# (CSharp) Method

OpenConnection() public method

public OpenConnection ( ) : IDbConnection
return IDbConnection
        public IDbConnection OpenConnection()
        {
            var mySqlConnectionStringBuilder = new MySqlConnectionStringBuilder(_connectionString)
            {
                Database = _databaseName
            };
            var mySqlConnection = new MySqlConnection(mySqlConnectionStringBuilder.ToString());
            mySqlConnection.Open();
            return mySqlConnection;
        }

Usage Example

        public void SaveEndpoint(Endpoint endpoint)
        {
            using (var conn = _db.OpenConnection())
                using (var tx = conn.BeginTransaction())
                {
                    var tags = endpoint.Metadata.Tags.ToDbString();

                    conn.Execute(
                        $"replace into EndpointConfig(MonitorType, Address, GroupName, Name, Id, Password, RegisteredOnUtc, RegistrationUpdatedOnUtc, MonitorTag{(tags != null ? ", Tags" : "")}) values(@MonitorType,@Address,@Group,@Name,@Id,@Password,@RegisteredOnUtc,@RegistrationUpdatedOnUtc,@MonitorTag{(tags != null ? ",@Tags" : "")})",
                        new
                    {
                        endpoint.Identity.MonitorType,
                        endpoint.Identity.Address,
                        endpoint.Metadata.Group,
                        endpoint.Metadata.Name,
                        endpoint.Identity.Id,
                        endpoint.Password,
                        endpoint.Metadata.RegisteredOnUtc,
                        endpoint.Metadata.RegistrationUpdatedOnUtc,
                        endpoint.Metadata.MonitorTag,
                        tags
                    }, tx);

                    tx.Commit();
                }
        }
All Usage Examples Of HealthMonitoring.Persistence.MySqlDatabase::OpenConnection