public string GetNew() { using (var conn = DataSourceUtil.GetConnection(DataSource, ConnectString)) { string connectString = ""; var cmd = conn.CreateCommand(); cmd.CommandText = QueryString; cmd.CommandType = CommandType.Text; conn.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { connectString = reader.GetString(0); } return(connectString); } }
protected List <Dictionary <string, object> > PrepareDatas() { List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); NetworkCenter.Current.Execute("db-pstu", () => { using (var conn = DataSourceUtil.GetConnection(Source, ConnectString)) { conn.Open(); var command = conn.CreateCommand(); command.CommandText = QueryString; command.CommandTimeout = 60000; command.CommandType = CommandType.Text; var reader = command.ExecuteReader(); while (reader.Read()) { Dictionary <string, object> data = new Dictionary <string, object>(); int count = reader.FieldCount; for (int i = 0; i < count; ++i) { string name = reader.GetName(i); data.Add(name, reader.GetValue(i)); } if (Extras != null) { foreach (var extra in Extras) { data.Add(extra.Key, extra.Value); } } list.Add(data); } #if !NET_CORE reader.Close(); #else reader.Dispose(); #endif } }); return(list); }