public static void ExecuteCommand(string commandName, Action <DataCommand> exec)
{
TryDo <DataCommand>(() =>
{
exec(DataCommandDetector.GetDataCommand(commandName));
return(null);
});
}
public static int ExecuteNonQuery(string commandName, IDataParameter[] dps)
{
return(TryDo(() =>
{
DataCommand dataCommand = DataCommandDetector.GetDataCommand(commandName);
BuilderCommandParame(dps, dataCommand);
return dataCommand.ExecuteNonQuery();
}));
}
public static T ExecuteDataReader <T>(string commandName, IDataParameter[] dps, Func <IDataReader, T> executeRead)
{
return(TryDo(() =>
{
DataCommand dataCommand = DataCommandDetector.GetDataCommand(commandName);
BuilderCommandParame(dps, dataCommand);
if (executeRead != null)
{
using (IDataReader reader = dataCommand.ExecuteDataReader())
{
return executeRead(reader);
}
}
return default(T);
}));
}
public static T ExecuteScalar <T>(string commandName, IDataParameter[] dps)
{
return(TryDo(() =>
{
T result = default(T);
DataCommand dataCommand = DataCommandDetector.GetDataCommand(commandName);
BuilderCommandParame(dps, dataCommand);
object obj = dataCommand.ExecuteScalar();
try
{
if (obj != null)
{
result = (T)obj;
}
}
catch
{
result = default(T);
}
return result;
}));
}
