SyntaxFix

[sql] How can I do SELECT UNIQUE with LINQ?

The Distinct() is going to mess up the ordering, so you'll have to the sorting after that.

var uniqueColors = 
               (from dbo in database.MainTable 
                 where dbo.Property == true 
                 select dbo.Color.Name).Distinct().OrderBy(name=>name);

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to visual-studio

• VS 2017 Git Local Commit DB.lock error on every commit • How to remove an unpushed outgoing commit in Visual Studio? • How to download Visual Studio Community Edition 2015 (not 2017) • Cannot open include file: 'stdio.h' - Visual Studio Community 2017 - C++ Error • How to fix the error "Windows SDK version 8.1" was not found? • Visual Studio Code pylint: Unable to import 'protorpc' • Open the terminal in visual studio? • Is Visual Studio Community a 30 day trial? • How can I run NUnit tests in Visual Studio 2017? • Visual Studio 2017: Display method references

Examples related to linq

• Async await in linq select • How to resolve Value cannot be null. Parameter name: source in linq? • What does Include() do in LINQ? • Selecting multiple columns with linq query and lambda expression • System.Collections.Generic.List does not contain a definition for 'Select' • lambda expression join multiple tables with select and where clause • LINQ select one field from list of DTO objects to array • The model backing the 'ApplicationDbContext' context has changed since the database was created • Check if two lists are equal • Why is this error, 'Sequence contains no elements', happening?

Examples related to select

• Warning: Use the 'defaultValue' or 'value' props on <select> instead of setting 'selected' on <option> • SQL query to check if a name begins and ends with a vowel • Angular2 *ngFor in select list, set active based on string from object • SQL: Two select statements in one query • How to get selected value of a dropdown menu in ReactJS • DATEDIFF function in Oracle • How to filter an array of objects based on values in an inner array with jq? • Select unique values with 'select' function in 'dplyr' library • how to set select element as readonly ('disabled' doesnt pass select value on server) • Trying to use INNER JOIN and GROUP BY SQL with SUM Function, Not Working

Examples related to unique

• Count unique values with pandas per groups • Find the unique values in a column and then sort them • How can I check if the array of objects have duplicate property values? • Firebase: how to generate a unique numeric ID for key? • pandas unique values multiple columns • Select unique values with 'select' function in 'dplyr' library • Generate 'n' unique random numbers within a range • SQL - select distinct only on one column • Can I use VARCHAR as the PRIMARY KEY? • Count unique values in a column in Excel