/// <summary> /// Renvoie une chaine de connexion /// </summary> /// <param name="mars">Indique si la connexion doit accepter les jeux de résultats actifs multiples (Multiple Active Result Set)</param> /// <exception cref="ArgumentException"></exception> /// <exception cref="InvalidOperationException"></exception> /// <returns>une connexion ouverte</returns> public SqlConnection GetOpenConnection(string customConnectionString, bool mars) { if (!mars) { return(GetOpenConnection(customConnectionString)); } var scsb = factory.CreateConnectionStringBuilder(); try { scsb.ConnectionString = string.IsNullOrWhiteSpace(customConnectionString) ? GetConnectionString() : customConnectionString; ((dynamic)scsb).MultipleActiveResultSets = true; } catch (Exception ex) { throw new ArgumentException("Creation connexion failed", ex); } var conn = (SqlConnection)factory.CreateConnection(); conn.ConnectionString = scsb.ConnectionString; try { conn.Open(); return(conn); } catch (Exception ex2) { throw new InvalidOperationException("Opening connexion (Multiple Active Result Set) Fail", ex2); } }
private DbConnection CreateDbConnection() { var dbConnection = _sqlClientFactory.CreateConnection(); dbConnection.ConnectionString = _dbConnectionString; return(dbConnection); }
public User Get(string login, string password) { var factory = new SqlClientFactory(); using (var connection = factory.CreateConnection()) { var command = factory.CreateCommand(); command.Connection = connection; command.CommandType = CommandType.Text; command.CommandText = "select * from tb_user where login =@login and password=@password"; command.Parameters.Add(new SqlParameter("@login", login)); command.Parameters.Add(new SqlParameter("@password", password)); try { connection.Open(); var reader = command.ExecuteReader(); while (reader.Read()) { var objUser = GetFromReader(reader); return(objUser); } return(null); } catch { return(null); } } }
static DbConnection CreateDbConnection(string dbConnectionString) { var dbConnection = sqlClientFactory.CreateConnection(); dbConnection.ConnectionString = dbConnectionString; return(dbConnection); }
private DbConnection CreateDbConnection() { var dbConnection = sqlClientFactory.CreateConnection(); dbConnection.ConnectionString = @"Data Source=(localdb)\ProjectsV13;Initial Catalog=MovieDb;Integrated Security=True;TrustServerCertificate=True;"; return(dbConnection); }
/**/ private bool mensajeError = true; public bool MensajeError { get { return(mensajeError); } set { mensajeError = value; } } /**/ public DatabaseHelper(string connectionstring, Providers provider) { strConnectionString = connectionstring; switch (provider) { case Providers.SqlServer: objFactory = SqlClientFactory.Instance; break; case Providers.ConfigDefined: string providername = ConfigurationManager.ConnectionStrings["DGP_cs"].ProviderName; switch (providername) { case "System.Data.SqlClient": objFactory = SqlClientFactory.Instance; break; } break; } objConnection = (SqlConnection)objFactory.CreateConnection(); objCommand = (SqlCommand)objFactory.CreateCommand(); objConnection.ConnectionString = strConnectionString; objCommand.Connection = objConnection; }
private void MainForm_Load(object sender, EventArgs e) { SqlClientFactory factory = SqlClientFactory.Instance; DbConnection connection = factory.CreateConnection(); DbCommand command = factory.CreateCommand(); command.Connection = connection; command.CommandText = "query here"; command.ExecuteNonQuery(); }
public IDbConnection Create() { IDbConnection connection = provider.CreateConnection(); if (connection == null) { throw new KeyNotFoundException( $"Failed to create a connection using the connection string named '{nameof(connectionString)}' in Data/web.config."); } connection.ConnectionString = connectionString; return(connection); }
public User Create(User user) { try { var command = "STP_Register_User"; using (var conn = factory.CreateConnection()) { var parameters = new DynamicParameters(); parameters.Add("@NAME", user.Name, DbType.String, ParameterDirection.Input); parameters.Add("@EMAIL", user.Email, DbType.String, ParameterDirection.Input); parameters.Add("@LOGIN", user.Login, DbType.String, ParameterDirection.Input); parameters.Add("@PASSWORD", user.Password, DbType.String, ParameterDirection.Input); var result = conn.Query <User>(command, parameters, commandType: CommandType.StoredProcedure).AsList().FirstOrDefault(); return(result); } } catch { return(null); } }
/// <summary> /// Creates the connection. /// </summary> /// <returns></returns> public override IDbConnection CreateConnection() { return(sqlClientFactory.CreateConnection()); }
public DataAccess(SqlClientFactory sQLClientFactory, ApplicationSettings applicationSettings) { Connection = sQLClientFactory.CreateConnection(); Connection.ConnectionString = applicationSettings.ConnectionString; }