private string GetConnectionString() { LoginInfo li = GlobalInfo.LoginInfo; var sqlconnectionstring = new SqlProxyConnectionStringbuilder { DataSource = li.DataSource, UserID = li.UserID, Password = li.Password, InitialCatalog = li.InitialCatalog, IntegratedSecurity = li.AuthenicationMode == AuthenticationMode.Windows }; return(sqlconnectionstring.ConnectionString); }
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(); } }