Skip to main content

Selecting a Single value using LINQ to SQL

TablesDataContext myDB = new TablesDataContext();

String stVar = (    from   table in myDB.DBTable
                    where        table.column1 == "…." && table.column2 == "….."
                    select        table.StringColumn).Single();

int intVar    = (    from   table in myDB.DBTable
                     where table.column == "..."
                     select table.intColumn).Single().Value;


Comments

Post a Comment

Popular posts from this blog

Problem with encoding Arabic with Google Chrome on Windows 10: Text not being displayed properly

تصحيح مشكلة قرائة اللغه العربيه على جوجل كروم If you have issue of text not being displayed properly in Chrome on Windows 10, you need to flow the steps below: In the browser address bar go to the Chrome flags settings by going to the following address: chrome://flags/#disable-direct-write. Change the "Disable DirectWrite Windows" from Enable to Disable. Click on "RELAUNCH NOW"!
Post a Comment
Read more

C# Virtual

The  virtual  keyword is used to modify a method, property, indexer, or event declaration and allow for it to be overridden in a derived class. For example, this method can be overridden by any class that inherits it. public virtual double Area() { return x * y; } When a virtual method is invoked, the run-time type of the object is checked for an overriding member. The overriding member in the most derived class is called, which might be the original member, if no derived class has overridden the member. By default, methods are non-virtual. You cannot override a non-virtual method. You cannot use the  virtual  modifier with the  static ,  abstract, private , or  override  modifiers. Click here for more info.
Post a Comment
Read more