Is there anyone reading this that has experience of netcore-System.Data.Linq? We are about to embark on a very large code-base migration from Framework 4.8 to .NET8. We have relied on Linq2Sql for all ...

I installed LINQ-to-SQL in version 7.9, then noticed it didn't show up when I tried to use it. After doing some research, someone said to update visual studio to the latest, so I did that. I confirmed ...

In a project that uses Linq2Sql I have the following tables: +-------------+ +-------------+ | Orders | | OrdItems | +-------------+ +-------------+ +------------...

Currently I fetch all customers that have registered exactly 2 years before a given date. var observationPeriod = DateTime.Today; var observedDate = observationPeriod.AddYears(-2); var customers = ...

Whenever I update my DBML (to include a new view/table), after the DBML auto-generates to included the new table/view, an untouched/unedited stored procedure is altered in the designer.cs file. The ...

I need to find all descendants for a given list of parents. The query (in plain SQL) was easy enough, but I can't translate it into LINQ-to-SQL. SQL Query: select child.id from ...

UPDATE: This code is used in a server side data export process, so no UI that necessitates paging/chunking and I simply need to 'plow' through (up to) 100's of thousands of rows of data. I'm migrating ...

I was trying to insert more than 20,000 records data in database using LINQ. Almost everything is fine until the line of SubmitChanges. It slows down my application. I tried commenting the ...

Is anyone aware of the reason why publishing a WPF application with ClickOnce would result in a "Specified cast is not valid." error? When attempting to open the design window for Linq to ...

I have the following straightforward case where a client communicates with .NET Web API: Client makes a request for an object to the Web API giving the requested ID. Web API returns the object to the ...

I have the following table entity with my sql-database : using System.Data.Linq.Mapping; [Table(Name = "Users")] class Users { [Column(Name="UserKey", IsPrimaryKey=true)] ...

I'm attempting to update a value in my Database, but the IsReadOnly property is always coming back as True. According to Microsoft, that property Gets a value that indicates whether the type of the ...

I am using .Net 4.8 Framework and System.Data.Linq package. I am trying to Map data from database to object (Child). ChildClass inherits ParentClass, so in my thought it should be able to use ...

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System....

I use ExecuteCommand in data context in linq to pass update command like this _context.ExecuteCommand("update tb_ExpList set exp_name = '" & TextBox8.Text & "',exp_desc = '"...