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); } } }
/**/ 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(); }
static bool CheckDBInit(string connectionString) { SqlClientFactory newFactory = SqlClientFactory.Instance; SqlConnection sqlConnection = new SqlConnection(connectionString); sqlConnection.Open(); DbCommand cmd = newFactory.CreateCommand(); //MSSQL, Pstrgre и MySQL cmd.CommandText = "select case when exists((select* from information_schema.tables where table_name = 'OrleansQuery')) then 1 else 0 end"; cmd.Connection = sqlConnection; var res = (int)cmd.ExecuteScalar(); return(res == 1); }
static bool InitDB(string connectionString) { SqlClientFactory newFactory = SqlClientFactory.Instance; SqlConnection sqlConnection = new SqlConnection(connectionString); sqlConnection.Open(); if (!Directory.Exists("OrleansAdoNetContent\\SQLServer")) { return(false); } ; //xxx-Main should be the first :) foreach (var scriptFile in Directory.GetFiles("OrleansAdoNetContent\\SQLServer", "*.sql").OrderByDescending(c => c.Contains("Main"))) { DbCommand cmd = newFactory.CreateCommand(); cmd.CommandText = File.ReadAllText(scriptFile); cmd.Connection = sqlConnection; cmd.ExecuteNonQuery(); } sqlConnection.Close(); return(true); }
/// <summary> /// Creates the command. /// </summary> /// <returns></returns> public override IDbCommand CreateCommand() { return(sqlClientFactory.CreateCommand()); }