Search Results

Search found 31588 results on 1264 pages for 'linq to sql designer'.

Page 182/1264 | < Previous Page | 178 179 180 181 182 183 184 185 186 187 188 189  | Next Page >

• Linq Expression Trees in Compact Framework.

  - by Michal Drozdowicz

  The lack of expression trees in Compact Framework has bugged me for some time now, but I haven't really looked for a solution. Today, I've found a blog post about an alternative System.Linq.Expressions built on top of Mono System.Core and used e.g. by db4o (you can find it here). My question is - have you used this library and if so, what were your experiences with it (especially regarding performance)?

  Read the article

• how can i pass parameter to linq query

  - by girish

  i want to pass parameter to linq query... public IEnumerable GetPhotos() { PhotoDBDataContext db = new PhotoDBDataContext(); var tProduct = db.Photos; var query = from p in db.Photos orderby p.PhotoId descending select new { p.Album, p.AlbumId, p.Description, p.Photographer, p.PhotographerId, p.PhotoId, p.Tags, p.Thumbnail, p.Url }; return query; } in above example "orderby p.PhotoId descending" is used, i want to use parameter in place of p.PhotoId is it possible...

  Read the article

• Linq Queries converting to lambda expressions ?

  - by Freshblood

  Hello from item in range where item % 2 ==0 select i ; is converting to lamda expressions as below range.where(item % 2 ==0).select(x=>x). I feel that first way of linq is translating next one and if it is ,so is there any optimization like this range.where(item & 2 == 0) instead of other one ?

  Read the article

• Instantiate defined object with Linq Query

  - by Heinz

  I know that you can instantiate anonymous types with Linq but I am looking to instantiate an object I have already defined. Every time I do, all the properties are returned with their defaults (null, 0, etc.) Is there a way to make this work? I've tried something like this: ServiceDepartment[] serviceDepartments = (from d in departments orderby d.department_name select new ServiceDepartment { DepartmentID = d.department_id, DepartmentName = d.department_name }).ToArray();

  Read the article

• Selecting columns with linq with nested dictionary

  - by Daniel A. White

  How do I get all of the "columns" using linq from this dictionary. Dictionary<int, Dictionary<int, string>> _cells; where I can access a row this way var someRow = _cells[2];

  Read the article

• Returning the PK during a linq to sql insert

  - by Blankman

  I want to return the PK ID when I insert a new user via linq to sql. how can I do this? i.e. is there anything built in or do I have to do 2 queries?

  Read the article

• List to Columns in LINQ

  - by Sam Saffron

  Given an IEnumerable<T> and row count, I would like to convert it to an IEnumerable<IEnumerable<T>> like so: Input: Row Count: 3 List: [1,2,3,4,5,6,7] Output [ [1,4,7] [2,5] [3,6] ] How can I do this using LINQ?

  Read the article

