Tagged Questions
1
vote
3answers
28 views
How to split a row into many equals rows by a value in a column?
There is any way to dismember a row into many rows by a value into row column?
Doing my query, i got the result:
ID TmpShoppingCart_ID StoreSKU_ID QuantityΞΞ Enabled
26 34 448 ...
0
votes
0answers
80 views
Entity Framework LINQ joining 5 tables on multiple columns (impossible?!)
Please see image:
I am trying to create a LINQ query that combines 5 different tables on 1 to 3 different columns. I am basically taking the examples of 2 tables and repeating the join sections for ...
0
votes
1answer
66 views
Reuse the linq table class when selecting from view
I have an sql server table linked to class via the linq attribute:
[Table(Name = "MyItems")]
public class MyItems
{
...
}
Table<MyItems> linqMyItems = db.GetTable<MyItems>();
...
0
votes
1answer
36 views
Selecting linq class from a sql object query
Learning the LINQ, trying to grasp the paradigm...
I have set up a LINQ table class for one of the core business objects. I'd like to retrieve a list of these objects from the database, using MS SQL ...
0
votes
1answer
37 views
SQL Query much slower from Linq than directly from management Studio
I'm experiencing a very strange performance issue when executing a query through C# Linq to SQL. Usually the query takes a second or two to execute, but for some very specific search criteria the ...
0
votes
1answer
58 views
Get data from a dynamic query using a DataSet in c#
I'm having a couple of days with a dynamic query that doesn't bring me data to show in a report. What I have done is to make a code that helps me build a dynamic query using the parameters that I get ...
1
vote
1answer
39 views
How to save Video in SQL Server and display in listview and play it in video player on asp.net C#
I am developing a asp.net project and want to do do task done asps here is a problem
i want to save a video in SQL Server table and also play that video in web player
how can i save a video in MS ...
0
votes
1answer
89 views
Saving Items from Listbox to SQL Server table using LINQ
I have the following Item(s) A (string) and Item(s) B (decimal) In my WPF ListBox. I intend to
to save them to a table in MS SQL database with the respective data type.
...
0
votes
4answers
88 views
SQL search between commas
I am working on a requirement to search for words that appear only between two commas within a string.
So for example, in my database, I have the following data:
...
2
votes
2answers
69 views
Selecting Usernames Uniquely
Suppose that I have a table with a column labeled Name, which contains (possibly) repeating entries of unique usernames. What LINQ-to-SQL statement can I write to uniquely traverse the usernames? In ...
0
votes
2answers
37 views
Convert SQL to LINQ to Entities WHERE IN clause
How can I convert this sql statetment to LINQ to Entities?
SQL Statement:
Select * from Departments where DepartmentID in (Select DepartmentID from Employees where FirstName like '%FirstName%' or ...
1
vote
1answer
44 views
Linq Data Source WhereParameters with “\” in value
ASP.NET/C# project utilizing LinQ to SQL
I have listbox, with values from database, which is used to filter Linq Data Source.
Everything works fine until I have value in the listbox that contain "\". ...
0
votes
2answers
64 views
linq check if matches null or selected item
I am checking to see if items already match whats in my MSSQL DB. I am using LINQ to update records. I would like to know how i can check if an item is equal to d_0_2 or if its equal to null/empty. ...
0
votes
0answers
29 views
Calling SQL Server Sproc from LINQ does not execute whole query
This seems related to this issue, which does not have an answer:
LINQ: executing stored procedure, but skipping cursor within
I have a stored procedure in SQL Server that runs correctly every time ...
0
votes
1answer
44 views
Why is Linq query setting my Arithabort options to false?
I have code like this:
using (var db = new MyDataContext()) {
db.ExecuteStoreCommand("Set Arithabort on");
var q = AFairlyComplexQuery(db); // returns an IQueryable<>
var result = ...
