public global::System.Data.SqlClient.SqlCommand BuildCommand(global::System.Data.SqlClient.SqlConnection connection) { var command = new global::System.Data.SqlClient.SqlCommand(); this.BuildCommand(command, connection); return(command); }
public SqlConnection(global::System.Data.SqlClient.SqlConnection connection, IExecuteReaderProvider executeReaderProvider) { if (connection == null) throw new ArgumentNullException("connection"); if (executeReaderProvider == null) throw new ArgumentNullException("executeReaderProvider"); this.connection = connection; this.executeReaderProvider = executeReaderProvider; }
/// <summary> /// Initializes a new instance of the <see cref="SqlCmdBuilderFactory"/> class. /// </summary> /// <param name="connectionStringFactory">The connection string factory.</param> /// <exception cref="System.ArgumentNullException">connectionStringFactory</exception> public SqlCmdBuilderFactory(global::System.Func <string> connectionStringFactory) { if (ReferenceEquals(null, connectionStringFactory)) { throw new global::System.ArgumentNullException(nameof(connectionStringFactory)); } this.m_connectionFactory = () => { var connectionString = connectionStringFactory(); var connection = new global::System.Data.SqlClient.SqlConnection(connectionString); return(connection); }; }
/// <summary> /// Processes the completion of a transaction. /// </summary> /// <param name="sender">The object that originated the event.</param> /// <param name="transactionEventArgs">The event arguments.</param> private void OnTransactionCompleted(object sender, global::System.Transactions.TransactionEventArgs transactionEventArgs) { try { if (FluidTrade.Core.EventLog.IsLoggingEnabledFor(FluidTrade.Core.EventLog.ErrorLogLevel.Verbose)) { this.stackTrce += " closing"; } lock (this) { if (this.sqlConnection != null) { this.sqlConnection.Close(); this.sqlConnection = null; } } } finally { if (this.ClearRowLockList()) { try { global::FluidTrade.Core.EventLog.Information("<<<***>>> OnTransactionCompleted cleared rows in List"); } catch { } } global::System.Threading.Monitor.Enter(DataModelTransaction.syncRoot); try { DataModelTransaction.transactionTable.Remove(this.localIdentifier); //global::System.Transactions.Transaction transaction = transactionEventArgs.Transaction; //string localIdentifier = transaction.TransactionInformation.LocalIdentifier; //DataModelTransaction dataModelTransaction; //if (DataModelTransaction.transactionTable.TryGetValue(localIdentifier, out dataModelTransaction)) //{ // dataModelTransaction.SqlConnection.Close(); // DataModelTransaction.transactionTable.Remove(localIdentifier); //} } finally { global::System.Threading.Monitor.Exit(DataModelTransaction.syncRoot); } } }
public void BuildCommand( global::System.Data.SqlClient.SqlCommand command, global::System.Data.SqlClient.SqlConnection connection) { if (ReferenceEquals(command, null)) { throw new global::System.ArgumentNullException(nameof(command)); } if (ReferenceEquals(connection, null)) { throw new global::System.ArgumentNullException(nameof(connection)); } this.BuildCommand(command); command.Connection = connection; }
public partial global::SomeType WithEncryptionSystemSql(global::System.Data.SqlClient.SqlConnection connection, int id, string name) { // locals global::System.Data.SqlClient.SqlCommand? __dapper__command = null; global::System.Data.SqlClient.SqlDataReader?__dapper__reader = null; bool __dapper__close = false; int[]? __dapper__tokenBuffer = null; try { // prepare connection if (connection !.State == global::System.Data.ConnectionState.Closed) { connection !.Open(); __dapper__close = true; } // prepare command (excluding parameter values) if ((__dapper__command = global::System.Threading.Interlocked.Exchange(ref s___dapper__command_Samples_CustomOptions_input_cs_WithEncryptionSystemSql_8, null)) is null) { __dapper__command = __dapper__CreateCommand(connection !); } else { __dapper__command.Connection = connection; } // assign parameter values #pragma warning disable CS0618 __dapper__command.Parameters[0].Value = global::Dapper.Internal.InternalUtilities.AsValue(id); __dapper__command.Parameters[1].Value = global::Dapper.Internal.InternalUtilities.AsValue(name); #pragma warning restore CS0618 // execute reader const global::System.Data.CommandBehavior __dapper__behavior = global::System.Data.CommandBehavior.SequentialAccess | global::System.Data.CommandBehavior.SingleResult | global::System.Data.CommandBehavior.SingleRow; __dapper__reader = __dapper__command.ExecuteReader(__dapper__close ? (__dapper__behavior | global::System.Data.CommandBehavior.CloseConnection) : __dapper__behavior); __dapper__close = false; // performed via CommandBehavior // process single row global::SomeType __dapper__result; if (__dapper__reader.HasRows && __dapper__reader.Read()) { __dapper__result = global::Dapper.TypeReader.TryGetReader <global::SomeType>() !.Read(__dapper__reader, ref __dapper__tokenBuffer); } else { __dapper__result = default !;
private void UniversalDashboardDeviceType_Load(object sender, EventArgs e) { SqlConnection dbConnection4; //Connection for contractIdCommand SqlCommand contractIdCommand; // Select query to get thresholds by deviceType. { //Open contract id for deviceTypeControl and thresholdId dbConnection4 = new global::System.Data.SqlClient.SqlConnection(); dbConnection4.ConnectionString = global::LinqExample.Properties.Settings.Default.SLA_RT_monitoringConnectionString; // Used for having contract ID per threshold_id and device_type contractIdCommand = new SqlCommand( @"SELECT threshold_id " + @"FROM [dbo].[SlaContracts] " + @"WHERE device_type=@device_type ", dbConnection4); if (((contractIdCommand.Connection.State & global::System.Data.ConnectionState.Open) != global::System.Data.ConnectionState.Open)) { contractIdCommand.Connection.Open(); } contractIdCommand.CommandType = global::System.Data.CommandType.Text; contractIdCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@device_type", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "device_type", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); contractIdCommand.Parameters["@device_type"].Value = this.DeviceTypeText; } SqlDataReader reader2 = contractIdCommand.ExecuteReader(); // Add thresholdIds to the list of matching trhresholds. while (reader2.Read()) { listThresholds.Add(reader2.GetInt32(0)); } reader2.Close(); //close the reader when not using. SqlConnection dbConnection; // connections for deviceByTypeCommand SqlCommand deviceByTypeCommand; // select id and name from Devices table by deviceType. dbConnection = new global::System.Data.SqlClient.SqlConnection(); dbConnection.ConnectionString = global::LinqExample.Properties.Settings.Default.SLA_RT_monitoringConnectionString; // Used for having all the information per Device type deviceByTypeCommand = new SqlCommand( @"SELECT id, name " + @"FROM [dbo].[Devices] " + @"WHERE type = @device_type ", dbConnection); global::System.Data.ConnectionState previousConnectionState = deviceByTypeCommand.Connection.State; if (((deviceByTypeCommand.Connection.State & global::System.Data.ConnectionState.Open) != global::System.Data.ConnectionState.Open)) { deviceByTypeCommand.Connection.Open(); } deviceByTypeCommand.CommandType = global::System.Data.CommandType.Text; deviceByTypeCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@device_type", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "device_type", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); deviceByTypeCommand.Parameters["@device_type"].Value = this.DeviceTypeText; SqlDataReader reader = deviceByTypeCommand.ExecuteReader(); int i = 0; while (reader.Read()) { // Init deviceData with query result. SingleDeviceData newDeviceData = new SingleDeviceData(reader.GetInt32(0), reader.GetString(1)); //Create a label for this device. Label deviceLabel = new Label(); // arrange labels in a row. Left to right. deviceLabel.Location = new Point((int)(40 + 65 * (i * 1.2)), 35); deviceLabel.Size = new System.Drawing.Size(60, 60); // Change the shape of the label to a circle. var path = new System.Drawing.Drawing2D.GraphicsPath(); path.AddEllipse(0, 0, deviceLabel.Width, deviceLabel.Height); deviceLabel.Region = new Region(path); // get the needed backcolor by ioncidents data deviceLabel.BackColor = GetColorByIncidentsNumber(newDeviceData.deviceId); deviceLabel.TextAlign = ContentAlignment.TopCenter; // Put the text on the label. deviceLabel.Text += SplitName(newDeviceData.deviceName)[0]; deviceLabel.Text += "\n"; deviceLabel.Text += SplitName(newDeviceData.deviceName)[1]; deviceLabel.Text += "\n"; deviceLabel.TextAlign = ContentAlignment.MiddleCenter; try { if (SplitName(newDeviceData.deviceName)[2] != null) { deviceLabel.Text += SplitName(newDeviceData.deviceName)[2]; } } catch { } // Insert device data in the Tag property ( for using on Click event and updateTimer). deviceLabel.Tag = newDeviceData; deviceLabel.Cursor = Cursors.Hand; deviceLabel.Click += x_Click; //Add to form controls. this.Controls.Add(deviceLabel); ++i; } reader.Close(); //Update incidents every interval. updateTimer.Start(); }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::WaldenReports.Properties.Settings.Default.walden; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = "Data Source=.;Initial Catalog=Hotel_data;User ID=sa;Password=123456"; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = "Data Source=192.168.0.104,1433;Initial Catalog=TranspoartSystem;Persist Security " + "Info=True;User ID=myt;Password=xiaoyuemian;"; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = "Data Source=DESKTOP-733PMIV;Initial Catalog=FaceDatabase;Integrated Security=True" + ""; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::Denisenko.Cutting.Optimizing.Properties.Settings.Default.CutOptimaConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = "Data Source=BODEXPRESS.mssql.somee.com;Initial Catalog=BODEXPRESS;User ID=bodex;P" + "assword=bodexpress"; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = ValidacionSeguridad.Instance.GetApplicationConnectionString(); }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::DataWizInConsoleTest.Properties.Settings.Default.test_oneConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::LiquiForce.LFSLive.DA.Projects.Properties.Settings.Default.Live1ConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::Groop.IntegrationTests.Properties.Settings.Default.CRinetaConnectionString3; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = CONNECT_STR; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::VehicleManagementSystem.Properties.Settings.Default.VehiclePurchaseManagementsConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::ReportFromSqlServer.Properties.Settings.Default.example_dbConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::PakTurk_school_system.Properties.Settings.Default.School_SystemConnectionString1; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::西子新能源.Properties.Settings.Default.EnergyTestingConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::WaterOneFlow.odm.v1_0.Properties.Settings.Default.od_1_0ConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::FacSync.Properties.Settings.Default.CareCentralSync_PConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::TerraScan.BusinessEntities.Properties.Settings.Default.T2TerraScanConnectionString; }
private void InitConnection() { _connection = new global::System.Data.SqlClient.SqlConnection(); Settings settings = new Settings(); _connection.ConnectionString = settings.GetConnectionString(); }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::DGP.Entities.Properties.Settings.Default.dgpConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = "Data Source=SERVER1\\SQLEXPRESS;Initial Catalog=walden;Integrated Security=True"; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::ACMS.Properties.Settings.Default.ACMSConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["CodematicConnectionString1"].ConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["AdventureWorksConnectionString"].ConnectionString; }
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::SoftLogik.Win.My.Settings.Default.DBConnection; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::HumanResourceUpdate.Properties.Settings.Default.wims_qlnsConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = "Data Source=192.168.1.5,1433;Initial Catalog=TranspoartSystem;User ID=test;Passwo" + "rd=64293849;"; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::GUIConceptsPart2.Properties.Settings.Default.northwindConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::WaterOneFlow.odm.v1_0.Properties.Settings.Default.od_1_0ConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::Hotel_app.Properties.Settings.Default.Hotel_dataConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = "Data Source=.\\samsvx;Initial Catalog=TmpDB;User ID=sa;Password=3919"; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::new_project_dbms.Properties.Settings.Default.testing; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = "Data Source=FTEESW520\\SQL2008R2;Initial Catalog=EEIMonitor;Integrated Security=Tr" + "ue;"; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = "Data Source=db113.72dns.net;Initial Catalog=db_rfidtest;Persist Security Info=Tru" + "e;User ID=rfidtest;Password=123456;"; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = "Data Source=desktop-mu5f7e3;Initial Catalog=BankingApp;Integrated Security=True"; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::Moteur.Properties.Settings.Default.BdMoteurInferanceConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::Granity.granityMgr.Properties.Settings.Default.SmartCardConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["PharmacyToolConnectionString"].ConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::CodeGenerator.Properties.Settings.Default.MenuMasterConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::SchoolManagement.Properties.Settings.Default.itecschoolConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BI_CustomerFlowConnectionString"].ConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::Tests.Unit.Lender.Slos.Database.Properties.Settings.Default.Lender_SlosConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::EDocuments.Properties.Settings.Default.DocumentsBetta2ConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::Biruni.Shared.Properties.Settings.Default.dbInventoryConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::IPCOREDS.Properties.Settings.Default.TOS_TicketSystemConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::Granity.granityMgr.Properties.Settings.Default.SmartCardConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::MaterialCore.Properties.Settings.Default.CoreConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::Equipment_Manager.Properties.Settings.Default.Equipment_ManageConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::COPR_BE.Properties.Settings.Default.COPR_DevNewConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::个人财产管理系统.Properties.Settings.Default.个人资产数据库ConnectionString1; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::LoanApplication.Properties.Settings.Default.DB_LoanApplicationConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::com.Omei.DLL.Properties.Settings.Default.OmeiTravelConnectionString; }
private void InitConnection() { this._connection = new global::System.Data.SqlClient.SqlConnection(); this._connection.ConnectionString = global::RepStoredProc.Properties.Settings.Default.NorthwindConnectionString; }