public static IDbDataParameter ToDbDataParameter(DatabaseAccessAdapter adapter, NSJSValue value)
{
if (adapter == null)
{
return(null);
}
NSJSObject o = value as NSJSObject;
if (o == null)
{
return(null);
}
string name = (o.Get("Name") as NSJSString)?.Value;
if (string.IsNullOrEmpty(name))
{
return(null);
}
object rax = o.Get("Value").As <object>();
return(adapter.CreateParameter(name, rax));
}
public static IDbCommand ToDbCommand(DatabaseAccessAdapter adapter, string text,
int startIndex, IEnumerable <NSJSValue> arguments)
{
if (startIndex < 0 || adapter == null || string.IsNullOrEmpty(text))
{
return(null);
}
IDbCommand command = adapter.CreateCommand();
command.CommandText = text;
IDataParameterCollection parameters = command.Parameters;
if (arguments != null)
{
int solt = 0;
foreach (NSJSValue item in arguments)
{
try
{
if (startIndex > solt)
{
continue;
}
IDbDataParameter parameter = ToDbDataParameter(adapter, item);
if (parameter == null)
{
continue;
}
parameters.Add(parameter);
}
finally
{
solt++;
}
}
}
return(command);
}
public static IDbCommand ToDbCommand(DatabaseAccessAdapter adapter, string text, IEnumerable <NSJSValue> arguments)
{
return(ToDbCommand(adapter, text, 0, arguments));
}
