1182 results found
-
Recognize type when exporting to excel
Currently when you have a dataset and you export it to excel, it works great except for field types. Excel likes to assume what data type is in each cell, and in cases where there are string values with padded zeros (e.g. 0012345) excel thinks it's a number and drops the padding.
Is there any way you can apply column formatting (even the most primitive like Double=>Number, String=>Text, Decimal=>Money, etc.)? This would preserve data during the transition to excel making the export a true 1:1.
14 votes -
Error with SQL Server database in Visual Studio after using LINQPad
I have an SQL Server database which is being used for a MVC 4 project in VS 2010. I'm using LINQPad to run queries against my database. When I open LINQPad, I can connect to my .mdf database file and run queries as expected. When I close LINQPad, open up VS and try to view my database in server explorer the following error is shown:
"The database 'C:..... .MDF' cannot be opened because it is version 706. This server supports version 655 and earlier. A downgrade path is not supported. Could not open new database 'C:..... .MDF'. CREATE DATABASE is…
1 vote -
Progressive Dump
While a linq query is going on, I would like to dump the values, but part of the same Dump... if that makes sense. I use LINQPad to handle small menial tasks I don't feel like starting a new VS project for.
So while I am in a long linq query, I would like another method for DumpToExisting([id]) and Dump() should return a GUID or Integer id.
6 votes -
HTML Browser/Editor
A HTML Browser/Editor will be welcome to make simple pages for documentation and other funcionality...
Show page in full query window in browser mode and supply a button to enter edit mode (top pane for visual edit/dump pane for html edit)... a direct HTML edit mode can be edited in lower pane (Dump panel)...1 vote -
encoding
To Allow set text encoding for result. Now LinqPad can get result , but it is unreadable to me since what I have in result is not English. Thanks!
10 votes -
Allow the LINQ expression tree to be modified before executing the query. I
Allow the LINQ expression tree to be modified before executing the query. I do this in my app so we can write our queries without having to worry about making them multi-tenant. But when I pop the query from our source code into LINQPad, I have to manually edit the query to make it multi-tenant. Would be great if we could hook in a custom ExpressionVisitor.
1 vote -
Generate POCO classes from right click on tables
It would be handy if LINQPad could assist in quickly generate POCO classes for a table
14 votes -
Find and replace dialog should not be modal
A few issues with a modal dialog:
If one wishes to undo a replace operation they must close the dialog, undo, then reopen it.
If the user has the cursor in an undesirable position for starting a search, they must close the dialog, correct it, then reopen.
26 votes -
Map char(1) to string, as sqlmetal does
When I generate a DataContext through sqlmetal, it converts all char fields to strings. Not what I'd expect it to do, but not a bad idea.
When I generate my entities through LinqPad, char fields are left as char, making my sqlmetal generated code incompatible with LinqPad.Just as there are options on pluralizing and capitalisation, It would be useful to have a "convert char to string" option as well.
9 votes -
Add feature that allows exported Excel data from a SQL database to be refreshed as the SQL database is updated with new data.
Add feature that allows exported Excel data from a SQL database to be refreshed as the SQL database is updated with new data
1 vote -
Allow the selection of a default top-level schema in the tree view
The connection tree view currently defaults to using dbo as the top level schema to display. For databases that have other schemas, you have to scroll down and expand them. For some databases this is a pain, because the schema that I work in isn't dbo. It would be useful to be able to define a default schema for each connection.
3 votes -
Bug: "Export to CSV file" should write BOM to work correctly with Excel
When viewing data in the grid and using the "Export to CSV file", the resulting file doesn’t have a BOM (byte order mark), and so when you double-click the CSV file, Excel opens up and (at least in Excel 2010) shows the following dialog box:
The file you are trying to open, 'MyData.csv', is in a different format than specified by the file extension. Verify that the file is not corrupt and is from a trusted source before opening the file. Do you want to open the file now?
If you click 'Yes', another dialog box is displayed:
Excel has…
1 vote -
SQL table direct editing: Leave mode, and ask before saving row changes
I like the ease of directly editing SQL tables in the premium edition. However, it's a little too "eager" to save for my taste. I'd like to suggest a couple related changes to make it safer for a klutz like me to use without accidentally nuking things:
1) LP has the new "Edit" button, but not an "End Editing" button.
2) When clicking between rows, any changes to the row being "blurred" (moved away from) are automatically saved. It seems like it should be asking first, at least once.Combined, these two things would make it much safer.
4 votes -
Auto-Dump() the last statement in multi-statement queries
When writing multi-statements I keep rerunning what I wrote to see if I am on track. However, to actually see what is the result/response/value of the last thing I wrote, I keep adding ".Dump()" to last item, and then remove it and continue to the next statement.
I think LinqPad should automatically dump the last statement (as an option). Moreover, it might be nice to be also configured something like "Only auto-dump if nothing else is dumped in the query".
3 votes -
remote desktop for Linqpad - execute linq queries on a remote machine
I'd like to be able to have linqpad running on my app and sql servers and be able to securely execute my linqpad script on a remote machine, e.g. on sql server 1, or my hosting server (x), I'd run linqpad as a service, on my dev machine, I'd I want to be able to write a query and test it on my dev, box, then when I'm happy with it, I want to run it securely agains the remote box, and this is the critical part, so that the queries all run (locally) on the remote box without the…
11 votes -
Leave the time it took for the query to complete after completion.
When the query is running there is a counter but after it completes the counter goes away, can you leave it up?
1 vote -
Generate method on the fly
While in "C# Program" mode it would be cool to generate the method stub just like in Visual Studio .. it could be done in 2 ways:
use mouseclick or similar to activate the function
generate the method on the fly while writing (detect when unknown methodname is written when starting/closing a paran/bracket)
1 vote -
Query Properties Profiles
Query Properties - Profiles
Set and save different Profiles for query properties. We have different code branches for development and release cycles. It would be great if I could setup and switch between different profiles for a LINQ script.
4 votes -
Enhancement of autcomplete on subqueries
When writing for example:
from u in Users
select new
{
UserDetails = (from ud in ....
}When I press "u" I would expect u as the alias for Users in the outer query, but it picks up everything.
4 votes -
Add support for f# type providers
F# 3.0 type providers seem like they would fit in quite well with the LINQPad-as-data-explorer mission.
119 votes
- Don't see your idea?