-
Re: I have been struggling with dumping a list<T> as a grid
The properties should come out in order of declaration. Which version of LINQPad are you using? What do you see when you reflect the query in ILSpy? Query: http://share.linqpad.net/dwa96k.linq (View Post) -
Re: InvalidOperationException: There is already an open DataReader associated with this Command which...
This issue is reproducible in Results to Data Grids mode. You can solve this by iterating the IEnumerable manually, to make sure each reader is executed once during execution. (View Post) -
Re: Why does this work sometime and not others?
Define "it just won't work" - is the program not responding? Is there unexpected output? Is there no output? An exception thrown? Perhaps something is cached in the application domain - you… (View Post) -
Re: Save cache when switching between connections
If you're sure that the two data models are equal, you can create another instance of the typed data context (or user query) to the staging environment. var conn1 = this;using var conn2 = new TypedDa… (View Post) -
Re: How to use FromSqlRaw, FromSqlInterpolated and ExecuteSqlRaw, ExecuteSqlInterpolated
Use the built in ExecuteQuery<T> or ExecuteQueryDynamic function Or use int ExecuteCommand(string command, params object[] parameters) if your statement does not return data. (View Post)