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());
}
