public static List <VideoAlternative> List(int frameId)
{
List <VideoAlternative> list = null;
string sql = string.Format(
"SELECT c.ContentId, Name, convert(varbinary(256),Data) Chunk, c.Version FROM VideoAlternative a INNER JOIN Content c ON c.ContentId=a.ContentId WHERE a.FrameId={0};",
frameId
);
using (DataSet ds = DataAccess.RunSql(sql))
{
int count = ds.Tables[0].Rows.Count;
list = new List <VideoAlternative>(count);
if (count > 0)
{
list.Capacity = count;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["Chunk"] != DBNull.Value)
{
VideoAlternative va = new VideoAlternative();
va._initFromRow(dr);
va.CacheKey = va.cacheKeyForVideoId(frameId);
list.Add(va);
}
}
}
}
return(list);
}
public static List <VideoAlternative> List(int frameId)
{
List <VideoAlternative> list = new List <VideoAlternative>();
using (SqlCommand cmd = new SqlCommand()
{
CommandType = CommandType.Text,
CommandText =
"SELECT a.FrameId, c.ContentId, Name, convert(varbinary(256),Data) Chunk, c.Version FROM VideoAlternative a " +
"INNER JOIN Content c ON c.ContentId=a.ContentId WHERE a.FrameId=@frameId",
})
{
cmd.Parameters.AddWithValue("@frameId", frameId);
cmd.ExecuteReaderExt((dr) =>
{
VideoAlternative va = new VideoAlternative();
va._initFromRow(dr);
list.Add(va);
return(true);
});
}
return(list);
}
public static List<VideoAlternative> List(int frameId)
{
List<VideoAlternative> list = null;
string sql = string.Format(
"SELECT c.ContentId, Name, convert(varbinary(256),Data) Chunk, c.Version FROM VideoAlternative a INNER JOIN Content c ON c.ContentId=a.ContentId WHERE a.FrameId={0};",
frameId
);
using (DataSet ds = DataAccess.RunSql(sql))
{
int count = ds.Tables[0].Rows.Count;
list = new List<VideoAlternative>(count);
if (count > 0)
{
list.Capacity = count;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["Chunk"] != DBNull.Value)
{
VideoAlternative va = new VideoAlternative();
va._initFromRow(dr);
va.CacheKey = va.cacheKeyForVideoId(frameId);
list.Add(va);
}
}
}
}
return list;
}
