Загрузка данных


       using var context = new PortContext();

       var r1 = context.Ships.Where(s => s.ShipTypeId == 1);
       var r2 = context.Ships.Where(s => s.Flag == "Панама");
       var r3 = context.Ships.Where(s => s.Flag != "Россия");
       var r4 = context.Ships.Where(s => s.Flag == "Мальта" && s.Flag == "Либерия");
       var r5 = context.Ships.Where(s => s.BuiltYear >= 2005 && s.BuiltYear <= 2015);
       var r6 = context.Ships.Where(s => s.LengthM > 250);
       var r7 = context.Ships.Where(s => s.DeadweightT < 30000);
       var r8 = context.Ships.Where(s => s.Name.ToLower().Contains("а"));
       var r9 = context.Ships.Where(s => s.Name.StartsWith("A"));
       var r10 = context.Ships.Where(s => (s.Name[0] >= 'А' && s.Name[0] <= 'Я') || (s.Name[0] >= 'а' && s.Name[0] <= 'я'));
       var r11 = context.Ships.Where(s => s.Flag == "Россия" && s.BuiltYear >= 2005);
       var r12 = context.Berths.Where(b => b.MaxLengthM > 250);
       var r13 = context.Berths.Where(b => b.MaxDraftM < 12);
       var r14 = context.Berths.Where(b => b.IsActive == false);
       var r15 = context.Berths.Where(b => b.Code.StartsWith("B"));
       var r16 = context.PortCalls.Where(p => p.Status == "departed");
       var r17 = context.PortCalls.Where(p => p.Arrival >= new DateTime(2026, 8, 1) && p.Arrival < new DateTime(2026, 9, 1));
       var r18 = context.PortCalls.Where(p => p.BerthId == 1);
       var r19 = context.PortCalls.Where(p => p.Departure != null);
       var r20 = context.PortCalls.Where(p => p.Arrival.TimeOfDay < new TimeSpan(12, 0, 0));
       var r21 = context.PortCalls.Where(p => p.Arrival.DayOfWeek == DayOfWeek.Saturday || p.Arrival.DayOfWeek == DayOfWeek.Sunday);
       var r22 = context.CargoTypes.Where(ct => ct.IsDangerous == false);
       var r23 = context.CargoOperations.Where(co => co.Operation == "unload");
       var r24 = context.CargoOperations.Where(co => co.QuantityT > 20000);
       var r25 = context.CargoOperations.Where(co => co.CargoTypeId == 1 && co.PortCallId == 1);
       
       int[] shipIds = { 2, 4, 6 };
       var r26 = context.Ships.Where(p => shipIds.Contains(p.Id));