search

dotnet / efcore

EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
https://docs.microsoft.com/ef/
MIT License
13.79k stars 3.19k forks source link

Expose Added, Updated, Deleted, etc from ChangeTracker, Introduce ChangeSet concept #21518

Closed juliusfriedman closed 2 years ago

juliusfriedman commented 4 years ago

When I am inserting a large number of records (for instance synchronizing with an external database or provider), sometimes I receive an exception that the insert fails on a foreign key constraint (which is technically impossible because that would be invalid referential integrity...)

I would like the option to either not get this exception by having a IgnoreFailedInserts or perhaps even more fine grained control but without looping over the entire ChangeSet, e.g. the ability to get just the failed Inserts, Updates, Deletes etc.

For example when implementing soft delete...

// Loop each entry which is being tracked
            foreach (var entry in ChangeTracker.Entries())
            {
                //Jump to the case determined by State
                switch (entry.State)
                {
                    //If the entry was marked for deletion
                    case EntityState.Deleted:
                        {
                            //The entry.State is now modified
                            entry.State = EntityState.Modified;

                            //Set IsDeleted to true.
                            entry.CurrentValues["IsDeleted"] = true;

                            //https://github.com/dotnet/efcore/issues/21343
                            //Check for ModifiedDate
                            var property = entry.Metadata.FindProperty("ModifiedDate");

                            //Try to Set ModifiedDate to UtcNow.
                            //Only not present on LocationEvent
                            if (property != null)
                            {
                                entry.CurrentValues["ModifiedDate"] = DateTime.UtcNow;
                            }

                            //Goto the next entry
                            continue;
                        }
                }              
            }
        }

I think this would be much better if I could just take action on the FailedUpdates, FailedInserts and FailedDeletes while not having to act on the ones which would have otherwise been successful.

Since you already do the insert in a way which you can detail which one fails you should report that information back to the user so they can take the appropriate action.

e.g. having to loop all tracked entries is not that useful especially if the context is loaded with a lot of data unrelated to the insert.

I think also having the entity which failed for whatever reason gives you then the chance to make sure it hasn't already been acted upon and then if not take subsequent action or perhaps a merge based approach, whatever your application requires.

An example of the SQL which fails is:

