public void QueryBuilder_ShouldMapProperty() { var builder = new MockSqlQueryBuilder <Customer>(); builder.MapProperty(c => c.FirstName, "FName"); builder.GetResult(); Assert.True(builder.InternalProps.PropertyMappings.First(pm => pm.PropertyName == "FirstName").ColumnName == "FName"); }
public void QueryBuilder_ShouldSetIgnoreDataColumnNotFound() { var builder = new MockSqlQueryBuilder <Customer>(); builder.SetIgnoreDataColumnNotFound(false); builder.GetResult(); Assert.False(builder.InternalProps.IgnoreDataColumnNotFound); }
public void QueryBuilder_ShouldSetCommandTimeout() { var builder = new MockSqlQueryBuilder <Customer>(); builder.SetCommandTimeout(300); builder.GetResult(); Assert.True(builder.InternalProps.CommandTimeout == 300); }
public void QueryBuilder_ShouldAddParameterWithDirection() { var builder = new MockSqlQueryBuilder <Customer>(); builder.AddParameter("@test", "testValue", QueryParameterDirectionEnum.Output); builder.GetResult(); Assert.True(builder.InternalProps.Parameters.Cast <QueryParameter>().First(p => p.Name == "@test").Direction == QueryParameterDirectionEnum.Output); }
public void QueryBuilder_ShouldAddParameterWhenConditionIsTrue() { var builder = new MockSqlQueryBuilder <Customer>(); builder.AddParameter(() => true, "@test", "testValue"); builder.GetResult(); Assert.True(builder.InternalProps.Parameters.Cast <QueryParameter>().First(p => p.Name == "@test").Value == "testValue"); }
public void QueryBuilder_ShouldSetConnectionString() { var connString = "Some Connection String"; var builder = new MockSqlQueryBuilder <Customer>(); builder.SetConnectionString(connString); builder.GetResult(); Assert.True(builder.InternalProps.ConnString == connString); }
public void QueryBuilder_ShouldNotAddParameterWhenConditionIsFalse() { var builder = new MockSqlQueryBuilder <Customer>(); builder.AddParameter(() => true, "@testTrue", "testValue"); builder.AddParameter(() => false, "@testFalse", "testValue"); builder.GetResult(); Assert.True(builder.InternalProps.Parameters.Cast <QueryParameter>().Any(p => p.Name == "@testFalse") == false); }
public void QueryBuilder_ShouldSetStoredProcedure() { var storedProcName = "someStoredProc"; var builder = new MockSqlQueryBuilder <Customer>(); builder.SetStoredProcedure(storedProcName); builder.GetResult(); Assert.True(builder.InternalProps.CommandType == CommandType.StoredProcedure); Assert.True(builder.InternalProps.CommandText == storedProcName); }
public void QueryBuilder_ShouldSetSql() { var sql = "select someThing from someTable"; var builder = new MockSqlQueryBuilder <Customer>(); builder.SetSql(sql); builder.GetResult(); Assert.True(builder.InternalProps.CommandType == CommandType.Text); Assert.True(builder.InternalProps.CommandText == sql); }
public void QueryBuilder_ShouldAddQueryParameter_Char() { var builder = new MockSqlQueryBuilder <Customer>(); builder.AddParameter(new QueryParameter { Name = "@test", Value = "testValue", DataType = DataTypeEnum.Char, Size = 10 }); builder.GetResult(); Assert.True(builder.InternalProps.Parameters.Cast <QueryParameter>().First(p => p.Name == "@test" && p.DataType == DataTypeEnum.Char && p.Size == 10).Value == "testValue"); }
public void QueryBuilder_ShouldMapPropertyFunction() { var dataRow = new DataValueList(); dataRow.Add(new DataValue { ColumnName = "FName", Value = "Joe" }); var builder = new MockSqlQueryBuilder <Customer>(); builder.MapProperty(c => c.FirstName, row => row.GetString("FName")); builder.GetResult(); Assert.True(builder.InternalProps.PropertyMappings.First(pm => pm.PropertyName == "FirstName").PropertyMapperDataRow(dataRow) == "Joe"); }
public void QueryBuilder_ShouldMapObject() { var dataRow = new DataValueList(); dataRow.Add(new DataValue { ColumnName = "FName", Value = "Joe" }); var builder = new MockSqlQueryBuilder <Customer>(); builder.MapObject(row => new Customer { FirstName = row.GetString("FName") }); builder.GetResult(); Assert.True(builder.InternalProps.DataRowMapper(dataRow).FirstName == "Joe"); }