public SQLNET InternalValue(SqlString keyString, Type type, object value)
{
var key = keyString.Value;
var item = Item;
var sqlnet = this;
SQLNETParallelItem parallelValue;
// CREATE a new SQLNET from the root
if (ValueParallel == 0)
{
sqlnet = new SQLNET {ValueSerializable = ValueSerializable, ValueParallel = item.GetNextCountAndAddParallel()};
parallelValue = item.AddParallelValue(sqlnet.ValueParallel);
}
else
{
parallelValue = item.GetParallelValue(sqlnet.ValueParallel);
}
if (!item.IsCompiled)
{
//parallelValue.ParameterValues[key] = value;
parallelValue.ParameterValues.Add(key, value);
// Try to add type only if it's not compiled yet
item.ParameterTypes.TryAdd(key, type);
}
else
{
// AddOrUpdate value
parallelValue.ParameterValues[key] = value;
}
return sqlnet;
}
[SqlMethod(DataAccess = DataAccessKind.Read, SystemDataAccess = SystemDataAccessKind.Read)] // Required for static constructor
public static SQLNET New(string code)
{
if (code.Contains("defaultCommand") && !code.Contains("new SqlConnection("))
{
code = TemplateConnection.Replace("[SQLNET_Code]", code);
}
var sqlnet = new SQLNET {Item = new SQLNETItem()};
sqlnet.Item.Code = code;
return sqlnet;
}
[SqlMethod(DataAccess = DataAccessKind.Read, SystemDataAccess = SystemDataAccessKind.Read)] // Required for static constructor
public static SQLNET New(string code)
{
if (code.Contains("defaultCommand") && !code.Contains("new SqlConnection("))
{
code = TemplateConnection.Replace("[SQLNET_Code]", code);
}
var sqlnet = new SQLNET {
ValueSerializable = EvalManager.DefaultContext.GetNextCacheItemCounter()
};
var sqlnetitem = new SQLNETItem {
Code = code
};
EvalManager.CacheItem.TryAdd(sqlnet.ValueSerializable, sqlnetitem);
return(sqlnet);
}
public static void SQLNET_EvalResultSet(SQLNET sqlnet)
{
var value = sqlnet.Eval();
if (value is DataTable)
{
SqlContextHelper.SendDataTable((DataTable)value);
return;
}
if (value is DataSet)
{
var ds = (DataSet) value;
SqlContextHelper.SendDataSet(ds);
return;
}
SqlContextHelper.SendDataTable(DataTableHelper.GetDataTable(value));
}
public SQLNET InternalValue(SqlString keyString, Type type, object value)
{
var key = keyString.Value;
var item = Item;
var sqlnet = this;
SQLNETParallelItem parallelValue;
// CREATE a new SQLNET from the root
if (ValueParallel == 0)
{
sqlnet = new SQLNET {
ValueSerializable = ValueSerializable, ValueParallel = item.GetNextCountAndAddParallel()
};
parallelValue = item.AddParallelValue(sqlnet.ValueParallel);
}
else
{
parallelValue = item.GetParallelValue(sqlnet.ValueParallel);
}
if (!item.IsCompiled)
{
//parallelValue.ParameterValues[key] = value;
parallelValue.ParameterValues.Add(key, value);
// Try to add type only if it's not compiled yet
item.ParameterTypes.TryAdd(key, type);
}
else
{
// AddOrUpdate value
parallelValue.ParameterValues[key] = value;
}
return(sqlnet);
}
public static void SQLNET_EvalResultSet(SQLNET sqlnet)
{
var value = sqlnet.Eval();
if (value == null || value == DBNull.Value)
{
return;
}
if (value is DataTable)
{
SqlContextHelper.SendDataTable((DataTable)value);
return;
}
if (value is DataSet)
{
var ds = (DataSet)value;
SqlContextHelper.SendDataSet(ds);
return;
}
SqlContextHelper.SendDataTable(DataTableHelper.GetDataTable(value));
}
public static IEnumerable SQLNET_EvalTVF_3(SQLNET sqlnet)
{
var obj = sqlnet.Eval();
return(DataTableHelper.GetDataRows(obj));
}
public static IEnumerable SQLNET_EvalTVF_4(SQLNET sqlnet)
{
var obj = sqlnet.Eval();
return DataTableHelper.GetDataRows(obj);
}
/// <summary>Add or update a SQLNET value associated with the specified key.</summary>
/// <param name="key">The key of the value to add or update.</param>
/// <param name="value">The SQLNET value to add or update associated with the specified key.</param>
/// <returns>A fluent SQLNET object.</returns>
public SQLNET VALUESQLNET(SqlString key, SQLNET value)
{
return(ValueSQLNET(key, value));
}
/// <summary>Add or update a SQLNET value associated with the specified key.</summary>
/// <param name="key">The key of the value to add or update.</param>
/// <param name="value">The SQLNET value to add or update associated with the specified key.</param>
/// <returns>A fluent SQLNET object.</returns>
public SQLNET valuesqlnet(SqlString key, SQLNET value)
{
return(ValueSQLNET(key, value));
}
/// <summary>Add or update a SQLNET value associated with the specified key.</summary>
/// <param name="key">The key of the value to add or update.</param>
/// <param name="value">The SQLNET value to add or update associated with the specified key.</param>
/// <returns>A fluent SQLNET object.</returns>
public SQLNET ValueSQLNET(SqlString key, SQLNET value)
{
var internalValue = value.GetValue(InternalValueName);
return(InternalValue(key, internalValue.GetType(), internalValue));
}
/// <summary>Add or update a SQLNET value associated with the specified key.</summary>
/// <param name="key">The key of the value to add or update.</param>
/// <param name="value">The SQLNET value to add or update associated with the specified key.</param>
/// <returns>A fluent SQLNET object.</returns>
public SQLNET VALUESQLNET(SqlString key, SQLNET value)
{
return ValueSQLNET(key, value);
}
/// <summary>Add or update a SQLNET value associated with the specified key.</summary>
/// <param name="key">The key of the value to add or update.</param>
/// <param name="value">The SQLNET value to add or update associated with the specified key.</param>
/// <returns>A fluent SQLNET object.</returns>
public SQLNET valuesqlnet(SqlString key, SQLNET value)
{
return ValueSQLNET(key, value);
}
/// <summary>Add or update a SQLNET value associated with the specified key.</summary>
/// <param name="key">The key of the value to add or update.</param>
/// <param name="value">The SQLNET value to add or update associated with the specified key.</param>
/// <returns>A fluent SQLNET object.</returns>
public SQLNET ValueSQLNET(SqlString key, SQLNET value)
{
var internalValue = value.GetValue(InternalValueName);
return InternalValue(key, internalValue.GetType(), internalValue);
}
[SqlMethod(DataAccess = DataAccessKind.Read, SystemDataAccess = SystemDataAccessKind.Read)] // Required for static constructor
public static SQLNET New(string code)
{
if (code.Contains("defaultCommand") && !code.Contains("new SqlConnection("))
{
code = TemplateConnection.Replace("[SQLNET_Code]", code);
}
var sqlnet = new SQLNET {ValueSerializable = EvalManager.DefaultContext.GetNextCacheItemCounter()};
var sqlnetitem = new SQLNETItem {Code = code};
EvalManager.CacheItem.TryAdd(sqlnet.ValueSerializable, sqlnetitem);
return sqlnet;
}
