Tag Archives: Linq-to-SQL

Language Integrated Query (LINQ, pronounced “link”) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript. LINQ extends the language by so-called query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third party data sources. Other uses, which utilize query expressions as a general framework for readably composing arbitrary computations, include the construction of event handlers or monadic parsers. LINQ also defines a set of method names (called standard query operators, or standard sequence operators), along with translation rules used by the compiler to translate query expressions into expressions using these method names, lambda expressions and anonymous types.

How to get random row in linqtosql?

  By Gaurav Agrawal | July 29, 2012 - 12:44 PM |
Leave a comment

Create a view in SQL server for take a random record CREATE VIEW RandomView AS SELECT NEWID() As ID Then create a functin in SQL server CREATE FUNCTION GetNewId ( ) RETURNS uniqueidentifier AS BEGIN RETURN (SELECT ID FROM RandomView) END The view is required because it’s not possible to directly use NEWID in a scalar function. You can then map the GetNewId user-defined function using LINQ to SQL’s Function attribute. Again, see chapter 8 for the details. That’s it! You can now write LINQ queries as usual. Here is an example to pick a random object: var tool = … Click here to continue reading. →