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; }