Linq to SQL: How to delete using only the primary key?
- by Jeremy
How do I delete a record using Linq to SQL using only the primary key, without having to retrieve the exsting record from the database?
Search Results
Search found 5760 results on 231 pages for 'linq to xsd'.
Page 82/231 | < Previous Page | 78 79 80 81 82 83 84 85 86 87 88 89 | Next Page >
-
-
Convert a string to Linq.Expressions or use a string as Selector?
- by VJ
Well I have a string now that has the expression value to be evaluated..it has say value "expr=expr.FieldName"... so I want to use this string as Linq.Expression or any other way to query...like Select(str). Please help me out.Read the article
-
What the linq query for SQL like and Soudex for sql server 2008?
- by KentZhou
In sql server, we can issue sql to get data like select * from table where column like '%myword%' select * from person where Soundex(LastName) = Soundex('Ann') what's the linq query to match above sql?Read the article
-
Get the count of items in a GroupBy Linq-to-sql Query?
- by Curtis White
I have a groupby that I groups all elements. I can see the items are there in LinqPad but can't find a way to get the count. Here is what I have so far: SurveyResponses.Where( q = q.QuestionId == 4).GroupBy(q = q.AnswerNumeric).Where( g = g.Key == 1) In Linq Pad I can see there are 4 items in this query. If I do Count it returns 1. I've tried, ToList().Count, Select(x = x).Count, etc.Read the article
-
LINQ Group By to project into a non-anonymous type?
- by vikp
Hi, I have the following LINQ example: var colorDistribution = from product in ctx.Products group product by product.Color into productColors select new { Color = productColors.Key, Count = productColors.Count() }; All this works and makes perfect sense. What I'm trying to achieve is to group by into a strong type instead of anonymous type. For example I have a ProductColour class and I would like to Group into a List<ProductColour> Is this possible? Thank youRead the article
-
LINQ how to add an order by to this statement?
- by JL
I have the following LINQ that I would like to also order by file creation date, how is this done? taskFiles = taskDirectory.GetFiles(Id + "*.xml") .Where(fi => !fi.Name.EndsWith("_update.xml", StringComparison.CurrentCultureIgnoreCase)) .ToArray();Read the article
-
How can I translate this SQL statement to a Linq-to-SQL approach?
- by Sergio Tapia
For example, imagine that I want to see if a user exists in my database: Select * from Users where inputID = Users.ID Then if that result brought 0 items, then the user exists, correct? How can I do something like this using a pure Linq-to-SQL class?Read the article
-
How to wrap LINQ to SQL queries in stored proc?
- by Satish
LINQ to SQL internally generates SQL queries and fire on the database after submitting changes. Is there any way we can wrap all these queries in some stored procedure and execute this store proc everytime when anything gets inserted or updated in the database. Problem is only stored procedures are allowed to carry any insert or update or delete operations, direct queries are restricted for security purpose.Read the article
-
How to use LINQ to query list of strings that do not contain substring entries from another list
- by p.campbell
string candidates = new string[] { "Luke_jedi", "Force_unknown", "Vader_jedi" , "Emperor_human", "r2d2_robot" }; string[] disregard = new string[] {"_robot", "_jedi"}; //find those that aren't jedi or robots. var nonJedi = candidates.Where(c=> c.??? //likely using EndsWith() and Any() ); How would you implement this solution using LINQ to find all those that do not end with any of the disregards items?Read the article
-
How do I check if a Linq to SQL entity has grandchildren?
- by EdenMachine
How can I find out if a Linq to SQL entity has grandchildren or not? Pseudo-code below: Return From p In dc.Processes Where p.Signers.Count > 0 and p.Signers.Signatures.Count > 0 Obviously I can't run the code above but I need to make sure that all the returning Processes have at least one Signer and that all of those Signers have at least one Signature. TIA!Read the article
-
How to use Linq To Sql to get Users who has less than 2 photos?
- by Mike108
The scenario is I want to get the users who has less than 2 photos. There are two table: [Users] (UserId, UserName) [UserPhotos] (PhotoId, PhotoName, UserId) UserId is a Foreign Key but I do not want to use association like user.Photos. A user may have none photo in the [UserPhotos] table. How to use Linq To Sql to get List<User> who has less than 2 photos?Read the article
-
How can I use LINQ to find the Intersect between two properties of the same collection?
- by aponzani
Given an IList<Foo> with a data set that looks like this: ID CHILD PARENT TYPE 1 102 101 UPSELL 1 103 101 UPSELL 2 102 101 BONUS 2 104 103 BONUS 3 102 101 BONUS 4 102 101 PRODUCT 4 104 102 PRODUCT How can I use LINQ to find the intersection of Parent and Child values withing each ID? Desired output is ID CHILD PARENT TYPE 4 102 101 PRODUCTRead the article
-
How do I use "Into" LINQ expression in VB.NET?
- by SLC
I'm converting from C# this LINQ expression. However, it does not seem to work. C# return (from w in fishSticks group w by w.FishQty into g orderby g.Key descending select g).First().First(); VB Return (From w In fishSticks Group w By w.FishQty Into g() Order By g.Key Descending Select g).First().First() Visual Studio turns g into g() itself and then gives me this error: Definition of method 'g' is not accessible in this context. Any ideas?Read the article
-
How to convert this SQL query to Linq to Entity query?
- by George
Hi, could you help me please convert this SQL query to Linq to Entity query? Thank you select distinct item, count(item) as count from TableName where ColumnName = @parameter and (ColumnName2 = @parameter2 OR ColumnName3 = @parameter3) group by item order by item ascRead the article
-
Why does Linq to Entities generate Left Outer Joins?
- by DJCasey
I was wondering if anyone knew why linq to entities always seems to generate left outer joins. I would understand it on an optional relationship but it doesn't make good sense when the relationship is mandatory. Does anyone have any idea how to make it generate inner joins instead?Read the article
-
How do I perform this XPath query with Linq?
- by John Hansen
In the following code I am using XPath to find all of the matching nodes using XPath, and appending the values to a StringBuilder. StringBuilder sb = new StringBuilder(); foreach (XmlNode node in this.Data.SelectNodes("ID/item[@id=200]/DAT[1]/line[position()>1]/data[1]/text()")) { sb.Append(node.Value); } return sb.ToString(); How do I do the same thing, except using Linq to XML instead? Assume that in the new version, this.Data is an XElement object.Read the article
-
Is it OK to try to use Plinq in all Linq queries?
- by Tony_Henrich
I read that PLinq will automatically use non parallel Linq if it finds PLinq to be more expensive. So I figured then why not use PLinq for everything (when possible) and let the runtime decide which one to use. The apps will be deployed to multicore servers and I am OK to develop a little more code to deal with parallelism. What are the pitfalls of using plinq as a default?Read the article
-
How to use Linq To Sql to get Users who has more than 2 photos?
- by Mike108
The scenario is I want to get the users who has more than 2 photos. There are two table: [Users] (UserId, UserName) [UserPhotos] (PhotoId, PhotoName, UserId) and UserId is a Foreign Key. A user may have none photo in the [UserPhotos] table. How to use Linq To Sql to get List who has more than 2 photos?Read the article
-
Linq to SQL: how get row security between write access??
- by Francisco
I would like to allow two threads to write in a table at the same time (I know the problem of updating the same row, but this would be a story apart). I need that in behalf of speed up the operations in my aplication (one thread could write in row X while another could do the same in row X+n instead of waiting the first to finalize). So, can I block rows instead of tables with Linq to SQL? Thanks.Read the article
-
How do I change this query to linq to sql?
- by Piyush
Query: select emp.empname as Name, dep.depname as Department from Employee as emp inner join Department as dep on emp.depid=dep.depid where emp.id='2' How can I change this to linq to sql?Read the article
-
C#, LINQ. How to find an element within group of elements
- by Bobb
Imagine you have int[] data = new int [] { 1, 2, 1, 1, 3, 2 } I need sub-array with only those which conform to a condition data[i] data[i-1] && data[i] data[i + 1]... i.e. I need all items which stick over their immediate neighbours. From example above I should get { 2, 3 } Can it be done in LINQ? ThanksRead the article
-
LINQ to SQL .Count takes way to much process time and decreases performances.
- by soldieraman
LINQ to SQL .Count takes way to much process time and decreases performances. I am doing a recursive loop and for one child (lets call it parent) I have to check the number of children under it to make a decision if it should be included or not. The Count is too slow 8 ms :( for 120 parent records. Any ideas to make it quicker.Read the article
-
What is the difference between Equals and = in LINQ?
- by sunpech
What is the difference between Equals and = in LINQ? Dim list As List(Of Foo) = (From a As Foo In FooList _ Join b As Bar In BarList _ On a.Something = b.Something _ Select a).ToList() versus Dim list As List(Of Foo) = (From a As Foo In FooList _ Join b As Bar In BarList _ On a.Something Equals b.Something _ Select a).ToList()Read the article
-
Is there a way to make Linq to Entities map unrecognized methods/functions to MySql functions?
- by Luiscencio
Is there a way to make Linq to Entities map unrecognized methods/functions to MySql functions? I want to add support to some functions like Convert.*Read the article
-
How to convert SQL Statement with TOP, COUNT and GROUP BY to return an object list with LINQ
- by Junior Mayhé
Hello guys does anyone know how to convert this SQL statement to a LINQ to a List? SELECT TOP(5) COUNT(CategoryId), CategoryName FROM Tickets GROUP BY CategoryName The result would be something like public static List<Categories> List() { MyEntities db = new MyEntities(); /* here it should return a list o Category type */; return db.Category.GroupBy(...).OrderBy(...); }Read the article
