Comments

• Oops, my bad, carry on

  in How to let try-catch works in LINQPad Comment by nescafe January 30
• Instead of using try/catch to check for existing values, which is considered bad practice (exceptions are costly), you better use headers.AllKeys.Contains("User-Agent") to check for an existing value. But, a shorter path is redefining the header. A…

  in How to let try-catch works in LINQPad Comment by nescafe January 30
• C# c => c.Name translates to VB.NET Function(c) c.Name Dim customers = { New With {.Name = "John", .TotalOrders = 100}, New With {.Name = "Mary", .TotalOrders = 130}, New With {.Name = "Sara", .TotalOrders = 140}, New With {.Name = "P…

  in Examples for charts with VB? Comment by nescafe January 19
• Try Util.ToExpando() See: https://www.linqpad.net/CustomizingDump.aspx Section "Forcing Object Expansion"

  in Force Rich HTML on XML Dump()? Comment by nescafe January 15
• This is documented in the "LINQPad Command-Line and Scripting" page. (Calling One Script From Another) https://www.linqpad.net/lprun.aspx

  in Calling a .LINQ file from another .LINQ file Comment by nescafe January 9
• You can paste the connection string in query properties, tab App.config:

  in cannot attach file (for database) when hooking up to EF context Comment by nescafe January 5
• This is because the password is encrypted and the user/machine encryption key is somehow changed after the imaging process. https://www.linqpad.net/FAQ.aspx#security If I save a connection that uses SQL Authentication, does LINQPad store the passwo…

  in Linqpad connection password NO after imaging the instance on server Comment by nescafe January 1
• I'm not really familiar with the object change tracking of LINQ-to-SQL, but you could bypass this by creating (and releasing) a data context for each record (using new TypedDataContext, var rec = Forms.FirstOrDefault(), update, dispose by end using …

  in Memory usage in 5.31 Comment by nescafe November 2018
• Paid version has intellisense, which is much more helpful than documentation (imo)

  in Able to query but not insert Comment by nescafe November 2018
• Have you looked at my (EF 6) example? You linked a LINQ-to-SQL example, but are using Entity Framework. They use different methods. My example uses EF 6 methods (Table.Add and SaveChanges). EF 5 would require AddObject and SaveChanges).

  in Able to query but not insert Comment by nescafe November 2018
• Ah, Table<> is for LINQ-to-SQL generated data context. For EF the code is a bit different. Doesn't explain why you get the 'Type could not be found' error. If it's visible in the tree view, I'd assume the type is in the current namespace. Or…

  in Able to query but not insert Comment by nescafe November 2018
• If you mouse-over the table name in the connection pane, you can see the actual name of the generated class. Is it Table? Or something else?

  in Able to query but not insert Comment by nescafe November 2018
• Could you post your data model here? Because I just tried using the following example and 'it works on my machine' - Customer has a property of type IEnumerable and CashRegister a Customer property: CREATE SCHEMA cash -- Tables CREATE TABLE db…

  in MSSQL - foreign key relation between schemas Comment by nescafe October 2018
• Perhaps you are calling async methods without awaiting them? Could you share the code you are using?

  in Not getting all records in cosmosdb when executing the linq file with lprun Comment by nescafe October 2018
• You can provide parameters as additional arguments: ExecuteStoredProcedure("dbo.p_selectItemsWithPathByLang", "cs")

  in saving result of SP Comment by nescafe October 2018
• You can utilize Util.WriteCsv for this. It accepts DataTables as well as IEnumerables. // Create a simple stored procedure (select and run): // ExecuteCommand("CREATE PROCEDURE sp_SelectTables AS SELECT * FROM sys.tables"); // After data conte…

  in saving result of SP Comment by nescafe October 2018
• I don't think these is a built in SQL Server function. Most examples show sqlcmd or powershell onelines. A LINQPad example using Util.WriteCsv() would look like: var query = @"SELECT * FROM EMPL"; Connection.Open(); using (var table = new Dat…

  in Export resutts from an SQL to a csv text file directly Comment by nescafe September 2018
• Can you run a SQL Profiler while building datacontext and compare the output of these queries with the actual database schema?

  in Wrong schema for linked server Comment by nescafe September 2018
• So you're using the connection only as a placeholder, to be re-selected at runtime? Then you could store the LINQPad script without a connection and read the connection string via reflection. var connection = this.GetType().GetProperty("Connection")…

  in lprun -compileonly connects to databases specified in Connection element Comment by nescafe September 2018
• UserQuery is derived from the TypedDataContext class, therefore the data context must be created before the actual query can be compiled.

  in lprun -compileonly connects to databases specified in Connection element Comment by nescafe September 2018
• I'm not sure there is any LINQ-to-SQL method which can be used to translate into CONVERT(). But you could use direct ExecuteQuery() methods to embed this query in your c# statements script with typed objects. CREATE TABLE MS_CUSTOMER_MASTER_GRID ( …

  in How to force convert to VARCHAR in LINQPAD? Comment by nescafe September 2018
• Not sure if this answers your question, but it may give you something to start with. Table layout: CREATE TABLE Teams ( TeamReference INT IDENTITY PRIMARY KEY NOT NULL, TeamName VARCHAR(128) NOT NULL ) CREATE TABLE Agents ( AgentRefe…

  in Statement with Joins and Aggregate Count Comment by nescafe September 2018
• How are these tables related? Is TeamReference a foreign key to Teams? Does Team has a self-reference? Do you want to count all ApplicationReferences or unique values? Is DateDeleted relevant to the selection? Any visualisation would help. What is …

  in Statement with Joins and Aggregate Count Comment by nescafe September 2018
• Thanks for showing *actual* extensions methods

  in my extensions 101 Comment by nescafe September 2018
• My Extensions: void Main() { // Write code to test your extensions here. Press F5 to compile and run. } public static class MyExtensions { // Write custom extension methods here. They will be available to all queries. public static …

  in my extensions 101 Comment by nescafe August 2018
• From http://www.linqpad.net/faq.aspx : LINQPad encrypts the password securely using the Windows Data Protection API. Not knowing the details of the Windows Data Protection API, I would simply decrypt the file on machine A to plain text and encrypt …

  in Copy .linq files to another computer Comment by nescafe August 2018
• Probably some Internet Explorer protection. You can use Hyperlinq to bypass this limitation: new Hyperlinq(path, "link").Dump(path);

  in Bug or intentionally removed? (Directory a hrefs no longer work) Comment by nescafe August 2018
• LINQPad uses LINQ to SQL, not Entity Framework. For EF, it won't work, even with 'hackish' schema. void Main() { Database.SetInitializer(null); var connectionString = "Data Source=(local);Initial Catalog=master"; var databaseContext = n…

  in How does LinqPad generate a single SQL across databases? Comment by nescafe July 2018
• Assuming LINQPad premium, you can inspect the data context by pressing Alt+Shift+R (Query, Reflect Query in ILSpy). It seems that nothing really special is going on, the additional types are declared in another class and the datacontext is passed b…

  in How does LinqPad generate a single SQL across databases? Comment by nescafe July 2018
• Please clarify what isn't working for you and what you expected to get.

  in Joining an IQueryable with an IEnumerable Comment by nescafe July 2018
More Comments