public void ExistsWhere()
{
var models = this.AddMockModels();
var model = models.RandomOne();
var command = new CMD.Exists <Models.Member>()
{
Where = WhereParameters.Parse(this.Engine, new { model.Username }),
};
Assert.True(this.Execute(command).Result);
command.Where = WhereParameters.Parse(this.Engine, new { Username = "******" });
Assert.False(this.Execute(command).Result);
}
public void Exists()
{
var models = this.AddMockModels();
var model = models.RandomOne();
var command = new CMD.Exists <Models.Member>()
{
Where = WhereParameters.Parse(this.Engine, new Data.ExecuteParameterCollection(DbExtensions.GetKeyValues <Models.Member>(null, model.Id)))
};
Assert.True(this.Execute(command).Result);
command.Where = WhereParameters.Parse(this.Engine, new Data.ExecuteParameterCollection(DbExtensions.GetKeyValues <Models.Member>("Username", model.Username)));
Assert.True(this.Execute(command).Result);
command.Where = WhereParameters.Parse(this.Engine, new Data.ExecuteParameterCollection(DbExtensions.GetKeyValues <Models.Member>("Username", "A$$$$$$$$$$")));
Assert.False(this.Execute(command).Result);
}
public void Exists()
{
var models = this.AddMockModels();
var model = models.RandomOne();
var command = new CMD.Exists <Models.Member>()
{
KeyValue = model.Id
};
Assert.True(this.Execute(command).ResultValue);
command.KeyName = "Username";
command.KeyValue = model.Username;
Assert.True(this.Execute(command).ResultValue);
command.KeyName = "Username";
command.KeyValue = "A$$$$$$$$$$";
Assert.False(this.Execute(command).ResultValue);
}
public void ExistsWhere()
{
var models = this.AddMockModels();
var model = models.RandomOne();
var command = new CMD.Exists<Models.Member>()
{
Where = WhereParameters.Parse(this.Engine, new { model.Username }),
};
Assert.True(this.Execute(command).Result);
command.Where = WhereParameters.Parse(this.Engine, new { Username = "******" });
Assert.False(this.Execute(command).Result);
}
public void Exists()
{
var models = this.AddMockModels();
var model = models.RandomOne();
var command = new CMD.Exists<Models.Member>()
{
Where = WhereParameters.Parse(this.Engine, new Data.ExecuteParameterCollection(DbExtensions.GetKeyValues<Models.Member>(null, model.Id)))
};
Assert.True(this.Execute(command).Result);
command.Where = WhereParameters.Parse(this.Engine, new Data.ExecuteParameterCollection(DbExtensions.GetKeyValues<Models.Member>("Username", model.Username)));
Assert.True(this.Execute(command).Result);
command.Where = WhereParameters.Parse(this.Engine, new Data.ExecuteParameterCollection(DbExtensions.GetKeyValues<Models.Member>("Username", "A$$$$$$$$$$")));
Assert.False(this.Execute(command).Result);
}
