public int Count()
{
var result = 0;
var sql = $"select count(1) from actor;";
var reader = _runner.OpenReader(sql, null);
if (reader.Read())
{
result = System.Convert.ToInt32(reader[0]);
}
return(result);
}
public dynamic GetOneDynamic(int id)
{
dynamic result = null;
var args = new object[] { id };
var sql =
"select * from actor where actor_id=@0;";
using (var reader = _runner.OpenReader(sql, args))
{
if (reader.Read())
{
result = reader.ToExpando();
}
}
return(result);
}
public int GetActorsCount(int filmId)
{
var count = 0;
var sql =
"SELECT (SELECT * FROM (SELECT count(1) FROM film_actor WHERE film_actor.film_id = film.film_id)x)"
+ "FROM film WHERE film_id = @0;";
using (var reader = _runner.OpenReader(sql, filmId))
{
if (reader.Read())
{
count = Convert.ToInt32(reader[0]);
}
}
return(count);
}
public Artist GetByAlbums(int id)
{
var result = new Artist();
var artistSql = @"select artist_id as Id , name as Name from artist where artist_id = @0;";
var albumSql = @"select album_id as Id , title as Title from album where artist_id = @0;";
using (var reader = _runner.OpenReader(artistSql + albumSql, new object[] { id }))
{
if (reader.Read())
{
result = reader.ToSingle <Artist>();
reader.NextResult();
result.Albums = reader.ToList <Album>();
}
reader.Dispose();
}
return(result);
}
