Convert Linq Query Result to Dictionary

Question

I want to add some rows to a database using Linq to SQL  but I want to make a  custom check  before adding the rows to know if I must add  replace or ignore the incomming rows  I d like to keep the trafic between the client and the DB server as low as possible and minimize the number of queries   To do this  I want to fetch as little information as required for the validation  and only once at the beginning of the process   I was thinking of doing something like this  but obviously  it doesn t work  Anyone have an idea   Dictionary lt int  DateTime gt  existingItems         from ObjType ot in TableObj         select  new KeyValuePair lt int  DateTime gt  ot Key  ot TimeStamp           What I d like to have at the end would be a Dictionary  without having to download the whole ObjectType objects from TableObject   I also considered the following code  but I was trying to find a proper way   List lt int gt  keys    from ObjType ot in TableObj orderby ot Key select ot Key  ToList lt int gt     List lt DateTime gt  values    from ObjType ot in TableObj orderby ot Key select ot Value  ToList lt int gt     Dictionary lt int  DateTime gt  existingItems   new Dictionary lt int  DateTime gt  keys Count   for  int i   0  i  lt  keys Count  i          existingItems Add keys i   values i

User · Accepted Answer

Try using the ToDictionary method like so  var dict   TableObj ToDictionary  t   gt  t Key  t   gt  t TimeStamp

User · Answer

Try the following  Dictionary lt int  DateTime gt  existingItems         from ObjType ot in TableObj  ToDictionary x   gt  x Key     Or the fully fledged type inferenced version   var existingItems   TableObj ToDictionary x   gt  x Key

User · Answer

Use namespace  using System Collections Specialized    Make instance of DataContext Class  LinqToSqlDataContext dc   new LinqToSqlDataContext      Use  OrderedDictionary dict   dc TableName ToDictionary d   gt  d key  d   gt  d value     In order to retrieve the values use namespace     using System Collections   ICollection keyCollections   dict Keys  ICOllection valueCollections   dict Values   String   myKeys   new String dict Count   String   myValues   new String dict Count    keyCollections CopyTo myKeys 0   valueCollections CopyTo myValues 0    for int i 0  i lt dict Count  i      Console WriteLine  Key      myKeys i     Value      myValues i      Console ReadKey

User · Answer

Looking at your example  I think this is what you want   var dict   TableObj ToDictionary t   gt  t Key  t  gt  t TimeStamp

[c#] Convert Linq Query Result to Dictionary

Examples related to c#

Examples related to linq

Examples related to linq-to-sql

Examples related to todictionary