Failing SQL Insert Example: Column names and some values have been changed to protect the identity of the application and it's data ```SQL Microsoft.EntityFrameworkCore.Database.Command: Error: Failed executing DbCommand (3,964ms) [Parameters=[@p0=NULL (DbType = Int32), @p1='103323', @p2='2020-06-30T17:59:18', @p3=NULL, @p4=NULL (DbType = Int32), @p5='False', @p6='0.000000000000', @p7='40003', @p8='0.000000000000', @p9='504768909', @p10='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p11=NULL (DbType = Int32), @p12='2020-06-30T18:09:20', @p13=NULL (DbType = Int32), @p14=NULL (DbType = Int32), @p15='103323', @p16='2020-06-30T17:59:21', @p17='1' (Nullable = true), @p18='0' (Nullable = true), @p19='False', @p20='43.477046500000', @p21='20035', @p22='4.924814900000', @p23='504768910', @p24='0xE6100000010CEC1516DC0FBD4540FF6959AD02B31340' (Nullable = false) (Size = 22) (DbType = Object), @p25='4' (Nullable = true), @p26='2020-06-30T18:09:20', @p27='0' (Nullable = true), @p28=NULL (DbType = Int32), @p29='103323', @p30='2020-06-30T18:08:56', @p31='2' (Nullable = true), @p32='0' (Nullable = true), @p33='False', @p34='43.476960700000', @p35='20035', @p36='4.924728400000', @p37='504768911', @p38='0xE6100000010C17FD570C0DBD4540C9BA6E00ECB21340' (Nullable = false) (Size = 22) (DbType = Object), @p39='4' (Nullable = true), @p40='2020-06-30T18:09:20', @p41='0' (Nullable = true), @p42=NULL (DbType = Int32), @p43='108200', @p44='2020-06-30T18:09:08', @p45='1' (Nullable = true), @p46='0' (Nullable = true), @p47='False', @p48='50.121728300000', @p49='20035', @p50='2.784125000000', @p51='504768915', @p52='0xE6100000010CB4BFFDCA940F4940D9CEF753E3450640' (Nullable = false) (Size = 22) (DbType = Object), @p53='6' (Nullable = true), @p54='2020-06-30T18:09:23', @p55='0' (Nullable = true), @p56=NULL (DbType = Int32), @p57='98892', @p58='2020-06-30T18:09:21', @p59=NULL, @p60=NULL (DbType = Int32), @p61='False', @p62='30.057341500000', @p63='20034', @p64='-90.522673600000', @p65='504768940', @p66='0xE6100000010C1E34BBEEAD0E3E40E39EF87B73A156C0' (Nullable = false) (Size = 22) (DbType = Object), @p67=NULL (DbType = Int32), @p68='2020-06-30T18:09:42', @p69=NULL (DbType = Int32), @p70=NULL (DbType = Int32), @p71='116125', @p72='2020-06-30T10:27:38', @p73=NULL, @p74=NULL (DbType = Int32), @p75='False', @p76='0.000000000000', @p77='40001', @p78='0.000000000000', @p79='504768946', @p80='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p81=NULL (DbType = Int32), @p82='2020-06-30T18:09:46', @p83=NULL (DbType = Int32), @p84=NULL (DbType = Int32), @p85='118564', @p86='2020-06-29T22:01:02', @p87='6' (Nullable = true), @p88='60' (Nullable = true), @p89='False', @p90='52.402945200000', @p91='20035', @p92='4.842632100000', @p93='504769035', @p94='0xE6100000010C430A54B593334A403D3D00F3DA5E1340' (Nullable = false) (Size = 22) (DbType = Object), @p95='5' (Nullable = true), @p96='2020-06-30T18:10:45', @p97='2' (Nullable = true), @p98=NULL (DbType = Int32), @p99='116125', @p100='2020-06-30T10:28:57', @p101='3' (Nullable = true), @p102='137' (Nullable = true), @p103='False', @p104='51.061599800000', @p105='20035', @p106='12.182151900000', @p107='504768947', @p108='0xE6100000010C57389380E2874940FBCE8A03435D2840' (Nullable = false) (Size = 22) (DbType = Object), @p109='5' (Nullable = true), @p110='2020-06-30T18:09:46', @p111='2' (Nullable = true), @p112=NULL (DbType = Int32), @p113='116125', @p114='2020-06-30T10:47:47', @p115='3' (Nullable = true), @p116='0' (Nullable = true), @p117='False', @p118='51.065048300000', @p119='20035', @p120='12.193938800000', @p121='504768949', @p122='0xE6100000010C8894B08053884940D9D946F24B632840' (Nullable = false) (Size = 22) (DbType = Object), @p123='4' (Nullable = true), @p124='2020-06-30T18:09:46', @p125='0' (Nullable = true), @p126=NULL (DbType = Int32), @p127='116125', @p128='2020-06-30T18:09:32', @p129='2' (Nullable = true), @p130='0' (Nullable = true), @p131='False', @p132='51.065420300000', @p133='20035', @p134='12.194113400000', @p135='504768951', @p136='0xE6100000010C4C7F40B15F884940456EE1D462632840' (Nullable = false) (Size = 22) (DbType = Object), @p137='5' (Nullable = true), @p138='2020-06-30T18:09:46', @p139='0' (Nullable = true), @p140=NULL (DbType = Int32), @p141='118564', @p142='2020-06-29T18:58:15', @p143=NULL, @p144=NULL (DbType = Int32), @p145='False', @p146='0.000000000000', @p147='40001', @p148='0.000000000000', @p149='504769013', @p150='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p151=NULL (DbType = Int32), @p152='2020-06-30T18:10:44', @p153=NULL (DbType = Int32), @p154=NULL (DbType = Int32), @p155='118564', @p156='2020-06-29T18:58:21', @p157='1' (Nullable = true), @p158='152' (Nullable = true), @p159='False', @p160='51.828902600000', @p161='20035', @p162='4.600966500000', @p163='504769017', @p164='0xE6100000010CE148FB7A19EA494062F71DC363671240' (Nullable = false) (Size = 22) (DbType = Object), @p165='7' (Nullable = true), @p166='2020-06-30T18:10:44', @p167='7' (Nullable = true), @p168=NULL (DbType = Int32), @p169='118564', @p170='2020-06-29T19:58:38', @p171='4' (Nullable = true), @p172='165' (Nullable = true), @p173='False', @p174='52.262456400000', @p175='20035', @p176='4.991399300000', @p177='504769022', @p178='0xE6100000010C1D50DB2B98214A40F31BCB6031F71340' (Nullable = false) (Size = 22) (DbType = Object), @p179='4' (Nullable = true), @p180='2020-06-30T18:10:44', @p181='26' (Nullable = true), @p182=NULL (DbType = Int32), @p183='118564', @p184='2020-06-29T20:40:44', @p185=NULL, @p186=NULL (DbType = Int32), @p187='False', @p188='0.000000000000', @p189='40003', @p190='0.000000000000', @p191='504769026', @p192='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p193=NULL (DbType = Int32), @p194='2020-06-30T18:10:45', @p195=NULL (DbType = Int32), @p196=NULL (DbType = Int32), @p197='118564', @p198='2020-06-29T20:40:50', @p199='3' (Nullable = true), @p200='0' (Nullable = true), @p201='False', @p202='52.403591000000', @p203='20035', @p204='4.841379300000', @p205='504769029', @p206='0xE6100000010CDFFAB0DEA8334A4020200489925D1340' (Nullable = false) (Size = 22) (DbType = Object), @p207='4' (Nullable = true), @p208='2020-06-30T18:10:45', @p209='0' (Nullable = true), @p210=NULL (DbType = Int32), @p211='116125', @p212='2020-06-30T10:47:43', @p213=NULL, @p214=NULL (DbType = Int32), @p215='False', @p216='0.000000000000', @p217='40003', @p218='0.000000000000', @p219='504768948', @p220='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p221=NULL (DbType = Int32), @p222='2020-06-30T18:09:46', @p223=NULL (DbType = Int32), @p224=NULL (DbType = Int32), @p225='104858', @p226='2020-06-30T18:08:23', @p227=NULL, @p228=NULL (DbType = Int32), @p229='False', @p230='0.000000000000', @p231='40001', @p232='0.000000000000', @p233='504769107', @p234='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p235=NULL (DbType = Int32), @p236='2020-06-30T18:10:49', @p237=NULL (DbType = Int32), @p238=NULL (DbType = Int32), @p239='104641', @p240='2020-06-30T18:08:25', @p241=NULL, @p242=NULL (DbType = Int32), @p243='False', @p244='0.000000000000', @p245='40001', @p246='0.000000000000', @p247='504769115', @p248='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p249=NULL (DbType = Int32), @p250='2020-06-30T18:10:49', @p251=NULL (DbType = Int32), @p252=NULL (DbType = Int32), @p253='94837', @p254='2020-06-30T18:10:02', @p255=NULL, @p256=NULL (DbType = Int32), @p257='False', @p258='29.980548400000', @p259='20034', @p260='-90.442408100000', @p261='504769132', @p262='0xE6100000010C27254E3805FB3D40123F106A509C56C0' (Nullable = false) (Size = 22) (DbType = Object), @p263=NULL (DbType = Int32), @p264='2020-06-30T18:10:50', @p265=NULL (DbType = Int32), @p266=NULL (DbType = Int32), @p267='112439', @p268='2020-06-30T18:10:04', @p269='1' (Nullable = true), @p270='0' (Nullable = true), @p271='False', @p272='45.085803500000', @p273='20035', @p274='5.740986900000', @p275='504769202', @p276='0xE6100000010CF030ED9BFB8A4640C50E1945C5F61640' (Nullable = false) (Size = 22) (DbType = Object), @p277='7' (Nullable = true), @p278='2020-06-30T18:10:53', @p279='0' (Nullable = true), @p280=NULL (DbType = Int32), @p281='103182', @p282='2020-06-30T18:09:58', @p283=NULL, @p284=NULL (DbType = Int32), @p285='False', @p286='0.000000000000', @p287='40001', @p288='0.000000000000', @p289='504769205', @p290='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p291=NULL (DbType = Int32), @p292='2020-06-30T18:10:54', @p293=NULL (DbType = Int32), @p294=NULL (DbType = Int32), @p295='103182', @p296='2020-06-30T18:10:08', @p297='4' (Nullable = true), @p298='140' (Nullable = true), @p299='False', @p300='47.212949700000', @p301='20035', @p302='19.667062400000', @p303='504769207', @p304='0xE6100000010CB5988EEF419B47402A64F899C4AA3340' (Nullable = false) (Size = 22) (DbType = Object), @p305='4' (Nullable = true), @p306='2020-06-30T18:10:54', @p307='11' (Nullable = true), @p308=NULL (DbType = Int32), @p309='103918', @p310='2020-06-30T18:08:54', @p311=NULL, @p312=NULL (DbType = Int32), @p313='False', @p314='0.000000000000', @p315='40001', @p316='0.000000000000', @p317='504769227', @p318='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p319=NULL (DbType = Int32), @p320='2020-06-30T18:10:55', @p321=NULL (DbType = Int32), @p322=NULL (DbType = Int32), @p323='107951', @p324='2020-06-30T18:09:48', @p325=NULL, @p326=NULL (DbType = Int32), @p327='False', @p328='0.000000000000', @p329='40001', @p330='0.000000000000', @p331='504769231', @p332='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p333=NULL (DbType = Int32), @p334='2020-06-30T18:10:55', @p335=NULL (DbType = Int32), @p336=NULL (DbType = Int32), @p337='107951', @p338='2020-06-30T18:10:25', @p339='1' (Nullable = true), @p340='5' (Nullable = true), @p341='False', @p342='47.854666400000', @p343='20035', @p344='2.737866900000', @p345='504769234', @p346='0xE6100000010CBA7E66B565ED47404068E2C226E70540' (Nullable = false) (Size = 22) (DbType = Object), @p347='4' (Nullable = true), @p348='2020-06-30T18:10:55', @p349='0' (Nullable = true), @p350=NULL (DbType = Int32), @p351='104984', @p352='2020-06-30T17:20:23', @p353=NULL, @p354=NULL (DbType = Int32), @p355='False', @p356='0.000000000000', @p357='40003', @p358='0.000000000000', @p359='504769239', @p360='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p361=NULL (DbType = Int32), @p362='2020-06-30T18:10:55', @p363=NULL (DbType = Int32), @p364=NULL (DbType = Int32), @p365='114254', @p366='2020-06-30T18:10:01', @p367='2' (Nullable = true), @p368='0' (Nullable = true), @p369='False', @p370='49.325634100000', @p371='20035', @p372='12.104219300000', @p373='504769196', @p374='0xE6100000010C30FBD060AEA948405A396A3B5C352840' (Nullable = false) (Size = 22) (DbType = Object), @p375='5' (Nullable = true), @p376='2020-06-30T18:10:53', @p377='0' (Nullable = true), @p378=NULL (DbType = Int32), @p379='104984', @p380='2020-06-30T17:27:30', @p381=NULL, @p382=NULL (DbType = Int32), @p383='False', @p384='0.000000000000', @p385='40001', @p386='0.000000000000', @p387='504769241', @p388='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p389=NULL (DbType = Int32), @p390='2020-06-30T18:10:55', @p391=NULL (DbType = Int32), @p392=NULL (DbType = Int32), @p393='104984', @p394='2020-06-30T17:32:48', @p395=NULL, @p396=NULL (DbType = Int32), @p397='False', @p398='0.000000000000', @p399='40003', @p400='0.000000000000', @p401='504769246', @p402='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p403=NULL (DbType = Int32), @p404='2020-06-30T18:10:55', @p405=NULL (DbType = Int32), @p406=NULL (DbType = Int32), @p407='104984', @p408='2020-06-30T18:10:32', @p409='2' (Nullable = true), @p410='0' (Nullable = true), @p411='False', @p412='47.459372600000', @p413='20035', @p414='19.095558700000', @p415='504769248', @p416='0xE6100000010CD9D6AAB8CCBA47402959F38876183340' (Nullable = false) (Size = 22) (DbType = Object), @p417='5' (Nullable = true), @p418='2020-06-30T18:10:56', @p419='0' (Nullable = true), @p420=NULL (DbType = Int32), @p421='94868', @p422='2020-06-30T18:10:29', @p423=NULL, @p424=NULL (DbType = Int32), @p425='False', @p426='30.373825200000', @p427='20034', @p428='-95.014563400000', @p429='504769252', @p430='0xE6100000010CB06B2002B35F3E40FDAD539BEEC057C0' (Nullable = false) (Size = 22) (DbType = Object), @p431=NULL (DbType = Int32), @p432='2020-06-30T18:10:56', @p433=NULL (DbType = Int32), @p434='68' (Nullable = true), @p435='821', @p436='2020-06-30T18:09:04', @p437=NULL, @p438='0' (Nullable = true), @p439='False', @p440='30.027627944946', @p441='20034', @p442='-95.864334106445', @p443='504769301', @p444='0xE6100000010CAFFFFF9F12073E40EAFFFF3F51F757C0' (Nullable = false) (Size = 22) (DbType = Object), @p445=NULL (DbType = Int32), @p446='2020-06-30T18:10:59', @p447='0' (Nullable = true), @p448=NULL (DbType = Int32), @p449='107980', @p450='2020-06-30T18:10:15', @p451=NULL, @p452=NULL (DbType = Int32), @p453='False', @p454='0.000000000000', @p455='40001', @p456='0.000000000000', @p457='504769344', @p458='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p459=NULL (DbType = Int32), @p460='2020-06-30T18:11:11', @p461=NULL (DbType = Int32), @p462=NULL (DbType = Int32), @p463='107980', @p464='2020-06-30T18:10:51', @p465='4' (Nullable = true), @p466='0' (Nullable = true), @p467='False', @p468='47.853852600000', @p469='20035', @p470='2.737709200000', @p471='504769347', @p472='0xE6100000010C634DC00A4BED4740A5AABF14D4E60540' (Nullable = false) (Size = 22) (DbType = Object), @p473='4' (Nullable = true), @p474='2020-06-30T18:11:11', @p475='0' (Nullable = true), @p476=NULL (DbType = Int32), @p477='107075', @p478='2020-06-30T18:10:11', @p479=NULL, @p480=NULL (DbType = Int32), @p481='False', @p482='0.000000000000', @p483='40001', @p484='0.000000000000', @p485='504769376', @p486='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p487=NULL (DbType = Int32), @p488='2020-06-30T18:11:13', @p489=NULL (DbType = Int32), @p490=NULL (DbType = Int32), @p491='104984', @p492='2020-06-30T17:27:41', @p493='4' (Nullable = true), @p494='93' (Nullable = true), @p495='False', @p496='47.461823400000', @p497='20035', @p498='19.093614300000', @p499='504769243', @p500='0xE6100000010C86C377071DBB47401CF0541BF7173340' (Nullable = false) (Size = 22) (DbType = Object), @p501='4' (Nullable = true), @p502='2020-06-30T18:10:55', @p503='2' (Nullable = true), @p504=NULL (DbType = Int32), @p505='114254', @p506='2020-06-30T14:31:29', @p507='1' (Nullable = true), @p508='0' (Nullable = true), @p509='False', @p510='49.325600500000', @p511='20035', @p512='12.104131000000', @p513='504769192', @p514='0xE6100000010CD787F546ADA94840E3FF8EA850352840' (Nullable = false) (Size = 22) (DbType = Object), @p515='4' (Nullable = true), @p516='2020-06-30T18:10:53', @p517='0' (Nullable = true), @p518=NULL (DbType = Int32), @p519='114254', @p520='2020-06-30T14:31:26', @p521=NULL, @p522=NULL (DbType = Int32), @p523='False', @p524='0.000000000000', @p525='40003', @p526='0.000000000000', @p527='504769189', @p528='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p529=NULL (DbType = Int32), @p530='2020-06-30T18:10:53', @p531=NULL (DbType = Int32), @p532=NULL (DbType = Int32), @p533='114254', @p534='2020-06-30T14:18:19', @p535='2' (Nullable = true), @p536='177' (Nullable = true), @p537='False', @p538='49.313012800000', @p539='20035', @p540='12.109989900000', @p541='504769185', @p542='0xE6100000010C5D9DADCD10A84840D7C79E9850382840' (Nullable = false) (Size = 22) (DbType = Object), @p543='4' (Nullable = true), @p544='2020-06-30T18:10:53', @p545='2' (Nullable = true), @p546=NULL (DbType = Int32), @p547='114254', @p548='2020-06-30T04:42:52', @p549=NULL, @p550=NULL (DbType = Int32), @p551='False', @p552='0.000000000000', @p553='40001', @p554='0.000000000000', @p555='504769137', @p556='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p557=NULL (DbType = Int32), @p558='2020-06-30T18:10:50', @p559=NULL (DbType = Int32), @p560=NULL (DbType = Int32), @p561='114254', @p562='2020-06-30T04:43:32', @p563='1' (Nullable = true), @p564='0' (Nullable = true), @p565='False', @p566='49.310093500000', @p567='20035', @p568='12.108764100000', @p569='504769139', @p570='0xE6100000010CE199D024B1A748402FF598EDAF372840' (Nullable = false) (Size = 22) (DbType = Object), @p571='6' (Nullable = true), @p572='2020-06-30T18:10:51', @p573='0' (Nullable = true), @p574=NULL (DbType = Int32), @p575='114254', @p576='2020-06-30T04:48:00', @p577=NULL, @p578=NULL (DbType = Int32), @p579='False', @p580='0.000000000000', @p581='40003', @p582='0.000000000000', @p583='504769142', @p584='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p585=NULL (DbType = Int32), @p586='2020-06-30T18:10:51', @p587=NULL (DbType = Int32), @p588=NULL (DbType = Int32), @p589='114254', @p590='2020-06-30T04:48:02', @p591='2' (Nullable = true), @p592='0' (Nullable = true), @p593='False', @p594='49.310019000000', @p595='20035', @p596='12.108840100000', @p597='504769144', @p598='0xE6100000010CBE11DDB3AEA748409BFCBBE3B9372840' (Nullable = false) (Size = 22) (DbType = Object), @p599='5' (Nullable = true), @p600='2020-06-30T18:10:51', @p601='0' (Nullable = true), @p602=NULL (DbType = Int32), @p603='114254', @p604='2020-06-30T07:52:12', @p605=NULL, @p606=NULL (DbType = Int32), @p607='False', @p608='0.000000000000', @p609='40001', @p610='0.000000000000', @p611='504769147', @p612='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p613=NULL (DbType = Int32), @p614='2020-06-30T18:10:51', @p615=NULL (DbType = Int32), @p616=NULL (DbType = Int32), @p617='114254', @p618='2020-06-30T07:52:54', @p619='2' (Nullable = true), @p620='177' (Nullable = true), @p621='False', @p622='49.310484100000', @p623='20035', @p624='12.108756700000', @p625='504769149', @p626='0xE6100000010CC8B667F1BDA7484018714BF5AE372840' (Nullable = false) (Size = 22) (DbType = Object), @p627='5' (Nullable = true), @p628='2020-06-30T18:10:51', @p629='3' (Nullable = true), @p630=NULL (DbType = Int32), @p631='114254', @p632='2020-06-30T08:02:40', @p633=NULL, @p634=NULL (DbType = Int32), @p635='False', @p636='0.000000000000', @p637='40003', @p638='0.000000000000', @p639='504769152', @p640='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p641=NULL (DbType = Int32), @p642='2020-06-30T18:10:51', @p643=NULL (DbType = Int32), @p644=NULL (DbType = Int32), @p645='114254', @p646='2020-06-30T08:03:01', @p647='2' (Nullable = true), @p648='0' (Nullable = true), @p649='False', @p650='49.312919500000', @p651='20035', @p652='12.110208900000', @p653='504769155', @p654='0xE6100000010CED6305BF0DA84840CE740A4D6D382840' (Nullable = false) (Size = 22) (DbType = Object), @p655='4' (Nullable = true), @p656='2020-06-30T18:10:51', @p657='0' (Nullable = true), @p658=NULL (DbType = Int32), @p659='114254', @p660='2020-06-30T10:42:44', @p661=NULL, @p662=NULL (DbType = Int32), @p663='False', @p664='0.000000000000', @p665='40001', @p666='0.000000000000', @p667='504769161', @p668='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p669=NULL (DbType = Int32), @p670='2020-06-30T18:10:52', @p671=NULL (DbType = Int32), @p672=NULL (DbType = Int32), @p673='114254', @p674='2020-06-30T10:43:25', @p675='1' (Nullable = true), @p676='0' (Nullable = true), @p677='False', @p678='49.312714600000', @p679='20035', @p680='12.110053300000', @p681='504769164', @p682='0xE6100000010CA9FD310807A848403EA2F8E758382840' (Nullable = false) (Size = 22) (DbType = Object), @p683='5' (Nullable = true), @p684='2020-06-30T18:10:52', @p685='0' (Nullable = true), @p686=NULL (DbType = Int32), @p687='114254', @p688='2020-06-30T10:50:24', @p689=NULL, @p690=NULL (DbType = Int32), @p691='False', @p692='0.000000000000', @p693='40003', @p694='0.000000000000', @p695='504769167', @p696='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p697=NULL (DbType = Int32), @p698='2020-06-30T18:10:52', @p699=NULL (DbType = Int32), @p700=NULL (DbType = Int32), @p701='114254', @p702='2020-06-30T10:50:26', @p703='1' (Nullable = true), @p704='0' (Nullable = true), @p705='False', @p706='49.312260100000', @p707='20035', @p708='12.110074700000', @p709='504769169', @p710='0xE6100000010C40AC9223F8A74840E93B09B65B382840' (Nullable = false) (Size = 22) (DbType = Object), @p711='5' (Nullable = true), @p712='2020-06-30T18:10:52', @p713='0' (Nullable = true), @p714=NULL (DbType = Int32), @p715='114254', @p716='2020-06-30T11:22:14', @p717=NULL, @p718=NULL (DbType = Int32), @p719='False', @p720='0.000000000000', @p721='40001', @p722='0.000000000000', @p723='504769172', @p724='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p725=NULL (DbType = Int32), @p726='2020-06-30T18:10:52', @p727=NULL (DbType = Int32), @p728=NULL (DbType = Int32), @p729='114254', @p730='2020-06-30T11:22:20', @p731='2' (Nullable = true), @p732='46' (Nullable = true), @p733='False', @p734='49.312427600000', @p735='20035', @p736='12.110026500000', @p737='504769175', @p738='0xE6100000010C132FAAA0FDA74840FE62B66455382840' (Nullable = false) (Size = 22) (DbType = Object), @p739='5' (Nullable = true), @p740='2020-06-30T18:10:52', @p741='0' (Nullable = true), @p742=NULL (DbType = Int32), @p743='114254', @p744='2020-06-30T11:30:08', @p745=NULL, @p746=NULL (DbType = Int32), @p747='False', @p748='0.000000000000', @p749='40003', @p750='0.000000000000', @p751='504769177', @p752='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p753=NULL (DbType = Int32), @p754='2020-06-30T18:10:52', @p755=NULL (DbType = Int32), @p756=NULL (DbType = Int32), @p757='114254', @p758='2020-06-30T11:30:10', @p759='2' (Nullable = true), @p760='49' (Nullable = true), @p761='False', @p762='49.311919200000', @p763='20035', @p764='12.110344800000', @p765='504769180', @p766='0xE6100000010C4B7FE5F7ECA748403C91161D7F382840' (Nullable = false) (Size = 22) (DbType = Object), @p767='5' (Nullable = true), @p768='2020-06-30T18:10:52', @p769='0' (Nullable = true), @p770=NULL (DbType = Int32), @p771='114254', @p772='2020-06-30T14:17:27', @p773=NULL, @p774=NULL (DbType = Int32), @p775='False', @p776='0.000000000000', @p777='40001', @p778='0.000000000000', @p779='504769183', @p780='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p781=NULL (DbType = Int32), @p782='2020-06-30T18:10:53', @p783=NULL (DbType = Int32), @p784=NULL (DbType = Int32), @p785='103323', @p786='2020-06-30T17:40:21', @p787='1' (Nullable = true), @p788='72' (Nullable = true), @p789='False', @p790='43.525830300000', @p791='20035', @p792='4.973626200000', @p793='504768906', @p794='0xE6100000010C79DF42684EC34540721D3E44FEE41340' (Nullable = false) (Size = 22) (DbType = Object), @p795='4' (Nullable = true), @p796='2020-06-30T18:09:19', @p797='20' (Nullable = true), @p798=NULL (DbType = Int32), @p799='107075', @p800='2020-06-30T18:10:53', @p801='1' (Nullable = true), @p802='0' (Nullable = true), @p803='False', @p804='47.854541300000', @p805='20035', @p806='2.737826300000', @p807='504769380', @p808='0xE6100000010C694AFC9B61ED47408C07A57911E70540' (Nullable = false) (Size = 22) (DbType = Object), @p809='4' (Nullable = true), @p810='2020-06-30T18:11:13', @p811='0' (Nullable = true), @p812=NULL (DbType = Int32), @p813='103323', @p814='2020-06-30T17:30:55', @p815='1' (Nullable = true), @p816='49' (Nullable = true), @p817='False', @p818='43.581401400000', @p819='20035', @p820='4.993160500000', @p821='504768904', @p822='0xE6100000010C9F6C6F5C6BCA45404EB7EC10FFF81340' (Nullable = false) (Size = 22) (DbType = Object), @p823='4' (Nullable = true), @p824='2020-06-30T18:09:19', @p825='15' (Nullable = true), @p826=NULL (DbType = Int32), @p827='103323', @p828='2020-06-30T17:00:18', @p829='1' (Nullable = true), @p830='105' (Nullable = true), @p831='False', @p832='43.793822700000', @p833='20035', @p834='4.661548200000', @p835='504768900', @p836='0xE6100000010C45A973FB9BE5454022E92EE46CA51240' (Nullable = false) (Size = 22) (DbType = Object), @p837='5' (Nullable = true), @p838='2020-06-30T18:09:18', @p839='8' (Nullable = true), @p840='593' (Nullable = true), @p841='94691', @p842='2020-06-30T18:07:04', @p843=NULL, @p844='0' (Nullable = true), @p845='False', @p846='32.468811035156', @p847='20034', @p848='-111.225715637207', @p849='504768634', @p850='0xE6100000010CDDFFFFFF013C4040FEFFFF1F72CE5BC0' (Nullable = false) (Size = 22) (DbType = Object), @p851=NULL (DbType = Int32), @p852='2020-06-30T18:07:59', @p853='29' (Nullable = true), @p854='10' (Nullable = true), @p855='120182', @p856='2020-06-30T18:07:05', @p857=NULL, @p858='0' (Nullable = true), @p859='False', @p860='30.184490203857', @p861='20034', @p862='-90.989151000977', @p863='504768636', @p864='0xE6100000010C89FFFFBF3A2F3E401F0000404EBF56C0' (Nullable = false) (Size = 22) (DbType = Object), @p865=NULL (DbType = Int32), @p866='2020-06-30T18:07:59', @p867='0' (Nullable = true), @p868=NULL (DbType = Int32), @p869='107815', @p870='2020-06-30T18:07:34', @p871=NULL, @p872=NULL (DbType = Int32), @p873='False', @p874='0.000000000000', @p875='40001', @p876='0.000000000000', @p877='504768671', @p878='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p879=NULL (DbType = Int32), @p880='2020-06-30T18:08:20', @p881=NULL (DbType = Int32), @p882=NULL (DbType = Int32), @p883='107815', @p884='2020-06-30T18:08:03', @p885='1' (Nullable = true), @p886='171' (Nullable = true), @p887='False', @p888='40.780998600000', @p889='20035', @p890='-8.578005300000', @p891='504768672', @p892='0xE6100000010C639C1AC3F76344404FD4884FF02721C0' (Nullable = false) (Size = 22) (DbType = Object), @p893='6' (Nullable = true), @p894='2020-06-30T18:08:20', @p895='0' (Nullable = true), @p896=NULL (DbType = Int32), @p897='105504', @p898='2020-06-29T18:25:42', @p899=NULL, @p900=NULL (DbType = Int32), @p901='False', @p902='0.000000000000', @p903='40003', @p904='0.000000000000', @p905='504768765', @p906='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p907=NULL (DbType = Int32), @p908='2020-06-30T18:08:41', @p909=NULL (DbType = Int32), @p910=NULL (DbType = Int32), @p911='105504', @p912='2020-06-29T18:25:47', @p913='2' (Nullable = true), @p914='93' (Nullable = true), @p915='False', @p916='35.391146300000', @p917='20035', @p918='-101.455909400000', @p919='504768768', @p920='0xE6100000010CC839FB1411B2414018BC9E9E2D5D59C0' (Nullable = false) (Size = 22) (DbType = Object), @p921='6' (Nullable = true), @p922='2020-06-30T18:08:41', @p923='1' (Nullable = true), @p924=NULL (DbType = Int32), @p925='105504', @p926='2020-06-29T19:01:18', @p927=NULL, @p928=NULL (DbType = Int32), @p929='False', @p930='0.000000000000', @p931='40001', @p932='0.000000000000', @p933='504768770', @p934='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p935=NULL (DbType = Int32), @p936='2020-06-30T18:08:41', @p937=NULL (DbType = Int32), @p938='6' (Nullable = true), @p939='119655', @p940='2020-06-30T18:05:40', @p941=NULL, @p942='0' (Nullable = true), @p943='False', @p944='30.176160812378', @p945='20034', @p946='-90.974113464355', @p947='504768622', @p948='0xE6100000010C140000E0182D3E40DFFFFFDF57BE56C0' (Nullable = false) (Size = 22) (DbType = Object), @p949=NULL (DbType = Int32), @p950='2020-06-30T18:07:58', @p951='0' (Nullable = true), @p952=NULL (DbType = Int32), @p953='105504', @p954='2020-06-29T19:01:24', @p955='2' (Nullable = true), @p956='0' (Nullable = true), @p957='False', @p958='35.391305800000', @p959='20035', @p960='-101.455948900000', @p961='504768771', @p962='0xE6100000010C18DEF64E16B241406B894B442E5D59C0' (Nullable = false) (Size = 22) (DbType = Object), @p963='5' (Nullable = true), @p964='2020-06-30T18:08:41', @p965='0' (Nullable = true), @p966=NULL (DbType = Int32), @p967='105504', @p968='2020-06-29T19:33:55', @p969='1' (Nullable = true), @p970='0' (Nullable = true), @p971='False', @p972='35.342585200000', @p973='20035', @p974='-101.410142400000', @p975='504768773', @p976='0xE6100000010CFC0BF3D4D9AB4140FDACE8C53F5A59C0' (Nullable = false) (Size = 22) (DbType = Object), @p977='6' (Nullable = true), @p978='2020-06-30T18:08:42', @p979='0' (Nullable = true), @p980=NULL (DbType = Int32), @p981='105504', @p982='2020-06-29T20:46:43', @p983=NULL, @p984=NULL (DbType = Int32), @p985='False', @p986='0.000000000000', @p987='40001', @p988='0.000000000000', @p989='504768774', @p990='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p991=NULL (DbType = Int32), @p992='2020-06-30T18:08:42', @p993=NULL (DbType = Int32), @p994=NULL (DbType = Int32), @p995='105504', @p996='2020-06-29T20:46:50', @p997='2' (Nullable = true), @p998='169' (Nullable = true), @p999='False', @p1000='35.342534300000', @p1001='20035', @p1002='-101.410235300000', @p1003='504768775', @p1004='0xE6100000010C0E21F829D8AB41408B4A8F4B415A59C0' (Nullable = false) (Size = 22) (DbType = Object), @p1005='4' (Nullable = true), @p1006='2020-06-30T18:08:42', @p1007='0' (Nullable = true), @p1008=NULL (DbType = Int32), @p1009='105504', @p1010='2020-06-29T21:09:35', @p1011=NULL, @p1012=NULL (DbType = Int32), @p1013='False', @p1014='0.000000000000', @p1015='40003', @p1016='0.000000000000', @p1017='504768776', @p1018='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1019=NULL (DbType = Int32), @p1020='2020-06-30T18:08:42', @p1021=NULL (DbType = Int32), @p1022=NULL (DbType = Int32), @p1023='105504', @p1024='2020-06-29T21:09:38', @p1025='3' (Nullable = true), @p1026='126' (Nullable = true), @p1027='False', @p1028='35.339863600000', @p1029='20035', @p1030='-101.408137300000', @p1031='504768777', @p1032='0xE6100000010CE88C83A680AB4140C7F1E8EB1E5A59C0' (Nullable = false) (Size = 22) (DbType = Object), @p1033='4' (Nullable = true), @p1034='2020-06-30T18:08:42', @p1035='1' (Nullable = true), @p1036=NULL (DbType = Int32), @p1037='105504', @p1038='2020-06-29T21:33:28', @p1039=NULL, @p1040=NULL (DbType = Int32), @p1041='False', @p1042='0.000000000000', @p1043='40001', @p1044='0.000000000000', @p1045='504768778', @p1046='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1047=NULL (DbType = Int32), @p1048='2020-06-30T18:08:42', @p1049=NULL (DbType = Int32), @p1050=NULL (DbType = Int32), @p1051='105504', @p1052='2020-06-29T21:33:39', @p1053='4' (Nullable = true), @p1054='76' (Nullable = true), @p1055='False', @p1056='35.339874900000', @p1057='20035', @p1058='-101.408125000000', @p1059='504768780', @p1060='0xE6100000010C9A1D4E0581AB414085EB51B81E5A59C0' (Nullable = false) (Size = 22) (DbType = Object), @p1061='4' (Nullable = true), @p1062='2020-06-30T18:08:43', @p1063='0' (Nullable = true), @p1064=NULL (DbType = Int32), @p1065='105504', @p1066='2020-06-29T19:33:17', @p1067=NULL, @p1068=NULL (DbType = Int32), @p1069='False', @p1070='0.000000000000', @p1071='40003', @p1072='0.000000000000', @p1073='504768772', @p1074='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1075=NULL (DbType = Int32), @p1076='2020-06-30T18:08:42', @p1077=NULL (DbType = Int32), @p1078=NULL (DbType = Int32), @p1079='105504', @p1080='2020-06-29T21:43:13', @p1081=NULL, @p1082=NULL (DbType = Int32), @p1083='False', @p1084='0.000000000000', @p1085='40003', @p1086='0.000000000000', @p1087='504768781', @p1088='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1089=NULL (DbType = Int32), @p1090='2020-06-30T18:08:43', @p1091=NULL (DbType = Int32), @p1092=NULL (DbType = Int32), @p1093='115997', @p1094='2020-06-30T18:07:40', @p1095='3' (Nullable = true), @p1096='0' (Nullable = true), @p1097='False', @p1098='48.248763900000', @p1099='20035', @p1100='20.651168500000', @p1101='504768581', @p1102='0xE6100000010C7476D77ED71F484075AF93FAB2A63440' (Nullable = false) (Size = 22) (DbType = Object), @p1103='5' (Nullable = true), @p1104='2020-06-30T18:07:55', @p1105='0' (Nullable = true), @p1106=NULL (DbType = Int32), @p1107='115997', @p1108='2020-06-30T17:52:02', @p1109=NULL, @p1110=NULL (DbType = Int32), @p1111='False', @p1112='0.000000000000', @p1113='40003', @p1114='0.000000000000', @p1115='504768575', @p1116='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1117=NULL (DbType = Int32), @p1118='2020-06-30T18:07:55', @p1119=NULL (DbType = Int32), @p1120=NULL (DbType = Int32), @p1121='115906', @p1122='2020-06-30T18:03:34', @p1123=NULL, @p1124=NULL (DbType = Int32), @p1125='False', @p1126='0.000000000000', @p1127='40001', @p1128='0.000000000000', @p1129='504768486', @p1130='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1131=NULL (DbType = Int32), @p1132='2020-06-30T18:07:43', @p1133=NULL (DbType = Int32), @p1134=NULL (DbType = Int32), @p1135='115906', @p1136='2020-06-30T18:04:05', @p1137='3' (Nullable = true), @p1138='0' (Nullable = true), @p1139='False', @p1140='49.230331300000', @p1141='20035', @p1142='2.433949500000', @p1143='504768487', @p1144='0xE6100000010C625FFC7E7B9D4840A7ECF483BA780340' (Nullable = false) (Size = 22) (DbType = Object), @p1145='4' (Nullable = true), @p1146='2020-06-30T18:07:44', @p1147='0' (Nullable = true), @p1148=NULL (DbType = Int32), @p1149='115906', @p1150='2020-06-30T18:07:20', @p1151=NULL, @p1152=NULL (DbType = Int32), @p1153='False', @p1154='0.000000000000', @p1155='40003', @p1156='0.000000000000', @p1157='504768488', @p1158='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1159=NULL (DbType = Int32), @p1160='2020-06-30T18:07:44', @p1161=NULL (DbType = Int32), @p1162=NULL (DbType = Int32), @p1163='115906', @p1164='2020-06-30T18:07:25', @p1165='3' (Nullable = true), @p1166='41' (Nullable = true), @p1167='False', @p1168='49.230322100000', @p1169='20035', @p1170='2.434085700000', @p1171='504768489', @p1172='0xE6100000010CE585CF317B9D4840464A69EC01790340' (Nullable = false) (Size = 22) (DbType = Object), @p1173='4' (Nullable = true), @p1174='2020-06-30T18:07:44', @p1175='0' (Nullable = true), @p1176=NULL (DbType = Int32), @p1177='105510', @p1178='2020-06-30T01:54:05', @p1179=NULL, @p1180=NULL (DbType = Int32), @p1181='False', @p1182='0.000000000000', @p1183='40001', @p1184='0.000000000000', @p1185='504768490', @p1186='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1187=NULL (DbType = Int32), @p1188='2020-06-30T18:07:44', @p1189=NULL (DbType = Int32), @p1190=NULL (DbType = Int32), @p1191='105510', @p1192='2020-06-30T01:54:38', @p1193='0' (Nullable = true), @p1194='0' (Nullable = true), @p1195='False', @p1196='35.681994700000', @p1197='20035', @p1198='-101.375905700000', @p1199='504768491', @p1200='0xE6100000010CCD45329A4BD7414052F8C7D60E5859C0' (Nullable = false) (Size = 22) (DbType = Object), @p1201='10' (Nullable = true), @p1202='2020-06-30T18:07:44', @p1203='0' (Nullable = true), @p1204=NULL (DbType = Int32), @p1205='105510', @p1206='2020-06-30T02:02:14', @p1207=NULL, @p1208=NULL (DbType = Int32), @p1209='False', @p1210='0.000000000000', @p1211='40003', @p1212='0.000000000000', @p1213='504768493', @p1214='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1215=NULL (DbType = Int32), @p1216='2020-06-30T18:07:44', @p1217=NULL (DbType = Int32), @p1218=NULL (DbType = Int32), @p1219='115997', @p1220='2020-06-30T17:52:13', @p1221='4' (Nullable = true), @p1222='0' (Nullable = true), @p1223='False', @p1224='48.248275600000', @p1225='20035', @p1226='20.651617300000', @p1227='504768578', @p1228='0xE6100000010C8832AF7EC71F484001023164D0A63440' (Nullable = false) (Size = 22) (DbType = Object), @p1229='4' (Nullable = true), @p1230='2020-06-30T18:07:55', @p1231='0' (Nullable = true), @p1232=NULL (DbType = Int32), @p1233='105510', @p1234='2020-06-30T02:02:16', @p1235='0' (Nullable = true), @p1236='0' (Nullable = true), @p1237='False', @p1238='35.681990400000', @p1239='20035', @p1240='-101.375930900000', @p1241='504768494', @p1242='0xE6100000010CCD1720764BD7414093437A400F5859C0' (Nullable = false) (Size = 22) (DbType = Object), @p1243='10' (Nullable = true), @p1244='2020-06-30T18:07:44', @p1245='0' (Nullable = true), @p1246=NULL (DbType = Int32), @p1247='115997', @p1248='2020-06-30T09:47:22', @p1249=NULL, @p1250=NULL (DbType = Int32), @p1251='False', @p1252='0.000000000000', @p1253='40001', @p1254='0.000000000000', @p1255='504768558', @p1256='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1257=NULL (DbType = Int32), @p1258='2020-06-30T18:07:54', @p1259=NULL (DbType = Int32), @p1260=NULL (DbType = Int32), @p1261='115997', @p1262='2020-06-30T09:48:06', @p1263='1' (Nullable = true), @p1264='0' (Nullable = true), @p1265='False', @p1266='48.248586200000', @p1267='20035', @p1268='20.651431100000', @p1269='504768560', @p1270='0xE6100000010C539E2FACD11F4840E9184630C4A63440' (Nullable = false) (Size = 22) (DbType = Object), @p1271='7' (Nullable = true), @p1272='2020-06-30T18:07:54', @p1273='0' (Nullable = true), @p1274=NULL (DbType = Int32), @p1275='115997', @p1276='2020-06-30T09:53:20', @p1277=NULL, @p1278=NULL (DbType = Int32), @p1279='False', @p1280='0.000000000000', @p1281='40003', @p1282='0.000000000000', @p1283='504768562', @p1284='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1285=NULL (DbType = Int32), @p1286='2020-06-30T18:07:54', @p1287=NULL (DbType = Int32), @p1288=NULL (DbType = Int32), @p1289='115997', @p1290='2020-06-30T09:53:30', @p1291='2' (Nullable = true), @p1292='0' (Nullable = true), @p1293='False', @p1294='48.248660900000', @p1295='20035', @p1296='20.651359800000', @p1297='504768565', @p1298='0xE6100000010C9FA5D01ED41F4840DAED0E84BFA63440' (Nullable = false) (Size = 22) (DbType = Object), @p1299='6' (Nullable = true), @p1300='2020-06-30T18:07:54', @p1301='0' (Nullable = true), @p1302=NULL (DbType = Int32), @p1303='115997', @p1304='2020-06-30T17:43:39', @p1305=NULL, @p1306=NULL (DbType = Int32), @p1307='False', @p1308='0.000000000000', @p1309='40001', @p1310='0.000000000000', @p1311='504768569', @p1312='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1313=NULL (DbType = Int32), @p1314='2020-06-30T18:07:55', @p1315=NULL (DbType = Int32), @p1316=NULL (DbType = Int32), @p1317='115997', @p1318='2020-06-30T17:44:06', @p1319='3' (Nullable = true), @p1320='0' (Nullable = true), @p1321='False', @p1322='48.248479600000', @p1323='20035', @p1324='20.651503000000', @p1325='504768572', @p1326='0xE6100000010C91DCF52DCE1F4840F33E8EE6C8A63440' (Nullable = false) (Size = 22) (DbType = Object), @p1327='5' (Nullable = true), @p1328='2020-06-30T18:07:55', @p1329='0' (Nullable = true), @p1330='68' (Nullable = true), @p1331='821', @p1332='2020-06-29T22:52:40', @p1333=NULL, @p1334='0' (Nullable = true), @p1335='False', @p1336='30.027673721313', @p1337='20034', @p1338='-95.864387512207', @p1339='504768574', @p1340='0xE6100000010C7AFFFF9F15073E40FEFFFF1F52F757C0' (Nullable = false) (Size = 22) (DbType = Object), @p1341=NULL (DbType = Int32), @p1342='2020-06-30T18:07:55', @p1343='0' (Nullable = true), @p1344=NULL (DbType = Int32), @p1345='105510', @p1346='2020-06-30T18:07:32', @p1347='1' (Nullable = true), @p1348='0' (Nullable = true), @p1349='False', @p1350='35.682004100000', @p1351='20035', @p1352='-101.375936500000', @p1353='504768495', @p1354='0xE6100000010C749E0CE94BD74140DA37F7570F5859C0' (Nullable = false) (Size = 22) (DbType = Object), @p1355='7' (Nullable = true), @p1356='2020-06-30T18:07:45', @p1357='0' (Nullable = true), @p1358=NULL (DbType = Int32), @p1359='105504', @p1360='2020-06-29T21:43:29', @p1361='2' (Nullable = true), @p1362='161' (Nullable = true), @p1363='False', @p1364='35.334835300000', @p1365='20035', @p1366='-101.404150300000', @p1367='504768782', @p1368='0xE6100000010CEF8513E2DBAA4140CA4A3899DD5959C0' (Nullable = false) (Size = 22) (DbType = Object), @p1369='4' (Nullable = true), @p1370='2020-06-30T18:08:43', @p1371='0' (Nullable = true), @p1372=NULL (DbType = Int32), @p1373='105504', @p1374='2020-06-29T21:53:07', @p1375=NULL, @p1376=NULL (DbType = Int32), @p1377='False', @p1378='0.000000000000', @p1379='40001', @p1380='0.000000000000', @p1381='504768783', @p1382='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1383=NULL (DbType = Int32), @p1384='2020-06-30T18:08:43', @p1385=NULL (DbType = Int32), @p1386=NULL (DbType = Int32), @p1387='105504', @p1388='2020-06-29T21:53:17', @p1389='2' (Nullable = true), @p1390='159' (Nullable = true), @p1391='False', @p1392='35.334856600000', @p1393='20035', @p1394='-101.404188700000', @p1395='504768784', @p1396='0xE6100000010CC5ECC094DCAA41406BFA473ADE5959C0' (Nullable = false) (Size = 22) (DbType = Object), @p1397='4' (Nullable = true), @p1398='2020-06-30T18:08:43', @p1399='1' (Nullable = true), @p1400=NULL (DbType = Int32), @p1401='96809', @p1402='2020-06-30T17:10:22', @p1403='2' (Nullable = true), @p1404='87' (Nullable = true), @p1405='False', @p1406='30.243687200000', @p1407='20035', @p1408='-94.189720600000', @p1409='504768849', @p1410='0xE6100000010C2D74CA48623E3E402918DF61248C57C0' (Nullable = false) (Size = 22) (DbType = Object), @p1411='5' (Nullable = true), @p1412='2020-06-30T18:08:59', @p1413='5' (Nullable = true), @p1414=NULL (DbType = Int32), @p1415='96809', @p1416='2020-06-30T17:25:24', @p1417='2' (Nullable = true), @p1418='73' (Nullable = true), @p1419='False', @p1420='30.170670800000', @p1421='20035', @p1422='-94.173382200000', @p1423='504768851', @p1424='0xE6100000010CD561E014B12B3E4059ADA7B1188B57C0' (Nullable = false) (Size = 22) (DbType = Object), @p1425='5' (Nullable = true), @p1426='2020-06-30T18:08:59', @p1427='10' (Nullable = true), @p1428=NULL (DbType = Int32), @p1429='96809', @p1430='2020-06-30T17:40:22', @p1431='3' (Nullable = true), @p1432='73' (Nullable = true), @p1433='False', @p1434='30.118333700000', @p1435='20035', @p1436='-94.134139100000', @p1437='504768852', @p1438='0xE6100000010CC2830B1E4B1E3E405AE729BC958857C0' (Nullable = false) (Size = 22) (DbType = Object), @p1439='5' (Nullable = true), @p1440='2020-06-30T18:08:59', @p1441='5' (Nullable = true), @p1442=NULL (DbType = Int32), @p1443='96809', @p1444='2020-06-30T17:55:23', @p1445='4' (Nullable = true), @p1446='74' (Nullable = true), @p1447='False', @p1448='30.097849700000', @p1449='20035', @p1450='-94.118749200000', @p1451='504768853', @p1452='0xE6100000010C656C8DAD0C193E40469B3E96998757C0' (Nullable = false) (Size = 22) (DbType = Object), @p1453='5' (Nullable = true), @p1454='2020-06-30T18:08:59', @p1455='1' (Nullable = true), @p1456=NULL (DbType = Int32), @p1457='96809', @p1458='2020-06-30T18:08:43', @p1459='5' (Nullable = true), @p1460='2' (Nullable = true), @p1461='False', @p1462='30.097267700000', @p1463='20035', @p1464='-94.118336700000', @p1465='504768854', @p1466='0xE6100000010C07753689E6183E40A91A18D4928757C0' (Nullable = false) (Size = 22) (DbType = Object), @p1467='5' (Nullable = true), @p1468='2020-06-30T18:09:00', @p1469='0' (Nullable = true), @p1470=NULL (DbType = Int32), @p1471='96809', @p1472='2020-06-30T18:08:37', @p1473=NULL, @p1474=NULL (DbType = Int32), @p1475='False', @p1476='0.000000000000', @p1477='40003', @p1478='0.000000000000', @p1479='504768855', @p1480='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1481=NULL (DbType = Int32), @p1482='2020-06-30T18:09:00', @p1483=NULL (DbType = Int32), @p1484=NULL (DbType = Int32), @p1485='103610', @p1486='2020-06-30T18:08:03', @p1487=NULL, @p1488=NULL (DbType = Int32), @p1489='False', @p1490='0.000000000000', @p1491='40001', @p1492='0.000000000000', @p1493='504768878', @p1494='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1495=NULL (DbType = Int32), @p1496='2020-06-30T18:09:12', @p1497=NULL (DbType = Int32), @p1498=NULL (DbType = Int32), @p1499='96809', @p1500='2020-06-30T16:55:22', @p1501='2' (Nullable = true), @p1502='85' (Nullable = true), @p1503='False', @p1504='30.296906800000', @p1505='20035', @p1506='-94.184055200000', @p1507='504768848', @p1508='0xE6100000010CC3F58315024C3E40292A768FC78B57C0' (Nullable = false) (Size = 22) (DbType = Object), @p1509='5' (Nullable = true), @p1510='2020-06-30T18:08:59', @p1511='3' (Nullable = true), @p1512=NULL (DbType = Int32), @p1513='103610', @p1514='2020-06-30T18:08:49', @p1515='2' (Nullable = true), @p1516='8' (Nullable = true), @p1517='False', @p1518='48.668324400000', @p1519='20035', @p1520='17.051551000000', @p1521='504768879', @p1522='0xE6100000010C368F68A78B5548407B134372320D3140' (Nullable = false) (Size = 22) (DbType = Object), @p1523='4' (Nullable = true), @p1524='2020-06-30T18:09:12', @p1525='8' (Nullable = true), @p1526=NULL (DbType = Int32), @p1527='92382', @p1528='2020-06-30T17:10:54', @p1529='1' (Nullable = true), @p1530='90' (Nullable = true), @p1531='False', @p1532='30.242683100000', @p1533='20035', @p1534='-94.189718400000', @p1535='504768885', @p1536='0xE6100000010CBACAC97A203E3E40C4DCA458248C57C0' (Nullable = false) (Size = 22) (DbType = Object), @p1537='5' (Nullable = true), @p1538='2020-06-30T18:09:15', @p1539='6' (Nullable = true), @p1540=NULL (DbType = Int32), @p1541='92382', @p1542='2020-06-30T17:25:54', @p1543='1' (Nullable = true), @p1544='73' (Nullable = true), @p1545='False', @p1546='30.168847500000', @p1547='20035', @p1548='-94.172016600000', @p1549='504768886', @p1550='0xE6100000010CE882FA96392B3E40A0D7E951028B57C0' (Nullable = false) (Size = 22) (DbType = Object), @p1551='5' (Nullable = true), @p1552='2020-06-30T18:09:15', @p1553='10' (Nullable = true), @p1554=NULL (DbType = Int32), @p1555='92382', @p1556='2020-06-30T17:40:54', @p1557='2' (Nullable = true), @p1558='73' (Nullable = true), @p1559='False', @p1560='30.117851200000', @p1561='20035', @p1562='-94.133768100000', @p1563='504768887', @p1564='0xE6100000010C5BCB097F2B1E3E40E0AF13A88F8857C0' (Nullable = false) (Size = 22) (DbType = Object), @p1565='5' (Nullable = true), @p1566='2020-06-30T18:09:15', @p1567='5' (Nullable = true), @p1568=NULL (DbType = Int32), @p1569='92382', @p1570='2020-06-30T17:55:54', @p1571='3' (Nullable = true), @p1572='73' (Nullable = true), @p1573='False', @p1574='30.098417900000', @p1575='20035', @p1576='-94.119161700000', @p1577='504768888', @p1578='0xE6100000010C4CD75DEA31193E40E41B6558A08757C0' (Nullable = false) (Size = 22) (DbType = Object), @p1579='5' (Nullable = true), @p1580='2020-06-30T18:09:16', @p1581='0' (Nullable = true), @p1582=NULL (DbType = Int32), @p1583='92382', @p1584='2020-06-30T18:08:55', @p1585='1' (Nullable = true), @p1586='47' (Nullable = true), @p1587='False', @p1588='30.098384400000', @p1589='20035', @p1590='-94.119161200000', @p1591='504768889', @p1592='0xE6100000010CC46F54B82F193E40EF3C4C56A08757C0' (Nullable = false) (Size = 22) (DbType = Object), @p1593='8' (Nullable = true), @p1594='2020-06-30T18:09:16', @p1595='0' (Nullable = true), @p1596=NULL (DbType = Int32), @p1597='92382', @p1598='2020-06-30T18:08:13', @p1599=NULL, @p1600=NULL (DbType = Int32), @p1601='False', @p1602='0.000000000000', @p1603='40003', @p1604='0.000000000000', @p1605='504768892', @p1606='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1607=NULL (DbType = Int32), @p1608='2020-06-30T18:09:16', @p1609=NULL (DbType = Int32), @p1610=NULL (DbType = Int32), @p1611='103323', @p1612='2020-06-30T16:50:18', @p1613='1' (Nullable = true), @p1614='29' (Nullable = true), @p1615='False', @p1616='43.807763600000', @p1617='20035', @p1618='4.598809700000', @p1619='504768898', @p1620='0xE6100000010C1A7332CC64E745403C1CB85E2E651240' (Nullable = false) (Size = 22) (DbType = Object), @p1621='5' (Nullable = true), @p1622='2020-06-30T18:09:18', @p1623='27' (Nullable = true), @p1624=NULL (DbType = Int32), @p1625='92382', @p1626='2020-06-30T16:55:54', @p1627='1' (Nullable = true), @p1628='85' (Nullable = true), @p1629='False', @p1630='30.297499200000', @p1631='20035', @p1632='-94.184227600000', @p1633='504768883', @p1634='0xE6100000010C0F9656E8284C3E4051418F62CA8B57C0' (Nullable = false) (Size = 22) (DbType = Object), @p1635='5' (Nullable = true), @p1636='2020-06-30T18:09:15', @p1637='2' (Nullable = true), @p1638='1' (Nullable = true), @p1639='124324', @p1640='2020-06-30T18:08:35', @p1641=NULL, @p1642='0' (Nullable = true), @p1643='False', @p1644='29.693424224854', @p1645='20034', @p1646='-94.891906738281', @p1647='504768839', @p1648='0xE6100000010C8800004084B13D40EEFFFFFF14B957C0' (Nullable = false) (Size = 22) (DbType = Object), @p1649=NULL (DbType = Int32), @p1650='2020-06-30T18:08:52', @p1651='0' (Nullable = true), @p1652=NULL (DbType = Int32), @p1653='124324', @p1654='2020-06-30T18:07:56', @p1655=NULL, @p1656=NULL (DbType = Int32), @p1657='False', @p1658='0.000000000000', @p1659='40001', @p1660='0.000000000000', @p1661='504768838', @p1662='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1663=NULL (DbType = Int32), @p1664='2020-06-30T18:08:52', @p1665=NULL (DbType = Int32), @p1666=NULL (DbType = Int32), @p1667='100845', @p1668='2020-06-30T18:08:25', @p1669='1' (Nullable = true), @p1670='82' (Nullable = true), @p1671='False', @p1672='35.128298600000', @p1673='20031', @p1674='-97.391268500000', @p1675='504768809', @p1676='0xE6100000010CB18FA9166C9041401EDD088B0A5958C0' (Nullable = false) (Size = 22) (DbType = Object), @p1677='6' (Nullable = true), @p1678='2020-06-30T18:08:46', @p1679='1' (Nullable = true), @p1680=NULL (DbType = Int32), @p1681='105504', @p1682='2020-06-29T22:05:40', @p1683=NULL, @p1684=NULL (DbType = Int32), @p1685='False', @p1686='0.000000000000', @p1687='40003', @p1688='0.000000000000', @p1689='504768785', @p1690='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1691=NULL (DbType = Int32), @p1692='2020-06-30T18:08:43', @p1693=NULL (DbType = Int32), @p1694=NULL (DbType = Int32), @p1695='105504', @p1696='2020-06-29T22:06:18', @p1697='1' (Nullable = true), @p1698='0' (Nullable = true), @p1699='False', @p1700='35.328649300000', @p1701='20035', @p1702='-101.406326600000', @p1703='504768786', @p1704='0xE6100000010C39AD252E11AA4140AC9F4841015A59C0' (Nullable = false) (Size = 22) (DbType = Object), @p1705='6' (Nullable = true), @p1706='2020-06-30T18:08:43', @p1707='0' (Nullable = true), @p1708=NULL (DbType = Int32), @p1709='105504', @p1710='2020-06-29T22:29:51', @p1711=NULL, @p1712=NULL (DbType = Int32), @p1713='False', @p1714='0.000000000000', @p1715='40001', @p1716='0.000000000000', @p1717='504768787', @p1718='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1719=NULL (DbType = Int32), @p1720='2020-06-30T18:08:43', @p1721=NULL (DbType = Int32), @p1722=NULL (DbType = Int32), @p1723='105504', @p1724='2020-06-29T22:29:53', @p1725='1' (Nullable = true), @p1726='142' (Nullable = true), @p1727='False', @p1728='35.328667300000', @p1729='20035', @p1730='-101.406400100000', @p1731='504768789', @p1732='0xE6100000010CDF6124C511AA4140D5A59075025A59C0' (Nullable = false) (Size = 22) (DbType = Object), @p1733='5' (Nullable = true), @p1734='2020-06-30T18:08:44', @p1735='0' (Nullable = true), @p1736=NULL (DbType = Int32), @p1737='105504', @p1738='2020-06-29T23:30:31', @p1739='1' (Nullable = true), @p1740='92' (Nullable = true), @p1741='False', @p1742='35.204345500000', @p1743='20035', @p1744='-101.826882200000', @p1745='504768790', @p1746='0xE6100000010CDACA4BFE279A414040A951A3EB7459C0' (Nullable = false) (Size = 22) (DbType = Object), @p1747='9' (Nullable = true), @p1748='2020-06-30T18:08:44', @p1749='3' (Nullable = true), @p1750=NULL (DbType = Int32), @p1751='105504', @p1752='2020-06-29T23:40:16', @p1753=NULL, @p1754=NULL (DbType = Int32), @p1755='False', @p1756='0.000000000000', @p1757='40003', @p1758='0.000000000000', @p1759='504768791', @p1760='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1761=NULL (DbType = Int32), @p1762='2020-06-30T18:08:44', @p1763=NULL (DbType = Int32), @p1764=NULL (DbType = Int32), @p1765='105504', @p1766='2020-06-29T23:40:18', @p1767='1' (Nullable = true), @p1768='35' (Nullable = true), @p1769='False', @p1770='35.196396800000', @p1771='20035', @p1772='-101.828247400000', @p1773='504768792', @p1774='0xE6100000010C0085C48723994140CFFF6101027559C0' (Nullable = false) (Size = 22) (DbType = Object), @p1775='8' (Nullable = true), @p1776='2020-06-30T18:08:44', @p1777='1' (Nullable = true), @p1778=NULL (DbType = Int32), @p1779='105504', @p1780='2020-06-30T18:08:01', @p1781='1' (Nullable = true), @p1782='0' (Nullable = true), @p1783='False', @p1784='35.196377200000', @p1785='20035', @p1786='-101.828211600000', @p1787='504768793', @p1788='0xE6100000010C0CD759E322994140BE0A3A6B017559C0' (Nullable = false) (Size = 22) (DbType = Object), @p1789='8' (Nullable = true), @p1790='2020-06-30T18:08:44', @p1791='0' (Nullable = true), @p1792=NULL (DbType = Int32), @p1793='104773', @p1794='2020-06-30T14:54:01', @p1795=NULL, @p1796=NULL (DbType = Int32), @p1797='False', @p1798='0.000000000000', @p1799='40001', @p1800='0.000000000000', @p1801='504768794', @p1802='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1803=NULL (DbType = Int32), @p1804='2020-06-30T18:08:44', @p1805=NULL (DbType = Int32), @p1806=NULL (DbType = Int32), @p1807='104773', @p1808='2020-06-30T14:54:36', @p1809='0' (Nullable = true), @p1810='0' (Nullable = true), @p1811='False', @p1812='35.518766200000', @p1813='20035', @p1814='-101.493278100000', @p1815='504768795', @p1816='0xE6100000010C96A24BEE66C2414050D54EDE915F59C0' (Nullable = false) (Size = 22) (DbType = Object), @p1817='10' (Nullable = true), @p1818='2020-06-30T18:08:44', @p1819='0' (Nullable = true), @p1820=NULL (DbType = Int32), @p1821='104773', @p1822='2020-06-30T15:10:13', @p1823=NULL, @p1824=NULL (DbType = Int32), @p1825='False', @p1826='0.000000000000', @p1827='40003', @p1828='0.000000000000', @p1829='504768796', @p1830='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1831=NULL (DbType = Int32), @p1832='2020-06-30T18:08:45', @p1833=NULL (DbType = Int32), @p1834=NULL (DbType = Int32), @p1835='104773', @p1836='2020-06-30T15:10:15', @p1837='0' (Nullable = true), @p1838='0' (Nullable = true), @p1839='False', @p1840='35.518921100000', @p1841='20035', @p1842='-101.493144800000', @p1843='504768798', @p1844='0xE6100000010C28DAB0016CC24140510C35AF8F5F59C0' (Nullable = false) (Size = 22) (DbType = Object), @p1845='9' (Nullable = true), @p1846='2020-06-30T18:08:45', @p1847='0' (Nullable = true), @p1848=NULL (DbType = Int32), @p1849='104773', @p1850='2020-06-30T18:06:36', @p1851='0' (Nullable = true), @p1852='0' (Nullable = true), @p1853='False', @p1854='35.518917000000', @p1855='20035', @p1856='-101.493195800000', @p1857='504768799', @p1858='0xE6100000010C522B4CDF6BC2414092E11D85905F59C0' (Nullable = false) (Size = 22) (DbType = Object), @p1859='9' (Nullable = true), @p1860='2020-06-30T18:08:45', @p1861='0' (Nullable = true), @p1862=NULL (DbType = Int32), @p1863='99745', @p1864='2020-06-30T06:08:03', @p1865=NULL, @p1866=NULL (DbType = Int32), @p1867='False', @p1868='33.446757100000', @p1869='20034', @p1870='-94.167855800000', @p1871='504768800', @p1872='0xE6100000010CBEE02E562FB9404069DC4026BE8A57C0' (Nullable = false) (Size = 22) (DbType = Object), @p1873=NULL (DbType = Int32), @p1874='2020-06-30T18:08:45', @p1875=NULL (DbType = Int32), @p1876=NULL (DbType = Int32), @p1877='99745', @p1878='2020-06-30T12:08:03', @p1879=NULL, @p1880=NULL (DbType = Int32), @p1881='False', @p1882='33.446771800000', @p1883='20034', @p1884='-94.167835800000', @p1885='504768801', @p1886='0xE6100000010C35E37ED12FB9404046065ED2BD8A57C0' (Nullable = false) (Size = 22) (DbType = Object), @p1887=NULL (DbType = Int32), @p1888='2020-06-30T18:08:45', @p1889=NULL (DbType = Int32), @p1890=NULL (DbType = Int32), @p1891='99745', @p1892='2020-06-30T18:08:02', @p1893=NULL, @p1894=NULL (DbType = Int32), @p1895='False', @p1896='33.446776800000', @p1897='20034', @p1898='-94.167860400000', @p1899='504768802', @p1900='0xE6100000010C474E70FB2FB94040C8128C39BE8A57C0' (Nullable = false) (Size = 22) (DbType = Object), @p1901=NULL (DbType = Int32), @p1902='2020-06-30T18:08:45', @p1903=NULL (DbType = Int32), @p1904=NULL (DbType = Int32), @p1905='100845', @p1906='2020-06-30T18:08:25', @p1907=NULL, @p1908=NULL (DbType = Int32), @p1909='False', @p1910='35.128298600000', @p1911='20034', @p1912='-97.391268500000', @p1913='504768807', @p1914='0xE6100000010CB18FA9166C9041401EDD088B0A5958C0' (Nullable = false) (Size = 22) (DbType = Object), @p1915=NULL (DbType = Int32), @p1916='2020-06-30T18:08:45', @p1917=NULL (DbType = Int32), @p1918=NULL (DbType = Int32), @p1919='103323', @p1920='2020-06-30T17:10:18', @p1921='2' (Nullable = true), @p1922='78' (Nullable = true), @p1923='False', @p1924='43.676214800000', @p1925='20035', @p1926='4.636719400000', @p1927='504768902', @p1928='0xE6100000010C1C89E1348ED645403BEA9E2B008C1240' (Nullable = false) (Size = 22) (DbType = Object), @p1929='4' (Nullable = true), @p1930='2020-06-30T18:09:19', @p1931='27' (Nullable = true), @p1932=NULL (DbType = Int32), @p1933='112047', @p1934='2020-06-30T11:08:49', @p1935='2' (Nullable = true), @p1936='0' (Nullable = true), @p1937='False', @p1938='44.620062400000', @p1939='20035', @p1940='20.966825900000', @p1941='504772445', @p1942='0xE6100000010C59BD68345E4F4640FF6CF5E681F73440' (Nullable = false) (Size = 22) (DbType = Object), @p1943='4' (Nullable = true), @p1944='2020-06-30T18:27:36', @p1945='0' (Nullable = true), @p1946=NULL (DbType = Int32), @p1947='120457', @p1948='2020-06-29T21:41:10', @p1949=NULL, @p1950=NULL (DbType = Int32), @p1951='False', @p1952='0.000000000000', @p1953='40003', @p1954='0.000000000000', @p1955='504769404', @p1956='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1957=NULL (DbType = Int32), @p1958='2020-06-30T18:11:15', @p1959=NULL (DbType = Int32), @p1960=NULL (DbType = Int32), @p1961='105186', @p1962='2020-06-30T18:11:00', @p1963='4' (Nullable = true), @p1964='46' (Nullable = true), @p1965='False', @p1966='46.652647700000', @p1967='20035', @p1968='13.784220700000', @p1969='504769411', @p1970='0xE6100000010CA2A7B7F58953474045B1266085912B40' (Nullable = false) (Size = 22) (DbType = Object), @p1971='4' (Nullable = true), @p1972='2020-06-30T18:11:15', @p1973='5' (Nullable = true), @p1974=NULL (DbType = Int32), @p1975='40290', @p1976='2020-06-30T00:05:03', @p1977='0' (Nullable = true), @p1978='0' (Nullable = true), @p1979='False', @p1980='34.066886900000', @p1981='20035', @p1982='-117.412707600000', @p1983='504771610', @p1984='0xE6100000010CF203FCBF8F084140E23323CD695A5DC0' (Nullable = false) (Size = 22) (DbType = Object), @p1985='9' (Nullable = true), @p1986='2020-06-30T18:21:08', @p1987='0' (Nullable = true), @p1988=NULL (DbType = Int32), @p1989='40290', @p1990='2020-06-30T00:13:29', @p1991=NULL, @p1992=NULL (DbType = Int32), @p1993='False', @p1994='0.000000000000', @p1995='40001', @p1996='0.000000000000', @p1997='504771611', @p1998='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p1999=NULL (DbType = Int32), @p2000='2020-06-30T18:21:09', @p2001=NULL (DbType = Int32), @p2002=NULL (DbType = Int32), @p2003='40290', @p2004='2020-06-30T00:13:31', @p2005='0' (Nullable = true), @p2006='0' (Nullable = true), @p2007='False', @p2008='34.066964400000', @p2009='20035', @p2010='-117.412752700000', @p2011='504771612', @p2012='0xE6100000010C86FF194A920841407CF54C8A6A5A5DC0' (Nullable = false) (Size = 22) (DbType = Object), @p2013='10' (Nullable = true), @p2014='2020-06-30T18:21:09', @p2015='0' (Nullable = true), @p2016=NULL (DbType = Int32), @p2017='40290', @p2018='2020-06-30T00:18:48', @p2019=NULL, @p2020=NULL (DbType = Int32), @p2021='False', @p2022='0.000000000000', @p2023='40003', @p2024='0.000000000000', @p2025='504771613', @p2026='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p2027=NULL (DbType = Int32), @p2028='2020-06-30T18:21:09', @p2029=NULL (DbType = Int32), @p2030=NULL (DbType = Int32), @p2031='40290', @p2032='2020-06-30T00:18:50', @p2033='0' (Nullable = true), @p2034='0' (Nullable = true), @p2035='False', @p2036='34.066900900000', @p2037='20035', @p2038='-117.412783100000', @p2039='504771614', @p2040='0xE6100000010C57C96C3590084140DBB5CE096B5A5DC0' (Nullable = false) (Size = 22) (DbType = Object), @p2041='10' (Nullable = true), @p2042='2020-06-30T18:21:09', @p2043='0' (Nullable = true), @p2044=NULL (DbType = Int32), @p2045='40290', @p2046='2020-06-30T00:23:30', @p2047=NULL, @p2048=NULL (DbType = Int32), @p2049='False', @p2050='0.000000000000', @p2051='40001', @p2052='0.000000000000', @p2053='504771615', @p2054='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p2055=NULL (DbType = Int32), @p2056='2020-06-30T18:21:09', @p2057=NULL (DbType = Int32), @p2058=NULL (DbType = Int32), @p2059='40290', @p2060='2020-06-30T00:23:32', @p2061='1' (Nullable = true), @p2062='26' (Nullable = true), @p2063='False', @p2064='34.066868000000', @p2065='20035', @p2066='-117.412800800000', @p2067='504771618', @p2068='0xE6100000010C109370218F084140CFF00B546B5A5DC0' (Nullable = false) (Size = 22) (DbType = Object), @p2069='8' (Nullable = true), @p2070='2020-06-30T18:21:09', @p2071='0' (Nullable = true), @p2072=NULL (DbType = Int32), @p2073='40290', @p2074='2020-06-30T00:05:01', @p2075=NULL, @p2076=NULL (DbType = Int32), @p2077='False', @p2078='0.000000000000', @p2079='40003', @p2080='0.000000000000', @p2081='504771609', @p2082='0xE6100000010C00000000000000000000000000000000' (Nullable = false) (Size = 22) (DbType = Object), @p2083=NULL (DbType = Int32), @p2084='2020-06-30T18:21:08', @p2085=NULL (DbType = Int32)], CommandType='Text', CommandTimeout='300'] SET NOCOUNT ON; DECLARE @inserted0 TABLE ([PrimaryKeyID] int, [_GeographyPointBytes] [int]); MERGE [TableToInsertTo] USING ( VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, 0), (@p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, 1), (@p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, 2), (@p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, @p54, @p55, 3), (@p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, @p67, @p68, @p69, 4), (@p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, 5), (@p84, @p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95, @p96, @p97, 6), (@p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106, @p107, @p108, @p109, @p110, @p111, 7), (@p112, @p113, @p114, @p115, @p116, @p117, @p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, 8), (@p126, @p127, @p128, @p129, @p130, @p131, @p132, @p133, @p134, @p135, @p136, @p137, @p138, @p139, 9), (@p140, @p141, @p142, @p143, @p144, @p145, @p146, @p147, @p148, @p149, @p150, @p151, @p152, @p153, 10), (@p154, @p155, @p156, @p157, @p158, @p159, @p160, @p161, @p162, @p163, @p164, @p165, @p166, @p167, 11), (@p168, @p169, @p170, @p171, @p172, @p173, @p174, @p175, @p176, @p177, @p178, @p179, @p180, @p181, 12), (@p182, @p183, @p184, @p185, @p186, @p187, @p188, @p189, @p190, @p191, @p192, @p193, @p194, @p195, 13), (@p196, @p197, @p198, @p199, @p200, @p201, @p202, @p203, @p204, @p205, @p206, @p207, @p208, @p209, 14), (@p210, @p211, @p212, @p213, @p214, @p215, @p216, @p217, @p218, @p219, @p220, @p221, @p222, @p223, 15), (@p224, @p225, @p226, @p227, @p228, @p229, @p230, @p231, @p232, @p233, @p234, @p235, @p236, @p237, 16), (@p238, @p239, @p240, @p241, @p242, @p243, @p244, @p245, @p246, @p247, @p248, @p249, @p250, @p251, 17), (@p252, @p253, @p254, @p255, @p256, @p257, @p258, @p259, @p260, @p261, @p262, @p263, @p264, @p265, 18), (@p266, @p267, @p268, @p269, @p270, @p271, @p272, @p273, @p274, @p275, @p276, @p277, @p278, @p279, 19), (@p280, @p281, @p282, @p283, @p284, @p285, @p286, @p287, @p288, @p289, @p290, @p291, @p292, @p293, 20), (@p294, @p295, @p296, @p297, @p298, @p299, @p300, @p301, @p302, @p303, @p304, @p305, @p306, @p307, 21), (@p308, @p309, @p310, @p311, @p312, @p313, @p314, @p315, @p316, @p317, @p318, @p319, @p320, @p321, 22), (@p322, @p323, @p324, @p325, @p326, @p327, @p328, @p329, @p330, @p331, @p332, @p333, @p334, @p335, 23), (@p336, @p337, @p338, @p339, @p340, @p341, @p342, @p343, @p344, @p345, @p346, @p347, @p348, @p349, 24), (@p350, @p351, @p352, @p353, @p354, @p355, @p356, @p357, @p358, @p359, @p360, @p361, @p362, @p363, 25), (@p364, @p365, @p366, @p367, @p368, @p369, @p370, @p371, @p372, @p373, @p374, @p375, @p376, @p377, 26), (@p378, @p379, @p380, @p381, @p382, @p383, @p384, @p385, @p386, @p387, @p388, @p389, @p390, @p391, 27), (@p392, @p393, @p394, @p395, @p396, @p397, @p398, @p399, @p400, @p401, @p402, @p403, @p404, @p405, 28), (@p406, @p407, @p408, @p409, @p410, @p411, @p412, @p413, @p414, @p415, @p416, @p417, @p418, @p419, 29), (@p420, @p421, @p422, @p423, @p424, @p425, @p426, @p427, @p428, @p429, @p430, @p431, @p432, @p433, 30), (@p434, @p435, @p436, @p437, @p438, @p439, @p440, @p441, @p442, @p443, @p444, @p445, @p446, @p447, 31), (@p448, @p449, @p450, @p451, @p452, @p453, @p454, @p455, @p456, @p457, @p458, @p459, @p460, @p461, 32), (@p462, @p463, @p464, @p465, @p466, @p467, @p468, @p469, @p470, @p471, @p472, @p473, @p474, @p475, 33), (@p476, @p477, @p478, @p479, @p480, @p481, @p482, @p483, @p484, @p485, @p486, @p487, @p488, @p489, 34), (@p490, @p491, @p492, @p493, @p494, @p495, @p496, @p497, @p498, @p499, @p500, @p501, @p502, @p503, 35), (@p504, @p505, @p506, @p507, @p508, @p509, @p510, @p511, @p512, @p513, @p514, @p515, @p516, @p517, 36), (@p518, @p519, @p520, @p521, @p522, @p523, @p524, @p525, @p526, @p527, @p528, @p529, @p530, @p531, 37), (@p532, @p533, @p534, @p535, @p536, @p537, @p538, @p539, @p540, @p541, @p542, @p543, @p544, @p545, 38), (@p546, @p547, @p548, @p549, @p550, @p551, @p552, @p553, @p554, @p555, @p556, @p557, @p558, @p559, 39), (@p560, @p561, @p562, @p563, @p564, @p565, @p566, @p567, @p568, @p569, @p570, @p571, @p572, @p573, 40), (@p574, @p575, @p576, @p577, @p578, @p579, @p580, @p581, @p582, @p583, @p584, @p585, @p586, @p587, 41), (@p588, @p589, @p590, @p591, @p592, @p593, @p594, @p595, @p596, @p597, @p598, @p599, @p600, @p601, 42), (@p602, @p603, @p604, @p605, @p606, @p607, @p608, @p609, @p610, @p611, @p612, @p613, @p614, @p615, 43), (@p616, @p617, @p618, @p619, @p620, @p621, @p622, @p623, @p624, @p625, @p626, @p627, @p628, @p629, 44), (@p630, @p631, @p632, @p633, @p634, @p635, @p636, @p637, @p638, @p639, @p640, @p641, @p642, @p643, 45), (@p644, @p645, @p646, @p647, @p648, @p649, @p650, @p651, @p652, @p653, @p654, @p655, @p656, @p657, 46), (@p658, @p659, @p660, @p661, @p662, @p663, @p664, @p665, @p666, @p667, @p668, @p669, @p670, @p671, 47), (@p672, @p673, @p674, @p675, @p676, @p677, @p678, @p679, @p680, @p681, @p682, @p683, @p684, @p685, 48), (@p686, @p687, @p688, @p689, @p690, @p691, @p692, @p693, @p694, @p695, @p696, @p697, @p698, @p699, 49), (@p700, @p701, @p702, @p703, @p704, @p705, @p706, @p707, @p708, @p709, @p710, @p711, @p712, @p713, 50), (@p714, @p715, @p716, @p717, @p718, @p719, @p720, @p721, @p722, @p723, @p724, @p725, @p726, @p727, 51), (@p728, @p729, @p730, @p731, @p732, @p733, @p734, @p735, @p736, @p737, @p738, @p739, @p740, @p741, 52), (@p742, @p743, @p744, @p745, @p746, @p747, @p748, @p749, @p750, @p751, @p752, @p753, @p754, @p755, 53), (@p756, @p757, @p758, @p759, @p760, @p761, @p762, @p763, @p764, @p765, @p766, @p767, @p768, @p769, 54), (@p770, @p771, @p772, @p773, @p774, @p775, @p776, @p777, @p778, @p779, @p780, @p781, @p782, @p783, 55), (@p784, @p785, @p786, @p787, @p788, @p789, @p790, @p791, @p792, @p793, @p794, @p795, @p796, @p797, 56), (@p798, @p799, @p800, @p801, @p802, @p803, @p804, @p805, @p806, @p807, @p808, @p809, @p810, @p811, 57), (@p812, @p813, @p814, @p815, @p816, @p817, @p818, @p819, @p820, @p821, @p822, @p823, @p824, @p825, 58), (@p826, @p827, @p828, @p829, @p830, @p831, @p832, @p833, @p834, @p835, @p836, @p837, @p838, @p839, 59), (@p840, @p841, @p842, @p843, @p844, @p845, @p846, @p847, @p848, @p849, @p850, @p851, @p852, @p853, 60), (@p854, @p855, @p856, @p857, @p858, @p859, @p860, @p861, @p862, @p863, @p864, @p865, @p866, @p867, 61), (@p868, @p869, @p870, @p871, @p872, @p873, @p874, @p875, @p876, @p877, @p878, @p879, @p880, @p881, 62), (@p882, @p883, @p884, @p885, @p886, @p887, @p888, @p889, @p890, @p891, @p892, @p893, @p894, @p895, 63), (@p896, @p897, @p898, @p899, @p900, @p901, @p902, @p903, @p904, @p905, @p906, @p907, @p908, @p909, 64), (@p910, @p911, @p912, @p913, @p914, @p915, @p916, @p917, @p918, @p919, @p920, @p921, @p922, @p923, 65), (@p924, @p925, @p926, @p927, @p928, @p929, @p930, @p931, @p932, @p933, @p934, @p935, @p936, @p937, 66), (@p938, @p939, @p940, @p941, @p942, @p943, @p944, @p945, @p946, @p947, @p948, @p949, @p950, @p951, 67), (@p952, @p953, @p954, @p955, @p956, @p957, @p958, @p959, @p960, @p961, @p962, @p963, @p964, @p965, 68), (@p966, @p967, @p968, @p969, @p970, @p971, @p972, @p973, @p974, @p975, @p976, @p977, @p978, @p979, 69), (@p980, @p981, @p982, @p983, @p984, @p985, @p986, @p987, @p988, @p989, @p990, @p991, @p992, @p993, 70), (@p994, @p995, @p996, @p997, @p998, @p999, @p1000, @p1001, @p1002, @p1003, @p1004, @p1005, @p1006, @p1007, 71), (@p1008, @p1009, @p1010, @p1011, @p1012, @p1013, @p1014, @p1015, @p1016, @p1017, @p1018, @p1019, @p1020, @p1021, 72), (@p1022, @p1023, @p1024, @p1025, @p1026, @p1027, @p1028, @p1029, @p1030, @p1031, @p1032, @p1033, @p1034, @p1035, 73), (@p1036, @p1037, @p1038, @p1039, @p1040, @p1041, @p1042, @p1043, @p1044, @p1045, @p1046, @p1047, @p1048, @p1049, 74), (@p1050, @p1051, @p1052, @p1053, @p1054, @p1055, @p1056, @p1057, @p1058, @p1059, @p1060, @p1061, @p1062, @p1063, 75), (@p1064, @p1065, @p1066, @p1067, @p1068, @p1069, @p1070, @p1071, @p1072, @p1073, @p1074, @p1075, @p1076, @p1077, 76), (@p1078, @p1079, @p1080, @p1081, @p1082, @p1083, @p1084, @p1085, @p1086, @p1087, @p1088, @p1089, @p1090, @p1091, 77), (@p1092, @p1093, @p1094, @p1095, @p1096, @p1097, @p1098, @p1099, @p1100, @p1101, @p1102, @p1103, @p1104, @p1105, 78), (@p1106, @p1107, @p1108, @p1109, @p1110, @p1111, @p1112, @p1113, @p1114, @p1115, @p1116, @p1117, @p1118, @p1119, 79), (@p1120, @p1121, @p1122, @p1123, @p1124, @p1125, @p1126, @p1127, @p1128, @p1129, @p1130, @p1131, @p1132, @p1133, 80), (@p1134, @p1135, @p1136, @p1137, @p1138, @p1139, @p1140, @p1141, @p1142, @p1143, @p1144, @p1145, @p1146, @p1147, 81), (@p1148, @p1149, @p1150, @p1151, @p1152, @p1153, @p1154, @p1155, @p1156, @p1157, @p1158, @p1159, @p1160, @p1161, 82), (@p1162, @p1163, @p1164, @p1165, @p1166, @p1167, @p1168, @p1169, @p1170, @p1171, @p1172, @p1173, @p1174, @p1175, 83), (@p1176, @p1177, @p1178, @p1179, @p1180, @p1181, @p1182, @p1183, @p1184, @p1185, @p1186, @p1187, @p1188, @p1189, 84), (@p1190, @p1191, @p1192, @p1193, @p1194, @p1195, @p1196, @p1197, @p1198, @p1199, @p1200, @p1201, @p1202, @p1203, 85), (@p1204, @p1205, @p1206, @p1207, @p1208, @p1209, @p1210, @p1211, @p1212, @p1213, @p1214, @p1215, @p1216, @p1217, 86), (@p1218, @p1219, @p1220, @p1221, @p1222, @p1223, @p1224, @p1225, @p1226, @p1227, @p1228, @p1229, @p1230, @p1231, 87), (@p1232, @p1233, @p1234, @p1235, @p1236, @p1237, @p1238, @p1239, @p1240, @p1241, @p1242, @p1243, @p1244, @p1245, 88), (@p1246, @p1247, @p1248, @p1249, @p1250, @p1251, @p1252, @p1253, @p1254, @p1255, @p1256, @p1257, @p1258, @p1259, 89), (@p1260, @p1261, @p1262, @p1263, @p1264, @p1265, @p1266, @p1267, @p1268, @p1269, @p1270, @p1271, @p1272, @p1273, 90), (@p1274, @p1275, @p1276, @p1277, @p1278, @p1279, @p1280, @p1281, @p1282, @p1283, @p1284, @p1285, @p1286, @p1287, 91), (@p1288, @p1289, @p1290, @p1291, @p1292, @p1293, @p1294, @p1295, @p1296, @p1297, @p1298, @p1299, @p1300, @p1301, 92), (@p1302, @p1303, @p1304, @p1305, @p1306, @p1307, @p1308, @p1309, @p1310, @p1311, @p1312, @p1313, @p1314, @p1315, 93), (@p1316, @p1317, @p1318, @p1319, @p1320, @p1321, @p1322, @p1323, @p1324, @p1325, @p1326, @p1327, @p1328, @p1329, 94), (@p1330, @p1331, @p1332, @p1333, @p1334, @p1335, @p1336, @p1337, @p1338, @p1339, @p1340, @p1341, @p1342, @p1343, 95), (@p1344, @p1345, @p1346, @p1347, @p1348, @p1349, @p1350, @p1351, @p1352, @p1353, @p1354, @p1355, @p1356, @p1357, 96), (@p1358, @p1359, @p1360, @p1361, @p1362, @p1363, @p1364, @p1365, @p1366, @p1367, @p1368, @p1369, @p1370, @p1371, 97), (@p1372, @p1373, @p1374, @p1375, @p1376, @p1377, @p1378, @p1379, @p1380, @p1381, @p1382, @p1383, @p1384, @p1385, 98), (@p1386, @p1387, @p1388, @p1389, @p1390, @p1391, @p1392, @p1393, @p1394, @p1395, @p1396, @p1397, @p1398, @p1399, 99), (@p1400, @p1401, @p1402, @p1403, @p1404, @p1405, @p1406, @p1407, @p1408, @p1409, @p1410, @p1411, @p1412, @p1413, 100), (@p1414, @p1415, @p1416, @p1417, @p1418, @p1419, @p1420, @p1421, @p1422, @p1423, @p1424, @p1425, @p1426, @p1427, 101), (@p1428, @p1429, @p1430, @p1431, @p1432, @p1433, @p1434, @p1435, @p1436, @p1437, @p1438, @p1439, @p1440, @p1441, 102), (@p1442, @p1443, @p1444, @p1445, @p1446, @p1447, @p1448, @p1449, @p1450, @p1451, @p1452, @p1453, @p1454, @p1455, 103), (@p1456, @p1457, @p1458, @p1459, @p1460, @p1461, @p1462, @p1463, @p1464, @p1465, @p1466, @p1467, @p1468, @p1469, 104), (@p1470, @p1471, @p1472, @p1473, @p1474, @p1475, @p1476, @p1477, @p1478, @p1479, @p1480, @p1481, @p1482, @p1483, 105), (@p1484, @p1485, @p1486, @p1487, @p1488, @p1489, @p1490, @p1491, @p1492, @p1493, @p1494, @p1495, @p1496, @p1497, 106), (@p1498, @p1499, @p1500, @p1501, @p1502, @p1503, @p1504, @p1505, @p1506, @p1507, @p1508, @p1509, @p1510, @p1511, 107), (@p1512, @p1513, @p1514, @p1515, @p1516, @p1517, @p1518, @p1519, @p1520, @p1521, @p1522, @p1523, @p1524, @p1525, 108), (@p1526, @p1527, @p1528, @p1529, @p1530, @p1531, @p1532, @p1533, @p1534, @p1535, @p1536, @p1537, @p1538, @p1539, 109), (@p1540, @p1541, @p1542, @p1543, @p1544, @p1545, @p1546, @p1547, @p1548, @p1549, @p1550, @p1551, @p1552, @p1553, 110), (@p1554, @p1555, @p1556, @p1557, @p1558, @p1559, @p1560, @p1561, @p1562, @p1563, @p1564, @p1565, @p1566, @p1567, 111), (@p1568, @p1569, @p1570, @p1571, @p1572, @p1573, @p1574, @p1575, @p1576, @p1577, @p1578, @p1579, @p1580, @p1581, 112), (@p1582, @p1583, @p1584, @p1585, @p1586, @p1587, @p1588, @p1589, @p1590, @p1591, @p1592, @p1593, @p1594, @p1595, 113), (@p1596, @p1597, @p1598, @p1599, @p1600, @p1601, @p1602, @p1603, @p1604, @p1605, @p1606, @p1607, @p1608, @p1609, 114), (@p1610, @p1611, @p1612, @p1613, @p1614, @p1615, @p1616, @p1617, @p1618, @p1619, @p1620, @p1621, @p1622, @p1623, 115), (@p1624, @p1625, @p1626, @p1627, @p1628, @p1629, @p1630, @p1631, @p1632, @p1633, @p1634, @p1635, @p1636, @p1637, 116), (@p1638, @p1639, @p1640, @p1641, @p1642, @p1643, @p1644, @p1645, @p1646, @p1647, @p1648, @p1649, @p1650, @p1651, 117), (@p1652, @p1653, @p1654, @p1655, @p1656, @p1657, @p1658, @p1659, @p1660, @p1661, @p1662, @p1663, @p1664, @p1665, 118), (@p1666, @p1667, @p1668, @p1669, @p1670, @p1671, @p1672, @p1673, @p1674, @p1675, @p1676, @p1677, @p1678, @p1679, 119), (@p1680, @p1681, @p1682, @p1683, @p1684, @p1685, @p1686, @p1687, @p1688, @p1689, @p1690, @p1691, @p1692, @p1693, 120), (@p1694, @p1695, @p1696, @p1697, @p1698, @p1699, @p1700, @p1701, @p1702, @p1703, @p1704, @p1705, @p1706, @p1707, 121), (@p1708, @p1709, @p1710, @p1711, @p1712, @p1713, @p1714, @p1715, @p1716, @p1717, @p1718, @p1719, @p1720, @p1721, 122), (@p1722, @p1723, @p1724, @p1725, @p1726, @p1727, @p1728, @p1729, @p1730, @p1731, @p1732, @p1733, @p1734, @p1735, 123), (@p1736, @p1737, @p1738, @p1739, @p1740, @p1741, @p1742, @p1743, @p1744, @p1745, @p1746, @p1747, @p1748, @p1749, 124), (@p1750, @p1751, @p1752, @p1753, @p1754, @p1755, @p1756, @p1757, @p1758, @p1759, @p1760, @p1761, @p1762, @p1763, 125), (@p1764, @p1765, @p1766, @p1767, @p1768, @p1769, @p1770, @p1771, @p1772, @p1773, @p1774, @p1775, @p1776, @p1777, 126), (@p1778, @p1779, @p1780, @p1781, @p1782, @p1783, @p1784, @p1785, @p1786, @p1787, @p1788, @p1789, @p1790, @p1791, 127), (@p1792, @p1793, @p1794, @p1795, @p1796, @p1797, @p1798, @p1799, @p1800, @p1801, @p1802, @p1803, @p1804, @p1805, 128), (@p1806, @p1807, @p1808, @p1809, @p1810, @p1811, @p1812, @p1813, @p1814, @p1815, @p1816, @p1817, @p1818, @p1819, 129), (@p1820, @p1821, @p1822, @p1823, @p1824, @p1825, @p1826, @p1827, @p1828, @p1829, @p1830, @p1831, @p1832, @p1833, 130), (@p1834, @p1835, @p1836, @p1837, @p1838, @p1839, @p1840, @p1841, @p1842, @p1843, @p1844, @p1845, @p1846, @p1847, 131), (@p1848, @p1849, @p1850, @p1851, @p1852, @p1853, @p1854, @p1855, @p1856, @p1857, @p1858, @p1859, @p1860, @p1861, 132), (@p1862, @p1863, @p1864, @p1865, @p1866, @p1867, @p1868, @p1869, @p1870, @p1871, @p1872, @p1873, @p1874, @p1875, 133), (@p1876, @p1877, @p1878, @p1879, @p1880, @p1881, @p1882, @p1883, @p1884, @p1885, @p1886, @p1887, @p1888, @p1889, 134), (@p1890, @p1891, @p1892, @p1893, @p1894, @p1895, @p1896, @p1897, @p1898, @p1899, @p1900, @p1901, @p1902, @p1903, 135), (@p1904, @p1905, @p1906, @p1907, @p1908, @p1909, @p1910, @p1911, @p1912, @p1913, @p1914, @p1915, @p1916, @p1917, 136), (@p1918, @p1919, @p1920, @p1921, @p1922, @p1923, @p1924, @p1925, @p1926, @p1927, @p1928, @p1929, @p1930, @p1931, 137), (@p1932, @p1933, @p1934, @p1935, @p1936, @p1937, @p1938, @p1939, @p1940, @p1941, @p1942, @p1943, @p1944, @p1945, 138), (@p1946, @p1947, @p1948, @p1949, @p1950, @p1951, @p1952, @p1953, @p1954, @p1955, @p1956, @p1957, @p1958, @p1959, 139), (@p1960, @p1961, @p1962, @p1963, @p1964, @p1965, @p1966, @p1967, @p1968, @p1969, @p1970, @p1971, @p1972, @p1973, 140), (@p1974, @p1975, @p1976, @p1977, @p1978, @p1979, @p1980, @p1981, @p1982, @p1983, @p1984, @p1985, @p1986, @p1987, 141), (@p1988, @p1989, @p1990, @p1991, @p1992, @p1993, @p1994, @p1995, @p1996, @p1997, @p1998, @p1999, @p2000, @p2001, 142), (@p2002, @p2003, @p2004, @p2005, @p2006, @p2007, @p2008, @p2009, @p2010, @p2011, @p2012, @p2013, @p2014, @p2015, 143), (@p2016, @p2017, @p2018, @p2019, @p2020, @p2021, @p2022, @p2023, @p2024, @p2025, @p2026, @p2027, @p2028, @p2029, 144), (@p2030, @p2031, @p2032, @p2033, @p2034, @p2035, @p2036, @p2037, @p2038, @p2039, @p2040, @p2041, @p2042, @p2043, 145), (@p2044, @p2045, @p2046, @p2047, @p2048, @p2049, @p2050, @p2051, @p2052, @p2053, @p2054, @p2055, @p2056, @p2057, 146), (@p2058, @p2059, @p2060, @p2061, @p2062, @p2063, @p2064, @p2065, @p2066, @p2067, @p2068, @p2069, @p2070, @p2071, 147), (@p2072, @p2073, @p2074, @p2075, @p2076, @p2077, @p2078, @p2079, @p2080, @p2081, @p2082, @p2083, @p2084, @p2085, 148)) AS i ([Column1], [FailingColumnFKID], [DateColumn], [Column2], [Column3], [IsDeleted], [Column4], [NonProblemColumnFKID], [Column5], [UniqueID], [GeographyPointBytes], [Column5], [AnotherDateColumn], [Column6], _GeographyPointBytes) ON 1=0 WHEN NOT MATCHED THEN INSERT ([Column1], [FailingColumnFKID], [DateColumn], [Column2], [Column3], [IsDeleted], [Column4], [NonProblemColumnFKID], [Column5], [UniqueID], [GeographyPointBytes], [Column5], [AnotherDateColumn], [Column6]) VALUES (i.[Column1], i.[FailingColumnFKID], i.[DateColumn], i.[Column2], i.[Column3], i.[IsDeleted], i.[Column4], i.[NonProblemColumnFKID], i.[Column5], i.[UniqueID], i.[GeographyPointBytes], i.[Column5], i.[AnotherDateColumn], i.[Column6]) OUTPUT INSERTED.[PrimaryKeyID], i._GeographyPointBytes INTO @inserted0; SELECT [t].[PrimaryKeyID] FROM [TableToInsertTo] t INNER JOIN @inserted0 i ON ([t].[PrimaryKeyID] = [i].[PrimaryKeyID]) ORDER BY [i].[_GeographyPointBytes]; ```

The error message should contain the param / record id which failed the insert.

The MERGE statement conflicted with the FOREIGN KEY constraint \"FK_TableA_Table_B_Column\". The conflict occurred in database \"MyDatabase\", table \"dbo.Table\", column 'PrimaryKey'.\r\nThe statement has been terminated. (@pXXX)

API Proposal

Expose a ChangeSet or similar type with the aforementioned properties as an overload from DetectChanges which can be use instead of ChangeTracker.Entries() such as:

public class ChangeTracker{
+ Modifications();//With generic overload
+ Deletions();//With generic overload
+ Additions();//With generic overload
+ Failures();//With generic overload
}

Expected Usage

When a entity already exists I can either choose to perform a query to determine if I have the same information and if not perform an update instead.

Current Practices

Calling SaveChanges (async) etc Catching the myriad of exceptions and breaking them out into appropriate logic which is not only a performance hit but usually results in similar call paths in the common case.

Benefits

  1. Already Inserted / Deleted
  2. Row Version / Value Check Failure (Other Constraint etc)
  3. Ease of handling what to do in all cases

Risks

Low for the everything except Failures.

Memory usage associated with the extra information (could be mitigated with other switches and knobs)

Example implementation for Modifications (not optimized)

public override System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.ChangeTracking.EntityEntry> Modifications () => Entries().Where(entry => entry.State == EntityState.Modified);

The Failures could also return System.Collections.Generic.IEnumerable<Microsoft.EntityFrameworkCore.ChangeTracking.EntityEntry> just thinking about if the same thing will arise where I only want to handle update failures or handle them differently (possibly based on type) etc, so a ChangeSet with these properties which would be propagated back to the user based on the other switches and knobs seems like how it should be done.

In the end the user should say per ChangeSet if inserts should happen before updates or deletes etc as well as how to handle failures very easily.

What is a ChangeSet

It is a class which determines all of the data within a 'Snapshot' and how it will be processed on the sever (in what order etc) It can provide information on what did not insert and why allowing you to quickly remedy It can provide a way for you to put a bunch of queries into the context and control the order of operations rather than letting the change tracker attempt to do this.

ajcvickers commented 4 years ago

@juliusfriedman We will discuss, but I doubt that we will implement anything that is designed to recover from database constraint violations. We generally follow the philosophy that a constraint exception indicates an application error, rather than a recoverable state.

juliusfriedman commented 4 years ago

Yea so would I but the problem is checking the failing SQL there is no violation and the message is bogus. I am still looking into it btw.

Keep in mind, especially with cloud... I may have multiple writers and I should be able to gracefully fail / sync. and Yes I know that is what database replication is for.

The concept is powerful on it's own e.g. just for the order of operations without the Failures but I would highly suggest for their allowance.

I have verified that a BulkCopy with almost the same exact SQL is NOT failing the only difference I see is the MERGE vs the BULK which unfortunately indicates a bug in EF 3.1.5.

ajcvickers commented 4 years ago

We discussed this as a team and agreed that this is not something we want to support in EF Core.

juliusfriedman commented 4 years ago

Can you please take a few moments to review the failing SQL and give your opinion as to why it would fail and a BulkCopy would not?

Thank you again for your time!

ajcvickers commented 4 years ago

@juliusfriedman For that, please attach a small, runnable project or post a small, runnable code listing that reproduces what you are seeing so that we can investigate.

AndriySvyryd commented 4 years ago

Note that after https://github.com/dotnet/efcore/issues/7829 is fixed DbUpdateException.Entries will contain the entries that caused the error.

juliusfriedman commented 4 years ago

Note that after #7829 is fixed DbUpdateException.Entries will contain the entries that caused the error.

Dear sir

I have code similar to the following:


catch(DbUpdateException dbex)
                            {
                                foreach(var e in dbex.Entries)
                                {
                                    if(e.Entity is Something s)
                                    {
                                        Trace.WriteLine($"Someting ({s.ID}) Failed Insert for some reason");
                                    }
                                    else if (e.Entity is SomethingElse se)
                                    {
                                        Trace.WriteLine($"SomethingElse ({se.ID}) Failed Insert for some reason");
                                    }
                                    else
                                    {
                                        Trace.WriteLine($"Something other thing Failed Insert for some reason..");
                                    }
                                }
                            }

I was wondering simply now that I have this ability to determine which entities failed, how can I remove them from the Snapshot which has already been attempted by SaveChanges. E.g. Detach the entity such that I can proceed with the rest of the records which are not failing?

Thank you for your time!

AndriySvyryd commented 4 years ago

I was wondering simply now that I have this ability to determine which entities failed, how can I remove them from the Snapshot which has already been attempted by SaveChanges.

e.State = EntityState.Detached;