Taken from this post at linqpad In the GUI go to edit -> preferences -> results . At the bottom you will see “In Rich Text Mode” as well as “In DataGrid Mode”. The rich text mode works on the .Dump() in the editor, or automating a .linq query using .Dump()
LINQPad doesn’t work in Mono primarily because it relies on ActiPro’s SyntaxEditor which does some Win32 interop. LINQPad itself also does some interop. An early prototype of LINQPad used a TextBox instead of a syntax editor – this might be what was tested against Mono.
I know this is an old question, but if anyone else lands here using EF Code First as I am, my issue was in the fluent mappings: protected override void OnModelCreating(DbModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); modelBuilder.Entity<Parent>() .HasOptional(a => a.Child) /* LEFT OUTER JOIN */ .WithMany() .HasForeignKey(a => a.ChildId); } is translated as a LEFT OUTER JOIN … Read more
If you call Debugger.Launch(); Debugger.Break(); to initiate the breakpoint within your LINQPad script, LINQPad will guess that you want to use VS to debug your script and won’t delete the .cs file.
I figured it out, thanks for the suggestions anyway. The solution is to do this (2nd attempt in my question): var qry = (from a in Actions join u in Users on a.UserId equals u.UserId select a).Include(“User”) The reason intellisense didn’t show Include after the query was because I needed the following using: using System.Data.Entity; … Read more
I’ve just uploaded a new beta that allows this to work. Add the following attribute to the libraries whose internals you want LINQPad to access: [assembly: InternalsVisibleTo(“LINQPadQuery”)] You’ll also need to enable this feature in LINQPad’s preferences (Edit | Preferences | Advanced). Let me know how you get along.
Update: it’s now possible to do cross-database SQL Server queries in LINQPad (from LINQPad v4.31, with a LINQPad Premium license). To use this feature, hold down the Control key while dragging databases from the Schema Explorer to the query window. It’s also possible to query linked servers (that you’ve linked by calling sp_add_linkedserver). To do … Read more
I’ve just added a feature to address this. You can test it now by downloading the 2.27.1 or 4.27.1 beta build. To get the current query’s folder, use the following expression: Path.GetDirectoryName (Util.CurrentQueryPath)
JPad – A java scratchpad for running snippets Since I also couldn’t find one I’ve decided to write one. Currently it can: Run java snippets (no class / imports / public blah… needed). Contains drivers for MS/MySQL/Postgres. Output results as HTML tables It’s very rough but I will add to it over time. Feedback is … Read more
Change Language in LINQPad to “C# Program” and use the following code void Main() { var p1 = Person.Single(x => x.Id == 1); p1.Name = “Test”; SubmitChanges(); }