nescafe
About
- Username
- nescafe
- Joined
- Visits
- 5,884
- Last Active
- Roles
- Member
- Points
- 112
- Badges
- 10
Comments
-
Perhaps you are calling async methods without awaiting them? Could you share the code you are using?
-
You can provide parameters as additional arguments: ExecuteStoredProcedure("dbo.p_selectItemsWithPathByLang", "cs")
-
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…
-
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…
-
Can you run a SQL Profiler while building datacontext and compare the output of these queries with the actual database schema?
-
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")…
-
UserQuery is derived from the TypedDataContext class, therefore the data context must be created before the actual query can be compiled.
-
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 ( …
-
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…
-
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 …
-
Thanks for showing *actual* extensions methods
-
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 …
-
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 …
-
Probably some Internet Explorer protection. You can use Hyperlinq to bypass this limitation: new Hyperlinq(path, "link").Dump(path);
-
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…
-
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…
-
Please clarify what isn't working for you and what you expected to get.
-
Not a solution.. but you could use http://converter.telerik.com/ to convert VB.NET to C# code. It's not perfect but works well.
-
You could blacklist www.linqpad.net on your DNS server. Share Query will fail (could not resolve 'www.linqpad.net') and not complete.
-
You can do it up to 6 times per year.
-
This is by-design. As you set the current directory to the newly created directory, it will be 'locked' and cannot be deleted. An equivalent in a command line window would be: C:\>md Test C:\>rd Test C:\>md Test C:\>cd Test C:\Test&…
-
You can do a style sheet customization via Edit, Preferences, Stylesheet: Custom, Launch Editor: body { font-family: Consolas; } Note that the result panel is a richt text window and not a console. If you want to run console applications, you…
-
There is.. Use Enumerable.AsEnumerable() to convert your LINQ-to-SQL IQueryable expression to an LINQ-to-objects IEnumerable sequence and then apply Enumerable.Select() with Int32 to incorporate the index: Domains .Include(x => x.ApiData).OrderB…
-
http://imgur.com/a/1aHY1
-
Issue has been fixed on my system as well with latest beta. (Different screen sizes, different DPI's, both 100% scaling)
-
Another repro: (Not related to main monitor since it occurs on both primary and secondary screen) - Run "A simple query expression" in data grid mode - Maximize/restore window a few times (hotkey: Win+Up, Win+Down, maybe 10 times) I think bot…
-
Probably WCF OData related. Try using navigation properties if they exist or .AsEnumerable() to retrieve data sets separately and do the join locally. The latter will result in a lot more requests, more data being transferred and potentially lack …
-
Yep, look here: http://docs.aws.amazon.com/general/latest/gr/rande.html#ddb_region
-
The example runs fine here (w/ bogus key and secret). Is the local DynamoDB instance running? Downloaded and extracted dynamodb_local_latest.zip from http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBLocal.html Started Dynam…
-
There is no autocompletion for sql, unfortunately. https://www.linqpad.net/Purchase.aspx Full C#/F#/VB autocompletion and tooltips (no SQL) Vote for the suggestion here: https://linqpad.uservoice.com/forums/18302-linqpad-feature-suggestions/sug…
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Badges
