public void DynamicSQLinq_Create_001() { var expected = "tblPerson"; var target = SQLinqHelper.Create(expected); Assert.AreEqual(expected, target.TableName); }
/// <summary> /// Creates an instance of SQLinq that is based off the specified Object Type. /// </summary> /// <typeparam name="T">The Type to use for creating the SQLinq instance.</typeparam> /// <param name="obj">The Object Type to base the SQLinq instance off of.</param> /// <param name="tableName">Optional. The database table name to use for generated SQL code. If specified, this will override the Objects name and/or SQLinqTable attribute usage.</param> /// <returns>A SQLinq instance.</returns> public static SQLinq <T> ToSQLinq <T>(this T obj, string tableName = null, ISqlDialect dialect = null) { if (dialect == null) { dialect = DialectProvider.Create(); } return(SQLinqHelper.Create(obj, tableName, dialect)); }
public void DynamicSQLinq_Oracle_Create_001() { var dialect = new SQLinq.OracleDialect(); var expected = "tblPerson"; var target = SQLinqHelper.Create(expected, dialect); Assert.AreEqual(expected, target.TableName); }
public void DynamicSQLinqSubQueryJoinExpression_ToSQL_003() { var query = SQLinqHelper.Create("test"); var alias = "name"; var clause = "1 = 1"; var param1 = "test"; var param2 = 2; var target = new DynamicSQLinqSubQueryJoinExpression(query, alias, clause, param1, param2); target.ToSQL(parameterNamePrefix: " "); }
public void DynamicSQLinqSubQueryJoinExpression_Constructor_001() { var query = SQLinqHelper.Create("test"); var alias = "name"; var clause = "1 = 1"; var param1 = "test"; var param2 = 2; var target = new DynamicSQLinqSubQueryJoinExpression(query, alias, clause, param1, param2); Assert.AreEqual(DynamicSQLinqJoinOperator.Inner, target.JoinOperator); Assert.AreEqual(query, target.Query); Assert.AreEqual(alias, target.Alias); Assert.AreEqual(clause, target.Clause); Assert.AreEqual(param1, target.Parameters[0]); Assert.AreEqual(param2, target.Parameters[1]); }