nescafe
About
- Username
- nescafe
- Joined
- Visits
- 6,214
- Last Active
- Roles
- Member
- Points
- 120
- Badges
- 11
Comments
-
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 …
-
Paid version has intellisense, which is much more helpful than documentation (imo)
-
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).
-
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…
-
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?
-
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…
-
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
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Badges
