public void SelectTest1()
{
string sql = File.ReadAllText(@"c:\requeteOrqua.txt");
var forms = new List<FILE_FORM>();
using (var db = new MusicDB())
{
//var query = from f in
using (var a = new ExecTimeInfo())
{
//db.SetCommand(sql);
//var reader = db.ExecuteReader();
//var schemaTable = reader.GetSchemaTable();
//while (reader.Read())
//{
// //var values = new object[schemaTable.Columns.Count];
// //reader.GetValues(values);
// reader.GetValue(0);
//}
DbManager dbCmd = db.SetCommand(sql);
dbCmd.MappingSchema = new FullMappingSchema(inheritedMappingSchema: dbCmd.MappingSchema, mappingOrder: MappingOrder.ByColumnName,
ignoreMissingColumns: true, ignoreLazyLoad: false);
var allMedia = dbCmd.ExecuteList<FILE_FORM>();
forms = allMedia;
foreach (FILE_FORM fileForm in allMedia)
{
if (fileForm.SCRIPT_FIELD != null && !fileForm.SCRIPT_FIELD.IsNull)
{
//string clobValue = fileForm.SCRIPT_FIELD.Value;
}
}
}
}
}
private static void GetMediaLinq()
{
var all = new List<long> {21, 24, 25, 27, 38, 221};
using (var db = new MusicDB())
{
using (var a = new ExecTimeInfo())
{
var query = from m in db.GetTable<Media>()
join basicMedia in db.GetTable<BasicMedia>() on m.ID_BASIC_MEDIA equals
basicMedia.ID_BASIC_MEDIA
where m.ACTIVATION == 0 && basicMedia.ACTIVATION == 0 && all.Contains(basicMedia.ID_CATEGORY)
select m;
var allMedia = query.ToList();
}
using (var a = new ExecTimeInfo())
{
var query = from m in db.GetTable<Media>()
join basicMedia in db.GetTable<BasicMedia>() on m.ID_BASIC_MEDIA equals
basicMedia.ID_BASIC_MEDIA
where m.ACTIVATION == 0 && basicMedia.ACTIVATION == 0 && all.Contains(basicMedia.ID_CATEGORY)
select m;
var allMedia = query.ToList();
}
using (var a = new ExecTimeInfo())
{
var query = from basicMedia in db.GetTable<BasicMedia>()
where basicMedia.ACTIVATION == 0
select basicMedia;
var allMedia = query.ToList();
}
using (var a = new ExecTimeInfo())
{
var query = from basicMedia in db.GetTable<BasicMedia>()
where basicMedia.ACTIVATION == 0
select basicMedia;
var allMedia = query.ToList();
}
}
}
private static void GetMediaReq(string req)
{
using (var db = new MusicDB())
{
using (var a = new ExecTimeInfo())
{
db.SetCommand(req);
var allMedia = db.ExecuteList<Media>();
}
using (var a = new ExecTimeInfo())
{
db.SetCommand(req);
var allMedia = db.ExecuteList<Media>();
}
}
}
