public DefaultPersistedGrantProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultPersistedGrantProvider> logger) { this._options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions)); this._logger = logger; left = _options.ColumnProtect["left"]; right = _options.ColumnProtect["right"]; }
public static DBProviderOptions GetDefaultOptions() { //config mssql var options = new DBProviderOptions(); return(options); }
public DefaultApiResourceProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultApiResourceProvider> logger, IDistributedCache cache) { this._options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions)); this._logger = logger; left = _options.ColumnProtect["left"]; right = _options.ColumnProtect["right"]; _cache = cache; }
public static DBProviderOptions GetDefaultOptions() { //config mssql var options = new DBProviderOptions(); options.GetLastInsertID = "select @@IDENTITY;"; return(options); }
public static DBProviderOptions GetDBProviderOptions(string type) { DBProviderOptions options = null; if (type == MySQL) { options = MySqlN.IdentityServerDapperDBExtensions.GetDefaultOptions(); options.ConnectionString = "server=10.40.0.190;uid=changyin.han;pwd=fjfhhan07;database=identityserver4dev;SslMode=None;"; } else if (type == MSSQL) { options = MSSqlN.IdentityServerDapperDBExtensions.GetDefaultOptions(); options.ConnectionString = "server=10.40.0.190;uid=sa;pwd=Onesmart190;database=identityserver4;"; } return(options); }
public static IIdentityServerBuilder AddMySQLProvider(this IIdentityServerBuilder builder, Action <DBProviderOptions> dbProviderOptionsAction = null) { //config mysql var options = new DBProviderOptions(); options.DbProviderFactory = new MySqlClientFactory(); //get last insert id for insert actions options.GetLastInsertID = "select last_insert_id();"; //config the ColumnName protect string, mysql using "`" options.ColumnProtect = new System.Collections.Generic.Dictionary <string, string>(); options.ColumnProtect.Add("left", "`"); options.ColumnProtect.Add("right", "`"); //add singgleton builder.Services.AddSingleton(options); dbProviderOptionsAction?.Invoke(options); return(builder); }
public static DBProviderOptions GetDBProviderOptions(string type) { DBProviderOptions options = null; if (type == MySQL) { options = MySqlN.IdentityServerDapperDBExtensions.GetDefaultOptions(); options.ConnectionString = "server=.;uid=darinhan;pwd=darinhan;database=identityserver4;SslMode=None;"; } else if (type == MSSQL) { options = MSSqlN.IdentityServerDapperDBExtensions.GetDefaultOptions(); options.ConnectionString = "server=.;uid=darinhan;pwd=darinhan;database=identityserver4;"; } return(options); }
public static DBProviderOptions GetDefaultOptions() { //config mysql var options = new DBProviderOptions(); options.DbProviderFactory = new MySqlClientFactory(); //get last insert id for insert actions options.GetLastInsertID = "select last_insert_id();"; //config the ColumnName protect string, mysql using "`" options.ColumnProtect = new System.Collections.Generic.Dictionary <string, string>(); options.ColumnProtect.Add("left", "`"); options.ColumnProtect.Add("right", "`"); //add singgleton options.GetPageQuerySQL = (input, pageindex, pagesize, totalcount, orderby, pairs) => { string limitsql = string.Empty; if (pagesize > 0) { if (pagesize > totalcount) { pagesize = totalcount; } pairs.Add("start", (pageindex - 1) * pagesize); pairs.Add("size", pagesize); limitsql = "limit @start,@size"; } if (input.IndexOf("order by", StringComparison.CurrentCultureIgnoreCase) >= 0) { orderby = ""; } else { if (!string.IsNullOrWhiteSpace(orderby) && orderby.IndexOf("order by", StringComparison.CurrentCultureIgnoreCase) < 0) { orderby = "order by " + orderby; } } return($"{input} {orderby} {limitsql}"); }; return(options); }
public static DBProviderOptions GetDefaultOptions() { //config mssql var options = new DBProviderOptions(); options.DbProviderFactory = SqlClientFactory.Instance; //get last insert id for insert actions options.GetLastInsertID = "select @@IDENTITY;"; //config the ColumnName protect string, mssql using "[]" options.ColumnProtect = new System.Collections.Generic.Dictionary <string, string>(); options.ColumnProtect.Add("left", "["); options.ColumnProtect.Add("right", "]"); options.GetPageQuerySQL = (input, pageindex, pagesize, totalcount, orderby, pairs) => { int pagestart = 0; int pageend = 0; string limitsql = string.Empty; if (pagesize > 0) { if (pagesize > totalcount) { pagesize = totalcount; } pagestart = (pageindex - 1) * pagesize + 1; pageend = pagestart - 1 + pagesize; } if (string.IsNullOrWhiteSpace(orderby)) { orderby = "order by id"; //default } if (!string.IsNullOrWhiteSpace(orderby) && orderby.IndexOf("order by", StringComparison.CurrentCultureIgnoreCase) < 0) { orderby = "order by " + orderby; } input = $"select ROW_NUMBER() over ({orderby}) as rowid,{input.Substring(input.IndexOf("select", StringComparison.CurrentCultureIgnoreCase) + 6)}"; return($"select * from ({input}) as innertable where rowid between {pagestart} and {pageend};"); }; return(options); }
public DefaultApiResourceProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultApiResourceProvider> logger) { this._options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions)); this._logger = logger; }
public DefaultPersistedGrantProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultPersistedGrantProvider> logger) { this._options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions)); this._logger = logger; }
public DefaultApiScopesProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultApiScopesProvider> logger) { _options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions)); _connectionString = dBProviderOptions.ConnectionString; this.logger = logger; }
public DefaultPersistedGrantProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultPersistedGrantProvider> logger) { this._options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions)); _connectionString = dBProviderOptions.ConnectionString; }
public DefaultIdentityResourceProvider(DBProviderOptions dBProviderOptions, ILogger <DefaultIdentityResourceProvider> logger) { _options = dBProviderOptions ?? throw new ArgumentNullException(nameof(dBProviderOptions)); _logger = logger; _connectionString = dBProviderOptions.ConnectionString; }
public DefaultIdentityServerMigrations(DBProviderOptions options, IIdentityServerConfigService identityServerConfigHandler) { _identityServerConfigHandler = identityServerConfigHandler; _schema = options.DbSchema; _connectionString = options.ConnectionString; }