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