Stack Overflow
Stack Overflow

Questions tagged [linqpad]

A lightweight code scratchpad for C#/F#/VB and database querying tool that supports both SQL and LINQ. Written by Joe Albahari.

LINQPad can be downloaded free from http://www.linqpad.net. Its main features are:

  • Runs code snippets in C#, VB.NET and F#, for .NET 3.5, 4.0, 4.5 and 4.6.
  • Executes queries on databases and other sources directly in LINQ (or SQL).
  • Explicit support for popular APIs such as LINQ-to-SQL, Entity Framework and OData, and databases such as SQL/Azure, SQLite, MySQL, Oracle and PostgreSQL.
  • Allows referencing custom assemblies and NuGet packages.
  • Built-in "object dumper" to facilitate easy experimentation. Recognizes and specially formats output from popular APIs such as Reactive Extensions.
  • Command-line support for automating scripts.
  • Built-in autocompletion and debugging (license purchase required).

LINQPad is popular for testing C# snippets. It also has built-in samples to help with learning LINQ.

Another program similiar to linqpad is You even can query stackoverflow using linqpad

1017 questions
-1
votes
1 answer

Linqpad data transfer from entity objects to database

Using LinqPad I have mapped XML to database entities, entities provided by LinqPad. After mapping all the data, I now have over 5 million entities in memory. I am transferring 1000 entities at a time via batch insert (InsertAllOnSubmit). But its…
Null Head
  • 2,877
  • 13
  • 61
  • 83
-1
votes
1 answer

Linq Where() func with multple filters. Results wrong result

I am tring to put multple condition in where clause but not getting result as exprected. what i am doing. in (LinqPad) void Main() { var lst = new List() { new Employee() { Name="Name1", Address="address1",Desig="Desig1"}, …
JSJ
  • 5,653
  • 3
  • 25
  • 32
-1
votes
1 answer

How can i use join in LinqPad against SE DE?

i use StackExchange Data Explorer service with LinqPad and i use this Code for Select all of User: from m in Users select m now i want select all Posts of User from u in Users join p in Posts on u.Id equals p.OwnerUserId select u but it's not…
Sirwan Afifi
  • 10,654
  • 14
  • 63
  • 110
-1
votes
1 answer

Can I provide a custom icon for my custom LINQPad data context driver?

I recently started writing LINQPad data context drivers for accessing various types of systems. Unfortunately every driver I write, uses the same "cog wheel" icon. This makes it harder to discern their type than if they'd have a type-specific…
Frank van Puffelen
  • 565,676
  • 79
  • 828
  • 807
-2
votes
1 answer

GroupBy condition with max amount needed to be added to Linq

I have been able to get a grouping based on 2 columns , but I need to group by the 3rd condition when the Amount is not greater than amount specified Here I built up test data Results in Linqpad look like this: Group PayFromBankAccountId PaymentType…
Jeremy Miller
  • 135
  • 6
-2
votes
2 answers

LinqPad conversion error

i am getting an error on DuplicateOrder(TestOrder) as "cannot convert from tables.Order to int" even though the OrderID in the Orders table is an int void DuplicateOrder(int orderId) { string methodName =…
quicklaunch2009
  • 9
  • 5
-2
votes
1 answer

LinqPad Syntax for adding foreign key constraint

This is the SQL I used in LinqPad: CREATE TABLE Category ( catID int NOT NULL, catName NVARCHAR(150) NOT NULL, catDesc NVARCHAR(150) NULL, catCount int NOT NULL , CONSTRAINT category_pk PRIMARY KEY (catID) ); CREATE TABLE…
deelliieeD
  • 7
  • 1
  • 6
-2
votes
2 answers

how to solve FileLoadException: Mixed mode assembly in linqPad

i'm new user for linqpad and when i try use it for explorer MS UCMA sdk ProvisionedApplicationPlatformSettings paps = new ProvisionedApplicationPlatformSettings("string","string"); CollaborationPlatform platform = new…
Tarek Saied
  • 6,482
  • 20
  • 67
  • 111
-3
votes
1 answer

Chart a line graph using LINQPad

LINQPad can plot the line graph using anonymous arrays. I do have JSON content with datetime (entrytime) and numerical value (cumulative gains). How can I adapt LINQPad to chart the JSON content? void Main() { // You can optionally specify a…
junkone
  • 1,427
  • 1
  • 20
  • 45
-3
votes
1 answer

Cannot access a disposed object

I have a piece of code that throws an exception and error after running for a second time. Here it is: static Form Window = new Form(); static public void Configuration() { Window.Height = 800; Window.Width = 800; Window.Text =…
A Zhitom
  • 9
  • 4
-3
votes
2 answers

Error multiple properties with the same name in LINQ query

I am working on Linq query and I am getting error on functionNavigation_b.Title column. I am using LinqPad to test my queries initially, Error An anonymous type cannot have multiple properties with the same name LINQ Query from functionNavigation…
K.Z
  • 5,201
  • 25
  • 104
  • 240
-3
votes
1 answer

How to use MultiSelectList?

I got compiling error below: Argument 2: cannot convert from 'System.Collections.Generic.IEnumerable' to 'string' Argument 3: cannot convert from 'System.Collections.Generic.IEnumerable' to 'string' How to fix this error? void Main() { …
Deep in Development
  • 497
  • 2
  • 8
  • 24
1 2 3
…
67
68