public ErrorLog FindById(Guid errorLogId)
{
try
{
const string query = @"SELECT
[ErrorLogId],
[Message],
[InnerException],
[CreatedById],
[CreatedByOn],
[CreatedByIp],
[ModifiedById],
[ModifiedOn],
[ModifiedByIp]
FROM User
WHERE ErrorLogId = @ErrorLogId" ;
using (var connection = _factory.GetConnection())
{
return(connection.Query <ErrorLog>(query, new
{
ErrorLogId = errorLogId
}).FirstOrDefault());
}
}
catch (Exception ex)
{
return(new ErrorLog());
}
}
public User FindById(Guid userId)
{
try
{
const string query = @"SELECT
[UserId],
[Email],
[CreatedById],
[CreatedByOn],
[CreatedByIp],
[ModifiedById],
[ModifiedOn],
[ModifiedByIp]
FROM User
WHERE UserId = @UserId" ;
using (var connection = _factory.GetConnection())
{
return(connection.Query <User>(query, new
{
UserId = userId
}).FirstOrDefault());
}
}
catch (Exception ex)
{
return(new User());
}
}
public void TestMsConnection()
{
IDbConnection conn = DbConnectionFactory.GetConnection(DbSource.MicrosoftSQL);
var res = conn.Query(@"select product_id from lovelife_dev.dbo.product_info");
conn.Execute(@"INSERT INTO lovelife_dev.dbo.product_info (product_id)
VALUES (456);");
Console.WriteLine(res);
}
public void ShouldGetPostgresSqlConnection()
{
// Arrange
var dbConnectionFactory = new DbConnectionFactory();
var dbType = DatabaseType.PostgreSQL;
var connectionString = "";
// Act
var sut = dbConnectionFactory.GetConnection(dbType, connectionString);
// Assert
TestConnection(sut, connectionString);
}
public void ShouldGetSQLConnection()
{
//Given / Arrange
var dbConnectionFactory = new DbConnectionFactory();
var dbType = DatabaseType.SqlServer;
var connectionString = "";
//When / Act
var sut = dbConnectionFactory.GetConnection(dbType, connectionString);
//Then / Assert
TestConnection(sut, connectionString);
}
public async Task DeclareAnimeToBeDisplayedAsync(IEnumerable <int> malAnimeIds)
{
if (DbConnectionFactory == null)
{
return; // Null is passed when precompiling the views
}
using (IAnimeRecsDbConnection conn = DbConnectionFactory.GetConnection())
{
await conn.OpenAsync().ConfigureAwait(false);
StreamsByAnime = await conn.GetStreamsAsync(malAnimeIds).ConfigureAwait(false);
}
}
public MsProductRepository()
{
_conn = DbConnectionFactory.GetConnection(DbSource.MicrosoftSQL);
}