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