public DbDataReader ExecuteSelect(string query) { DbConnection cnn = factory.GetConnection(); cnn.ConnectionString = AppSettings.ConnectionString; DbCommand cmd = factory.GetCommand(); cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = query; cnn.Open(); return(cmd.ExecuteReader(CommandBehavior.CloseConnection)); }