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); }