/// <summary>
/// Prepares and executes a database query and creates a <see cref="View">View</see> object.
/// </summary>
/// <param name="query">Specifies a SQL query string for querying the database.</param>
/// <returns>A view object is returned if the query was successful.</returns>
public View OpenExecuteView(string query)
{
View view = new View(this, query);
view.Execute();
return view;
}
/// <summary>
/// Executes the view to fetch the value for a specified property.
/// </summary>
/// <param name="view">View that is already open on the Property table.</param>
/// <param name="propertyName">Name of the property to get the value for.</param>
/// <returns>String value of the property.</returns>
private string FetchPropertyValue(View view, string propertyName)
{
string propertyValue = null;
using (Record recIn = new Record(1))
{
recIn[1] = propertyName;
view.Execute(recIn);
using (Record recOut = view.Fetch())
{
if (recOut != null)
{
propertyValue = recOut[1];
}
}
}
return propertyValue;
}