protected override void AddParameters()
{
sqlP1 = AddParameters("@p50", EF_Preferences.PrefType);
sqlP2 = AddParameters("@p51", EF_Preferences.Computer);
sqlP3 = AddParameters("@p52", EF_Preferences.Username);
sqlP4 = AddParameters("@p53", EF_Preferences.Application);
}
private static string GetConstraint(IColumn columnName)
{
const string command = "select object_name(cdefault) from syscolumns where [id] = object_id(@tn) and [name] like @cn ";
using (var cmd = new SqlProxyCommand(command, GlobalInfo.DBaseInfo.dbManager.DB_Connection))
{
var tn = new SqlProxyParameter("@tn", DbType.String, 64);
var cn = new SqlProxyParameter("@cn", DbType.String, 64);
cmd.Parameters.Add(tn);
cmd.Parameters.Add(cn);
tn.Value = "dbo." + columnName.Table;
cn.Value = columnName.Name;
var constraint = string.Empty;
try
{
var result = cmd.ExecuteScalar();
if (result != null)
{
constraint = result.ToString();
}
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
}
return(constraint);
}
}
public SqlProxyParameter AddParameters(string parameterName, IColumn column)
{
var param = new SqlProxyParameter(parameterName, column);
sqlCM.Parameters.Add(param);
return(param);
}
public SqlProxyParameter AddParameters(string parameterName, Type colType, int colLen)
{
var dbType = ConvertColumnType.GetDBType(colType);
var param = new SqlProxyParameter(parameterName, dbType, colLen);
sqlCM.Parameters.Add(param);
return(param);
}
static void Main(string[] args)
{
var result = GetDBType(typeof(String));
ProxyProviderLoader.UseProvider = ProviderType.SQL;
//var list = SqlProxyDatabaseHelper.ListDatabase("USR-ROGLEDIMAU1", "sa", "", true);
var sqlconnectiostring = new SqlProxyConnectionStringbuilder
{
DataSource = @"SALA\SQLEXPRESS",
//UserID = "sa",
InitialCatalog = "PLUMBER",
//Password = "******",
IntegratedSecurity = true
};
//var creadb = new SqlProxyDataBaseHelper
//{
// DataSource = @"C:\Users\Rogledi\Desktop\Clothes.db"
//};
//creadb.CreateDatabase();
//var creadb = new SqlProxyCreateDatabase
//{
// DataSource = "USR-ROGLEDIMAU1",
// UserID = "sa",
// InitialCatalog = "PROVADB",
//};
//creadb.CreateDatabase();
SqlProxyDatabaseHelper.Password = "******";
//var sqlconnectiostring = new SqlProxyConnectionStringbuilder
//{
// DataSource = @"USR-ROGLEDIMAU1",
// UserID = "sa",
// InitialCatalog = "NORTHWIND"
//};
//ProxyProviderLoader.UseProvider = ProviderType.SQLite;
//var sqlconnectiostring = new SqlProxyConnectionStringbuilder
//{
// DataSource = @"D:\Utenti\Mauro\Desktop\Clothes.db"
//};
using (var connection = new SqlProxyConnection(sqlconnectiostring.ConnectionString))
{
connection.Open();
{
// var transaction = connection.BeginTransaction();
var p1 = new SqlProxyParameter("@p1", DbType.String, 16)
{
Value = "ARDUINO"
};
//var p1 = new SqlProxyParameter("@p1", DbType.Int16)
//{
// Value = 1
//};
//var p1 = new SqlProxyParameter("@p1", DbType.String, 5)
//{
// Value = "ALFKI"
//};
var dataSet = new DataSet();
//using (var sqlCmd = new SqlProxyCommand("SELECT * FROM CUSTOMERS where CustomerID = @p1"))
//using (var sqlCmd = new SqlProxyCommand("SELECT * FROM CL_MASTER where ID = @p1", connection))
using (var sqlCmd = new SqlProxyCommand(connection))
{
var p2 = sqlCmd.Parameters.Add(p1);
sqlCmd.CommandText = "SELECT * FROM PL_MASTERS where Code = @p1";
var dAdapter = new SqlProxyDataAdapter()
{
SelectCommand = sqlCmd
};
var cBuilder = new SqlProxyCommandBuilder(dAdapter)
{
QuotePrefix = "[",
QuoteSuffix = "]",
ConflictOption = ConflictOption.CompareRowVersion
};
//dAdapter.UpdateCommand = cBuilder.GetUpdateCommand();
dAdapter.InsertCommand = cBuilder.GetInsertCommand();
//dAdapter.DeleteCommand = cBuilder.GetDeleteCommand();
//dAdapter.RowUpdating += DAdapter_RowUpdating;
dAdapter.Fill(dataSet, "tablename");
var e = new RowUpdatedEventArgs(dataSet.Tables[0].Rows[0], new SqlCommand(), StatementType.Batch, new DataTableMapping());
//sqlCmd.Transaction = transaction;
//var sqldatareader = sqlCmd.ExecuteReader();
//sqldatareader.Read();
//var l = sqldatareader[3];
//sqldatareader.Close();
}
//transaction.Commit();
}
connection.Close();
}
}
protected override void AddParameters()
{
sqlP1 = AddParameters("@p50", EF_CounterValue.Type);
sqlP2 = AddParameters("@p51", EF_CounterValue.Code);
}
protected override void AddParameters()
{
sqlP1 = AddParameters("@p50", EF_Version.Module);
}
protected override void AddParameters()
{
sqlP1 = AddParameters("@p50", EF_Users.Username);
}
protected override void AddParameters()
{
sqlP1 = AddParameters("@p50", EF_Counter.Year);
sqlP2 = AddParameters("@p51", EF_Counter.Type);
}
protected override void AddParameters()
{
sqlP1 = AddParameters("@p50", EF_Preferences.PrefType);
sqlP2 = AddParameters("@p51", EF_Preferences.Application);
}
protected override void AddParameters()
{
sqlP1 = AddParameters("@p50", EF_CodeSegment.CodeType);
}
