MySqlExtensions.UseMySql<TAdoDbContext>(this IDataContextOptions<TAdoDbContext> contextOptions, IConfiguration configuration, string connectionKey) Method

.NET Standard 2.x

Configures the context to connect to a MySql database.

Namespace: SnapObjects.Data.MySql

Assembly: SnapObjects.Data.MySql.dll

Syntax

public static IDataContextOptions<TAdoDbContext> UseMySql<TAdoDbContext>(this IDataContextOptions<TAdoDbContext> contextOptions, IConfiguration configuration, string connectionKey) where TAdoDbContext : MySqlDataContext

Type Parameters

TAdoDbContext

The type of context to be configured.

Parameters

contextOptions IDataContextOptions<TAdoDbContext>

The options being used to configure the context.

configuration IConfiguration

Represents a set of key/value application configuration properties.

connectionKey System.String

A key specified in the connection strings in the specified configuration.

Returns

SnapObjects.Data.IDataContextOptions<TAdoDbContext>

An IDataContextOptions<TAdoDbContext> object which contains options of the DataContext object.

Examples

The following code demonstrates how to use the UseMySql method in the ConfigureServices method of the Startup class.

using Appeon.ApiDoc.Models;
using Microsoft.Extensions.DependencyInjection;
using MySql.ManagedDataAccess.Client;
using SnapObjects.Data;
using SnapObjects.Data.MySql;
using System;
using System.Configuration;
using Microsoft.Extensions.Configuration;

namespace Appeon.ApiDoc.MySqlExtensionsExamples
{
    public class StartUp
    {
        public IConfiguration Configuration { get; }

        public StartUp(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        const string CONNECTION_STRING = "USER ID=***;PASSWORD=***;" +
        "DATA SOURCE=\"(DESCRIPTION=(ADDRESS=(HOST=***)(PORT=1521)(PROTOCOL=TCP))(CONNECT_DATA=(SERVICE_NAME=***)))\";";

        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {
            // UseMySql with connection string.
            services.AddDataContext<MySqlContext>(m => m.UseMySql(CONNECTION_STRING));

            // UseMySql with connection string and other options.
            services.AddDataContext<MySqlContext>(m => m.UseMySql(CONNECTION_STRING, n => n.TrimSpaces = true));

            // UseMySql with the IConfiguration object and the key specified in the connection strings.
            services.AddDataContext<MySqlContext>(m => m.UseMySql(this.Configuration, "MyConnectionString"));

        }
    }
}

Applies to

.NET Standard

2.x