public static string GetQualifiedTableOrViewName <TEntity>(this IDbTest test, string tableOrViewName = null, string schema = null, bool isRequired = true) { if (string.IsNullOrEmpty(tableOrViewName)) { var info = test.GetTableOrViewInfoFromTest(); tableOrViewName = info.Name; schema = info.Schema; if (String.IsNullOrEmpty(info.Name)) { info = GetTableOrViewInfoFromType(typeof(TEntity)); tableOrViewName = info.Name; schema = info.Schema; } } if (string.IsNullOrEmpty(tableOrViewName)) { if (isRequired) { throw new DbTestException("Failed to run test. Missing required tableOrViewName value."); } return(null); } tableOrViewName = tableOrViewName.Trim(); schema = (schema ?? "dbo").Trim(); if (!tableOrViewName.StartsWith("[")) { tableOrViewName = $"[{tableOrViewName}]"; } if (!schema.StartsWith("[")) { schema = $"[{schema}]"; } return($"{schema}.{tableOrViewName}"); }
public static SqlRequest InvokeScalarFunction(this IDbTest test, string functionName, string schema = null, params SqlParameter[] parameters) { var sql = new StringBuilder($"Select {(!string.IsNullOrEmpty(schema) ? $"{schema}." : "")}{functionName}("); var firstParam = true; foreach (var p in parameters) { if (firstParam) { firstParam = false; } else { sql.Append(", "); } sql.Append(p.ParameterName); } sql.Append(") as RetVal"); return(SqlRequest.RunSqlText(sql.ToString(), parameters)); }
public static SqlRequest ReturnAllRows <TEntity>(this IDbTest test, params SqlParameter[] parameters) { return(SqlRequest.ReturnAllRows(test.GetQualifiedTableOrViewName <TEntity>(), parameters)); }
private static (string Name, string Schema) GetTableOrViewInfoFromTest(this IDbTest test) { return(GetTableOrViewInfoFromType(test.GetType())); }
public static SqlRequest RunTableDirect <TEntity>(this IDbTest test, params SqlParameter[] parameters) { return(SqlRequest.RunTableDirect(test.GetQualifiedTableOrViewName <TEntity>(), parameters)); }
public static string GetQualifiedTableOrViewName(this IDbTest test, string tableOrViewName = null, string schema = null, bool isRequired = true) { return(test.GetQualifiedTableOrViewName <object>(tableOrViewName, schema, isRequired)); }
public static SqlRequest RunTableDirect(this IDbTest test, string tableName = null, string schema = null, params SqlParameter[] parameters) { return(SqlRequest.RunTableDirect(test.GetQualifiedTableOrViewName(tableName, schema), parameters)); }
public static SqlRequest ExecuteStoredProcedure(this IDbTest test, string sprocName = null, string schema = null, params SqlParameter[] parameters) { return(SqlRequest.RunStoredProcedure(sprocName, schema, parameters)); }
public static SqlRequest RunSqlText(this IDbTest test, string sql = null, params SqlParameter[] parameters) { return(SqlRequest.RunSqlText(sql, parameters)); }
public static SqlRequest DoNothing(this IDbTest test) { return(null); }
public static SqlRequest CommitDataContextNow(this IDbTest test) { return(SqlRequest.CommitDataContextNow()); }