• Get records which not starts with alphabet in linq

  - by Prasad

  I need to get the list of records that does not starts with alphabets. i.e. Which starts with numeric and any special character. I am using asp.net mvc (C#) for my application. Whats the simple linq query to get this list?

  Read the article

• How are attached properties useful in LINQ?

  - by James Cadd

  I got this question during an interview in the past and never really dug into in, but I've put some thought into it lately and I can't come up with a good answer. When I think of attached properties my mind goes straight to UI related concepts - what benefits could be had in using attached properties with LINQ? I'm starting to think the answer is "they're not" unless I find out otherwise!

  Read the article

• LINQ Single vs First

  - by BahaiResearch.com

  LINQ: Is it more efficient to use the Single() operator over First() when ever I know for certain that the query will return a single record? Is there a difference?

  Read the article

• Linq to SQL - Returning two values with one query

  - by Sir Psycho

  Hi, Is it possible to return a single value and an enumerable collection using LINQ to SQL? The problem is, I'm trying to do paging across a large recordset. I only want to return 10 rows at a time so I'm using .Skip(20).Take(10) approach. However I need to know the total number of records so I can show an appropriate page x of y. Trying to avoid two separate queries. Thanks

  Read the article

• Linq to Entity Dynamic where clause

  - by GodSmart

  I have Linq to Entity query like you can see below I am using it five times in my code, everything that change is where clause. is it possible to create a method and pass just where values, not to write all code five times. Thank you items = from t1 in _entities.table1 join t2 in _entities.Table2 on t1.column1 equals t2.column1 join t3 in _entities.Table3 on t1.column2 equals t3.column2 join t4 in _entities.Table4 on t1.column3 equals t4.column3 where **t1.column5 == Something** select new { t1.column7, t2.column8, t3.column9, t4.column10 };

  Read the article

• Linq to Sql statement for multiple aggregate values in single expression

  - by Jeff Langston

  How would I write a linq to sql statement for the following tsql? select count(*), sum(Amount), avg(Amount), min(Amount), max(Amount) from TableName

  Read the article

• NHibernate LINQ + PLINQ

  - by cvista

  Hi i've just started reading up on PLINQ and find it fasinating. I'm using NHib-Linq in my projects - does anyone know if there's any benefit/problems using PLINQ type queries with NHLinq? w://

  Read the article

• LINQ problem on remote machine

  - by HaMMeR

  I am using LINQ expressions in my code like this var obj = Collection.Single(collection = (collection.ShortName.Equals("AAA"))); The problem is that this line works fine for me, no problems. But when I upload the same executable to some remote machine with same 32 bit Windows XP. The code execution is just stopping at this line of source. Can anyone help me.

  Read the article

• How do I cache query results using LINQ?

  - by Vince

  Hi, Is there any way to cache LINQ to SQL queries by looking at the parameters that were previously passed and bypass the database all together? I know L2S caches some database calls, but I'm looking for a permanant solution as in, even if the applciation restarts, that cache reloads and never asks the database again. Are there any frameworks for C#?

  Read the article

• how to Update the XMl value and write back using LINQ

  - by NewDev

  Hi all, i am having query for update the node value using Linq, For example i am have to update <Student> <studentdetail> <studentname>test</studentname> <libraryid>hem001</libraryid> </studentdetail> </Student> in above xml i want to change the value of Student name "test" ti something else like "Undertest" regards NewDev

  Read the article

• a linq query to find something

  - by rap-uvic

  Hi, I have object A which contains multiple instances of object B, which in turn contains multiple instances of object C. I need to write a function which, given Object A needs search through instances of objects B and objects C and find a particular object C. How would I do this using LINQ?

  Read the article

• LINQ: How to skip one then take the rest of a sequence

  - by Marcel

  Hi All, i would like to iterate over the items of a List<T>, except the first, preserving the order. Is there an elegant way to do it with LINQ using a statement like: foreach (var item in list.Skip(1).TakeTheRest()) {.... I played around with TakeWhile , but was not successful. Probably there is also another, simple way of doing it?

  Read the article

• Which is more flexible in regards to database changes, EF 4 or Linq to SQL

  - by JBeckton

  Reading about both Linq to SQL and Entity Framework I have developed the impression that EF is more suitable for apps that get data from multiple data sources. But as I am reading about MVC2 models I see an example where EF is more loosely coupled with your data model. If I have to add or remove some columns from a table then what is involved in updating my model or DAL with each of these implementations?

  Read the article

• NHibernate Linq Provider question

  - by csizo

  Can anyone answer me what are the differences of Session.Query Session.Linq and Session.QueryOver What I'm really interested in: What would be supported in the future versions. What should I start to use in a clean project. Please tell me your thoughts about these three... Thanks, Zoltán

  Read the article

• Updating value in Linq to SQL IEnumerable

  - by Learner

  Using Linq to SQL: if(!parentlist.childlist.Contains(row1)) parentlist.childlist.Add(row1); else How do I update the required childlist row with row1? Each row of the child list has a unique id. parentlist implements IEnumerable and childlist is IList.

  Read the article

• VB.Net Linq Datatable Exists

  - by LarsH

  I would like to use Linq instead of below function : Friend Function IsCollectionInTable2(ByVal apps As DataTable, ByVal collectionId As String) As Boolean For Each row As DataRow In apps.Rows If row("CollectionId").ToString = collectionId Then Return True Next Return False End Function The best I can do is below: Friend Function IsCollectionInTable(ByVal apps As DataTable, ByVal collectionId As String) As Boolean Return (From row In apps.AsEnumerable() Where (row.Field(Of String)("CollectionId") = collectionId) Select row.Field(Of String)("CollectionId")).Count > 0 End Function I would like to use Exists or Any in above function. Performance could be an issue,

  Read the article

• How can I join conditionally in LINQ queries?

  - by Steve Crane

  If I have two tables; Drivers keyed by DriverId and Trips with foreign keys DriverId and CoDriverId, and I want to find all trips where a driver was either the driver or co-driver I could code this in Transact-SQL as select d.DriverId, t.TripId from Trips t inner join Drivers d on t.DriverId = d.DriverId or t.CoDriverId = d.DriverId How could this be coded as a LINQ query?

  Read the article

• how to pass a parameter safely into linq to sql

  - by Blankman

  If I want to get a user that has the email address of '[email protected]', how do I pass that as a parameter in linq? ie.: var a = from u in Users where u.Email = @email Select u; So this would be used in my method: public static GetuserByEmail(string email) Do I just pass in the variable or?

  Read the article

< Previous Page | 178 179 180 181 182 183 184 185 186 187 188 189  | Next Page >