/// <summary>
/// Loads the one.
/// </summary>
/// <param name="commandText">The command text.</param>
/// <param name="commandBehavior">The command behavior.</param>
/// <param name="parameters">The parameters.</param>
/// <returns></returns>
public T LoadOne(String commandText, System.Data.CommandBehavior commandBehavior, params SqlCeParameter[] parameters)
{
_affectedRows = 0;
using (SqlCeDataReader reader = _dataAccess.GetDataReader(commandText, commandBehavior, parameters)) {
var builder = new ReflectionBuilder <T>();
while (reader.Read())
{
_affectedRows += 1;
return(builder.Build(reader));
}
}
return(default(T));
}
/// <summary>
/// Loads the observable collection.
/// </summary>
/// <param name="commandText">The command text.</param>
/// <param name="commandBehavior">The command behavior.</param>
/// <param name="parameters">The parameters.</param>
/// <returns></returns>
public ObservableCollection <T> LoadObservableCollection(String commandText, System.Data.CommandBehavior commandBehavior, params SqlCeParameter[] parameters)
{
var objResult = new ObservableCollection <T>();
using (SqlCeDataReader reader = _dataAccess.GetDataReader(commandText, commandBehavior, parameters)) {
var builder = new ReflectionBuilder <T>();
while (reader.Read())
{
objResult.Add(builder.Build(reader));
}
}
_affectedRows = objResult.Count;
return(objResult);
}
/// <summary>
/// Loads the list.
/// </summary>
/// <param name="commandText">The command text.</param>
/// <param name="commandBehavior">The command behavior.</param>
/// <param name="parameters">The parameters.</param>
/// <returns></returns>
public List <T> LoadList(String commandText, System.Data.CommandBehavior commandBehavior, params SqlCeParameter[] parameters)
{
var result = new List <T>();
using (SqlCeDataReader reader = _dataAccess.GetDataReader(commandText, commandBehavior, parameters)) {
var objBuilder = new ReflectionBuilder <T>();
while (reader.Read())
{
result.Add(objBuilder.Build(reader));
}
}
_affectedRows = result.Count;
return(result);
}
