public void Devo_Conseguir_Inserir_Registros()
{
List<tblCommand> tblCommand;
using (var context = new TblCommandDbContext("Data Source=.;Initial Catalog=TFS_DefaultCollection;Integrated Security=SSPI"))
{
var sql = new StringBuilder()
.AppendLine("select UserName, UserAgent, convert(date, StartTime) StartTime, count(UserName) Quantity")
.AppendLine("from tbl_Command")
.AppendLine("group by UserName, UserAgent, convert(date, StartTime)").ToString();
tblCommand = context.Database.SqlQuery<tblCommand>(sql).ToList();
Assert.IsNotNull(tblCommand);
Assert.IsTrue(tblCommand.Count() > 0);
}
using (var context = new TFSUsersDbContext())
{
context.Database.CreateIfNotExists();
tblCommand.ForEach(x => context.TfsUsers.Add(new TFSUsers(x.UserName, x.UserAgent, x.StartTime, x.Quantity)));
context.SaveChanges();
Assert.IsTrue(context.TfsUsers.Count() > 0);
}
}
public void Devo_Conseguir_Fazer_Um_Select_Na_TblCommand()
{
using (var context = new TblCommandDbContext("Data Source=.;Initial Catalog=TFS_DefaultCollection;Integrated Security=SSPI;"))
{
var sql = new StringBuilder()
.AppendLine("select UserName, UserAgent, convert(date, StartTime) StartTime, count(UserName) Quantity")
.AppendLine("from tbl_Command")
.AppendLine("group by UserName, UserAgent, convert(date, StartTime)").ToString();
var lista = context.Database.SqlQuery<tblCommand>(sql).ToList();
Assert.IsNotNull(lista);
Assert.IsTrue(lista.Count() > 0);
}
}