public void Init(string connectionString, DatabaseProvider databaseType) { DatabaseProvider = databaseType; conn = DatabaseProvider.GetAndConfigureConnection(connectionString, (dbConnection, dbtype) => { switch (dbtype) { case DatabaseProvider.MySqlData: MySqlInsightDbProvider.RegisterProvider(); break; case DatabaseProvider.Npgsql: PostgreSQLInsightDbProvider.RegisterProvider(); break; case DatabaseProvider.SystemData: case DatabaseProvider.MicrosoftData: SqlInsightDbProvider.RegisterProvider(); break; case DatabaseProvider.MySqlConnector: MySqlConnectorInsightDbProvider.RegisterProvider(); break; default: throw new ArgumentOutOfRangeException(); } return(dbConnection); }); }
/// <summary> /// Initializes the database connection /// </summary> static LogicAndDataAccess() { SqlInsightDbProvider.RegisterProvider(); DbConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["AbsenceSoft"].ConnectionString); Database = connection.As <IDataAccess>(); }
public static void Initialize(TestContext context) { var dataDirectory = Path.Combine(new DirectoryInfo(Environment.CurrentDirectory).Parent.Parent.Parent.FullName, "Take Home\\App_Data"); AppDomain.CurrentDomain.SetData("DataDirectory", dataDirectory); SqlInsightDbProvider.RegisterProvider(); }
protected override void Load(ContainerBuilder builder) { SqlInsightDbProvider.RegisterProvider(); if (this._lifeTime == "InstancePerLifetimeScope") { builder .Register(b => this._sqlConnection.AsParallel <IAuthenticationRepository>()) .InstancePerLifetimeScope().EnableInterfaceInterceptors(); builder .Register(b => this._sqlConnection.AsParallel <IUserManagementRepository>()) .InstancePerLifetimeScope().EnableInterfaceInterceptors(); builder.Register(b => this._sqlConnection.AsParallel <IFileCryptRepository>()) .InstancePerLifetimeScope() .EnableInterfaceInterceptors(); } else { builder.Register(b => this._sqlConnection.AsParallel <IAuthenticationRepository>()) .EnableInterfaceInterceptors(); builder.Register(b => this._sqlConnection.AsParallel <IUserManagementRepository>()) .EnableInterfaceInterceptors(); builder.Register(b => this._sqlConnection.AsParallel <IFileCryptRepository>()) .EnableInterfaceInterceptors(); } base.Load(builder); }
public void DbSetup() { connection = new SqlConnection(connectionString); SqlInsightDbProvider.RegisterProvider(); connection.Open(); var cmd = connection.CreateCommand(); cmd.CommandText = $@" SET NOCOUNT ON; IF (OBJECT_ID('PostXml') IS NULL) BEGIN CREATE TABLE PostXml ( Id INT IDENTITY(1,1) PRIMARY KEY NOT NULL, [Child] XML NOT NULL, CreationDate DATETIME NOT NULL, LastChangeDate DATETIME NOT NULL ); END; DELETE FROM dbo.PostXml; DECLARE @i INT = 0; WHILE (@i <= {iterations}) BEGIN INSERT INTO PostXml([Child], CreationDate, LastChangeDate) SELECT CONCAT(N'{NamespaceHeader}', REPLICATE('x', 2000), '{NamespaceFooter}'), SYSDATETIME(), SYSDATETIME(); SET @i = @i + 1; END;"; cmd.Connection = connection; cmd.ExecuteNonQuery(); }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); SqlInsightDbProvider.RegisterProvider(); }
public UserAccountService() { SqlInsightDbProvider.RegisterProvider(); string sqlConnection = ConfigurationManager.ConnectionStrings["SQLConnection"].ConnectionString; DbConnection c = new SqlConnection(sqlConnection); _IUserAccountRepository = c.As <IUserAccountRepository>(); }
public IDbConnection GetConnection() { SqlInsightDbProvider.RegisterProvider(); string sqlConnection = ConfigurationManager.ConnectionStrings["SQLConnection"].ConnectionString; DbConnection connection = new SqlConnection(sqlConnection); return(connection); }
public async Task <List <EmployeeModel> > LoadEmployeeData() { //List<EmployeeModel> employeeDetails = new List<EmployeeModel>(); var employeeDetails = Builder <EmployeeModel> .CreateListOfSize(1000) .All() .With(c => c.FullName = Faker.Name.FullName()) .With(c => c.FirstName = Faker.Name.FirstName()) .With(c => c.LastName = Faker.Name.LastName()) .With(c => c.Email = Faker.User.Email()) .With(c => c.Initial = Faker.Name.Gender()) .With(c => c.DateOfBirth = Faker.Date.Birthday()) .With(c => c.DateOfJoining = Faker.Date.Recent(5)) .With(c => c.TIN = Faker.Number.RandomNumber(56123488).ToString()) .With(c => c.PASSPORT = Faker.Number.RandomNumber(86123488).ToString()) .With(c => c.UserId = 1) .Build(); Parallel.ForEach(employeeDetails, new ParallelOptions { MaxDegreeOfParallelism = 30 }, item => { EmployeeAddressModel employeeAddressModelP = new EmployeeAddressModel(); employeeAddressModelP.Address1 = Faker.Address.SecondaryAddress(); employeeAddressModelP.Address2 = Faker.Address.SecondaryAddress(); employeeAddressModelP.Address3 = Faker.Address.SecondaryAddress(); employeeAddressModelP.City = Faker.Address.USCity(); employeeAddressModelP.State = Faker.Address.State(); EmployeeAddressModel employeeAddressModelC = new EmployeeAddressModel(); employeeAddressModelC.Address1 = Faker.Address.SecondaryAddress(); employeeAddressModelC.Address2 = Faker.Address.SecondaryAddress(); employeeAddressModelC.Address3 = Faker.Address.SecondaryAddress(); employeeAddressModelC.City = Faker.Address.USCity(); employeeAddressModelC.State = Faker.Address.State(); List <EmployeeAddressModel> employeeAddresses = new List <EmployeeAddressModel>(); employeeAddresses.Add(employeeAddressModelP); employeeAddresses.Add(employeeAddressModelC); IEmployeeManageRepository _IEmployeeManageRepository1; SqlInsightDbProvider.RegisterProvider(); // string sqlConnection = "Data Source=.;Initial Catalog=EmployeeManage;Integrated Security=True"; string sqlConnection1 = Caching.Instance.GetApplicationConfigs("DBConnection") ; DbConnection c1 = new SqlConnection(sqlConnection1); _IEmployeeManageRepository1 = c1.As <IEmployeeManageRepository>(); var returnValue = _IEmployeeManageRepository1.LoadEmployeeData(item, employeeAddresses); //var returnValue = this._IEmployeeManageRepository.LoadEmployeeData(item); }); return(employeeDetails.ToList()); }
public AppAnalyticsService(DbConnection Parameter, IIPRequestDetails iIPRequestDetails) { SqlInsightDbProvider.RegisterProvider(); string sqlConnection = Caching.Instance.GetApplicationConfigs("DBConnection"); DbConnection c = new SqlConnection(sqlConnection); _IAppAnalyticsRepository = c.As <IAppAnalyticsRepository>(); _IIPRequestDetails = iIPRequestDetails; }
public StoreServerService() { SqlInsightDbProvider.RegisterProvider(); //string sqlConnection = ConfigurationManager.ConnectionStrings["SQLConnection"].ConnectionString; string sqlConnection = "Data Source=.;Initial Catalog=HRAMDashBoard;Integrated Security=True"; DbConnection c = new SqlConnection(sqlConnection); _IStoreServerRepository = c.As <IStoreServerRepository>(); }
// This method gets called by the runtime. Use this method to add services to the container. // For more information on how to configure your application, visit https://go.microsoft.com/fwlink/?LinkID=398940 public void ConfigureServices(IServiceCollection services) { //// configure jwt authentication //var appSettings = appSettingsSection.Get<AppSettings>(); //var key = Encoding.ASCII.GetBytes(appSettings.Secret); var key = Encoding.ASCII.GetBytes(ClsGlobal.Secret);// default authentication initialization services.AddAuthentication(x => { x.DefaultAuthenticateScheme = JwtBearerDefaults.AuthenticationScheme; x.DefaultChallengeScheme = JwtBearerDefaults.AuthenticationScheme; }) .AddJwtBearer(x => { x.RequireHttpsMetadata = false; x.SaveToken = true; x.TokenValidationParameters = new TokenValidationParameters { ValidateIssuerSigningKey = true, IssuerSigningKey = new SymmetricSecurityKey(key), ValidateIssuer = false, ValidateAudience = false }; }); services.AddMvc().AddNewtonsoftJson(); services.AddResponseCompression(opts => { opts.EnableForHttps = true; opts.MimeTypes = ResponseCompressionDefaults.MimeTypes.Concat( new[] { "application/octet-stream" }); }); // configure DI for application services //***Inject Repository to DataAcess Binders(); services.AddTransient <ICustomerRepository, CustomerDataAccess>(); services.AddTransient <IPolicyRepository, PolicyDataAccess>(); services.AddTransient <IUserRepository, UserDataAccess>(); services.AddTransient <IExcelRepository, ExcelDataAccess>(); services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_3_0); //CORS services //PM: Install-Package Microsoft.AspNetCore.Cors -Version 2.2.0 //https://docs.microsoft.com/en-us/aspnet/core/security/cors?view=aspnetcore-3.0 services.AddCors(); //***PM: Install-Package Insight.Database SqlInsightDbProvider.RegisterProvider(); JsonNetObjectSerializer.Initialize(); }
public EmployeeManageService(DbConnection Parameter) { SqlInsightDbProvider.RegisterProvider(); // string sqlConnection = "Data Source=.;Initial Catalog=EmployeeManage;Integrated Security=True"; string sqlConnection = Caching.Instance.GetApplicationConfigs("DBConnection") ; DbConnection c = new SqlConnection(sqlConnection); _IEmployeeManageRepository = c.AsParallel <IEmployeeManageRepository>(); }
public ApiRepository(DbConnection connection) { this.connection = connection; SqlInsightDbProvider.RegisterProvider(); if (this.connection.State == System.Data.ConnectionState.Closed) { this.connection.Open(); } }
public UserAccountService(DbConnection Parameter, ISercurityService iSercurityService) { SqlInsightDbProvider.RegisterProvider(); string sqlConnection = Caching.Instance.GetApplicationConfigs("DBConnection"); DbConnection c = new SqlConnection(sqlConnection); _IUserAccountRepository = c.As <IUserAccountRepository>(); _ISercurityService = iSercurityService; }
internal static void EnsureInsightIsInitialized() { if (!_hasInsightBeenInitialized) { // Ensure we register the SqlInsightDbProvider // TODO: Consider moving this call closer to where the Insight.Database dependency is actually used SqlInsightDbProvider.RegisterProvider(); ColumnMapping.Parameters.AddMapper(new SsisParameterMapper()); _hasInsightBeenInitialized = true; } }
public SercurityService(IIPRequestDetails iIPRequestDetails) { SqlInsightDbProvider.RegisterProvider(); // string sqlConnection = "Data Source=.;Initial Catalog=EmployeeManage;Integrated Security=True"; string sqlConnection = Caching.Instance.GetApplicationConfigs("DBConnection"); DbConnection c = new SqlConnection(sqlConnection); _IUserAccountRepository = c.As <IUserAccountRepository>(); _IAppAnalyticsRepository = c.As <IAppAnalyticsRepository>(); _IIPRequestDetails = iIPRequestDetails; }
public Startup(IHostingEnvironment env) { SqlInsightDbProvider.RegisterProvider(); var builder = new ConfigurationBuilder() .SetBasePath(env.ContentRootPath) .AddJsonFile("appsettings.json", true, true) .AddJsonFile($"appsettings.{env.EnvironmentName}.json", true) .AddEnvironmentVariables(); Configuration = builder.Build(); }
public void ConfigureContainer(ContainerBuilder builder) { SqlInsightDbProvider.RegisterProvider(); DbConnection sqlConnection = new SqlConnection("Data Source=.;Initial Catalog=BlazorAppWinWin;Integrated Security=True;Persist Security Info=true;"); builder .Register(b => sqlConnection.AsParallel <IEmployeeManageRepository>()) .InstancePerLifetimeScope(); builder .Register(b => sqlConnection.AsParallel <IEmployeeApprovalRepository>()) .InstancePerLifetimeScope(); }
public void ConfigureContainer(ContainerBuilder builder) { SqlInsightDbProvider.RegisterProvider(); DbConnection sqlConnection = new SqlConnection("Data Source=.;Initial Catalog=BlazorAppWinWin;Integrated Security=True;Persist Security Info=true;"); builder .Register(b => sqlConnection.AsParallel <IAuthenticationRepository>()) .InstancePerLifetimeScope() .EnableInterfaceInterceptors() .InterceptedBy(typeof(RepositoryInterfaceLogger));; builder.Register(c => new RepositoryInterfaceLogger(Console.Out)); }
protected override void Load(ContainerBuilder builder) { SqlInsightDbProvider.RegisterProvider(); builder.Register(b => this._sqlConnection.AsParallel <IEmployeeQueryRepository>()); builder.Register(b => this._sqlConnection.AsParallel <IEmployeeCommandRepository>()); builder.Register(b => this._sqlConnection.AsParallel <IUserCommandRepository>()); builder.Register(b => this._sqlConnection.AsParallel <IUserQueryRepository>()); builder.Register(b => this._sqlConnection.AsParallel <IAuthrizationQueryRepository>()); base.Load(builder); }
protected override void Load(ContainerBuilder builder) { base.Load(builder); SqlInsightDbProvider.RegisterProvider(); //GlimpseInsightDbProvider.RegisterProvider(); IDbConnection connection = this.GetSqlConnection(); //builder.RegisterInstance(connection.AsParallel<IRevenueLossRepository>()); builder.Register(c => connection.AsParallel <RevenueLossRepository>()).As <IRevenueLossRepository>(); builder.Register(c => connection.AsParallel <LayoutRepository>()).As <ILayoutRepository>(); //builder.RegisterAssemblyTypes(Assembly.GetAssembly(typeof(RepositoryBase))).Where(t => t.IsClass && t.GetInterfaces().Where(i => i.IsAssignableFrom(typeof(IRepository))).Count() > 0).AsImplementedInterfaces(); }
// "Server=localhost; Database=BetAppDb; Trusted_Connection=True; User ID=sa; Password=Pa$$w0rd123;"; public DbInsight() { SqlInsightDbProvider.RegisterProvider(); Connection = new SqlConnection(connStr); CountryRepository = Connection.AsParallel <ICountryRepository>(); LeagueRepository = Connection.AsParallel <ILeagueRepository>(); SeasonRepository = Connection.AsParallel <ISeasonRepository>(); GameRepository = Connection.AsParallel <IGameRepository>(); StageRepository = Connection.AsParallel <IStageRepository>(); TeamRepository = Connection.AsParallel <ITeamRepository>(); ResultRepository = Connection.AsParallel <IResultRepository>(); SpanStatsRepository = Connection.AsParallel <ISpanStatsRepository>(); }
public static IServiceCollection AddCustomPersistence(this IServiceCollection serviceCollection) { SqlInsightDbProvider.RegisterProvider(); serviceCollection.AddSingleton <IExampleDbRepository>(context => { var connectionString = context.GetRequiredService <DatabaseConnectionStringSetting>().Value; var innerConnection = new SqlConnection(connectionString); return(new ReliableConnection(innerConnection).AsParallel <IExampleDbRepository>()); }); return(serviceCollection); }
public DashBoardService(DbConnection Parameter, IWeatherForecast iWeatherForecast, IIPRequestDetails iIPRequestDetails, IEmailService iEmailService) { SqlInsightDbProvider.RegisterProvider(); // string sqlConnection = "Data Source=.;Initial Catalog=EmployeeManage;Integrated Security=True"; string sqlConnection = Caching.Instance.GetApplicationConfigs("DBConnection") ; DbConnection c = new SqlConnection(sqlConnection); _IUserAccountRepository = c.As <IUserAccountRepository>(); _IIPRequestDetails = iIPRequestDetails; _IWeatherForecast = iWeatherForecast; _IEmailService = iEmailService; }
static void Main(string[] args) { SqlInsightDbProvider.RegisterProvider(); using (var c = Database.Open()) { try { c.ExecuteSql("DROP PROCEDURE HelloWorld", null); } catch { } try { c.ExecuteSql("CREATE PROCEDURE HelloWorld AS SELECT 'Hello, World.'", null); Console.WriteLine(c.ExecuteScalar <String>("HelloWorld", null)); } finally { c.ExecuteSql("DROP PROCEDURE HelloWorld", null); } } }
public void DbSetup() { connection = new SqlConnection(connectionString); SqlInsightDbProvider.RegisterProvider(); connection.Open(); var cmd = connection.CreateCommand(); cmd.CommandText = $@" SET NOCOUNT ON; IF (OBJECT_ID('PostJson') IS NULL) BEGIN CREATE TABLE PostJson ( Id INT IDENTITY(1,1) PRIMARY KEY NOT NULL, [Child] NVARCHAR(MAX) NOT NULL, CreationDate DATETIME NOT NULL, LastChangeDate DATETIME NOT NULL ); ALTER TABLE [dbo].PostJson ADD CONSTRAINT [Text must be formatted as JSON object] CHECK (IsJson([Child]) > 0) END; DELETE FROM dbo.PostJson; DECLARE @i INT = 0; WHILE (@i <= {iterations}) BEGIN INSERT INTO PostJson([Child], CreationDate, LastChangeDate) SELECT (SELECT TOP 1 REPLICATE('x', 2000) [Text] FOR JSON PATH, WITHOUT_ARRAY_WRAPPER), SYSDATETIME(), SYSDATETIME(); SET @i = @i + 1; END;"; cmd.Connection = connection; cmd.ExecuteNonQuery(); }
static void Main(string[] args) { SqlInsightDbProvider.RegisterProvider(); #region Performance Tests if (args.Length > 0 && args[0] == "perf") { PerfTest(); return; } #endregion #region Opening Connections IDBConnection_OpenConnection(); ConnectionStringSettings_Connection(); ConnectionStringSettings_Open(); SqlConnectionStringBuilder_Connection(); SqlConnectionStringBuilder_Open(); #endregion #region Executing Database Commands Execute(); ExecuteSql(); #endregion #region Querying for Objects Query_Query(); Query_QuerySql(); Query_ToList(); Query_AsEnumerable(); #endregion #region Insert Insert_Sql(); #endregion #region Dynamic Objects Dynamic_Query(); Dynamic_ForEach(); #endregion #region Dynamic Database Calls DynamicCall_Named(); DynamicCall_Transaction(); #endregion #region Lists of Objects List_ValueTypeSql(); List_ValueTypeStoredProcedure(); List_ClassStoredProcedure(); List_ClassSql(); #endregion #region Async Queries Async_Execute(); Async_Query(); #endregion #region Bulk Copy BulkCopy(); #endregion #region Multiple Result Sets MultipleResultSets(); #endregion #region Object Hierarchies ObjectHierarchy(); #endregion #region Creating Commands IDbConnection_CreateCommand(); IDbConnection_CreateCommandSql(); #endregion #region Common Parameters CommonParameter_Transaction(); #endregion #region Manual Transformation ManualTransform(); ManualTransform_Sum(); ManualTransform_GetReader(); #endregion #region Expando Expansion Expando_Expand(); #endregion #region Expando Mutation Expando_Mutate(); Expando_Transform(); Expando_TransformList(); #endregion #region ForEach ForEach(); AsEnumerable(); #endregion #region Repository Pattern Repository(); #endregion #region Auto Interface Implementation AutoInterfaceImplementation(); #endregion }
static void Main(string[] args) { SqlInsightDbProvider.RegisterProvider(); #region Opening Connections IDBConnection_OpenConnection(); SqlConnectionStringBuilder_Connection(); SqlConnectionStringBuilder_Open(); #endregion #region Executing Database Commands Execute(); ExecuteSql(); #endregion #region Querying for Objects Query_Query(); Query_QuerySql(); Query_ToList(); Query_AsEnumerable(); #endregion #region Insert Insert_Sql(); #endregion #region Dynamic Objects Dynamic_Query(); Dynamic_ForEach(); #endregion #region Dynamic Database Calls DynamicCall_Named(); DynamicCall_Transaction(); #endregion #region Lists of Objects List_ValueTypeSql(); List_ClassSql(); #endregion #region Async Queries Async_Execute(); Async_Query(); #endregion #region Bulk Copy BulkCopy(); #endregion #region Creating Commands IDbConnection_CreateCommand(); IDbConnection_CreateCommandSql(); #endregion #region Common Parameters CommonParameter_Transaction(); #endregion #region Manual Transformation ManualTransform(); ManualTransform_Sum(); ManualTransform_GetReader(); #endregion #region Expando Expansion Expando_Expand(); #endregion #region Expando Mutation Expando_Mutate(); Expando_Transform(); Expando_TransformList(); #endregion #region ForEach ForEach(); AsEnumerable(); #endregion }
public void Init(string connectionStrong) { conn = new SqlConnection(connectionStrong); SqlInsightDbProvider.RegisterProvider(); }