public void T2_View_Returns_Expected_Values_Programmaticaly()
{
using (SqlConnection connection = new SqlConnection(DbInit.GetDbConnectionString()))
{
connection.Open();
ResetTable(connection);
List <View> results = DbViews.GetViewValues(connection).ToList();
Compare(results, GetAllUser()).Should().BeTrue();
}
}
public void T1_Create_StudentsView()
{
using (SqlConnection connection = new SqlConnection(DbInit.GetConnectionString()))
{
connection.Open();
ScriptExecutor exe = new ScriptExecutor();
exe.ScriptExe(DbViews.Views(), connection);
string cmdText = @"USE itiSchoolDB IF EXISTS (SELECT * FROM sys.objects WHERE type = 'V' AND name = 'StudentsView') SELECT 1 ELSE SELECT 0";
SqlCommand DateCheck = new SqlCommand(cmdText, connection);
int x = Convert.ToInt32(DateCheck.ExecuteScalar());
x.Should().Be(1);
// Check if already Exist
exe.ScriptExe(DbViews.Views(), connection);
}
}
public WeatherForecastController(ILogger <WeatherForecastController> logger, ApplicationDbContext context, IHubContext <WeatherHub> hub)
{
_weatherHubContext = hub;
_logger = logger;
_db = new DbViews(context);
}
