bool IsValid(DbView dbView)
{
// TODO
var query = dbView.CreateViewQuery;
return(false);
}
public IEnumerable <DbEntry> GetDbEntries(string connectionString, DbView dbView)
{
var query = dbView.GetFullSelectQuery();
var businessColumnCount = dbView.BusinessIdColumnNameList.Count;
var columnCount = dbView.ColumnNameList.Count;
var createViewQuery = dbView.CreateViewQuery;
var cnn = new SqlConnection(connectionString);
cnn.Open();
var sqlTransaction = cnn.BeginTransaction();
try
{
var createViewCmd = new SqlCommand(createViewQuery, cnn, sqlTransaction);
createViewCmd.ExecuteNonQuery();
var cmd = new SqlCommand(query, cnn, sqlTransaction);
using (var dataReader = cmd.ExecuteReader())
{
while (dataReader.Read())
{
var businessIdColumnList = new List <string>();
for (var i = 0; i < businessColumnCount; i++)
{
var businessColumnContent = dataReader.GetValue(i).ToString();
businessIdColumnList.Add(businessColumnContent);
}
var columnList = new List <string>();
for (var i = businessColumnCount; i < businessColumnCount + columnCount; i++)
{
var columnContent = dataReader.GetValue(i).ToString();
columnList.Add(columnContent);
}
var dbEntry = new DbEntry
{
BusinessId = new DbBusinessId(dbView.ViewName, businessIdColumnList.ToArray()),
ColumnList = columnList
};
yield return(dbEntry);
}
}
}
finally
{
sqlTransaction.Rollback();
}
cnn.Close();
}
public SqlDbStateReference GetSqlDbStateReference(string connectionString, DbView dbView)
{
var stateReference = new SqlDbStateReference(new SqlService(), connectionString, dbView);
return(stateReference);
}
public SqlDbStateReference(SqlService sqlService, string connectionString, DbView dbView)
{
_sqlService = sqlService;
_connectionString = connectionString;
DbView = dbView;
}
public DbState(DbView dbView, IEnumerable <DbEntry> dbEntries)
{
DbView = dbView;
DbEntryList = dbEntries.ToList();
}
