C# - Check The Null Of An Embedded Linq To Entities Statement?

Dec 15, 2010

Using linq to entities i am connecting to a database, the database has tables in it that has payments that have a multi to multi relationship with jobs. This is acheived via an allocs table. I want a list box with all the jobs that has a column called due price which takes all of the allocations of payments for this job and takes that away from the job price. However, using the below linq to entities statement. The problem is that if the job has no allocations it returns null and therefore the due payment is empty. What i really want is for the due payment to be the job price if there are no allocations however, i cannot think of a way around this.

var jobs = from j in data.jobs
where j.property.customer.id == customerid
&& j.completed != null
select new
{
j.id,
j.price,
dueprice = j.price - ( from a in data.allocs
where a.job.id == j.id
select a.amount ).Sum(),
lineone = j.property.lineone,
postcode = j.property.postcode,
jobtype = j.jobtype.name,
j.completed
};

View 3 Replies


Similar Messages:

ADO.NET :: Check If Statement Is Null In Linq Sql, Then Continue?

Mar 12, 2011

Right now I have an error if f.ParentID is null:

DataSet1.TreeItemRow[]
TreeItemRows = (from f
in tidt
where (f.ParentID == TreeItemId)
select f).ToArray();

I must continue if f.ParentID is null, I don't want to include null fileds in the array. What is the right syntax for that is linq sql?

View 17 Replies

LINQ To Entities Doesn't Recognize The Method - Delete Statement

Apr 4, 2011

I have a GridView and on a row being deleted I trigger the GridView1_RowDeleting sub, but I receive an error "LINQ to Entities does not recognize the method 'System.Web.UI.WebControls.TableCell get_Item(Int32)' method, and this method cannot be translated into a store expression." Code is:

Private Sub GridView1_RowDeleting(sender As Object, e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting
' The deletion of the individual row is automatically handled by the GridView.
Dim dbDelete As New pbu_housingEntities
' Remove individual from the bed.
Dim remove_bed = From p In dbDelete.Beds _
Where p.occupant = GridView1.Rows(e.RowIndex).Cells(3).Text _
Where p.room = GridView1.Rows(e.RowIndex).Cells(6).Text _
Where p.building = GridView1.Rows(e.RowIndex).Cells(5).Text _
Order By p.id Descending _
Select p
remove_bed.First.occupant = ""
dbDelete.SaveChanges()
' Increase number of open spaces in room.
Dim update_occupancy = From p In dbDelete.Rooms _
Where p.room1 = GridView1.Rows(e.RowIndex).Cells(6).Text
Where p.building = GridView1.Rows(e.RowIndex).Cells(5).Text _
Select p
update_occupancy.First.current_occupancy = update_occupancy.First.current_occupancy - 1
dbDelete.SaveChanges()
End Sub

The specific line erroring out is: remove_bed.First.occupant = ""

View 2 Replies

C# - Reading XML Using XDocument & Linq - Check If Element Is NULL?

Apr 7, 2010

I'm using LINQ together with XDocument to read a XML File. This is the code:XDocument xml = XDocument.Load(filename);

var q = from b in xml.Descendants("product")
select new
{

[code]...

View 3 Replies

C# - SQL Statement Transformed TO LINQ - How To Translate This Statement To A Working Linq

Mar 5, 2010

I am having trouble with this I have 3 Data tables i use over and over again which are cached I would like to write a LINQ statement which would do the following is this possible?

T-SQL VERSION:

SELECT P.[CID],P.[AID]
,B.[AID], B.[Data], B.[Status], B.[Language]
FROM MY_TABLE_1 P
JOIN
(
SELECT A.[AID], A.[Data], A.[Status], A.[Language] FROM MY_TABLE_2 A
UNION ALL
SELECT B.[AID], B.[Data], B.[Status], B.[Language] FROM MY_TABLE_3 B
) B on P.[AID] = B.[AID]
WHERE B.[Language] = 'EN' OR B.[Language] = 'ANY' AND B.STATUS = 1 AND B.[Language] = 'EN' OR B.[Language] = 'ANY' AND B.STATUS = 1

Then i would like it to create a result set of the following

Results:
|CID|AID|DATA|STATUS|LANGUAGE

View 3 Replies

ADO.NET :: Use SP With Linq To Entities?

Sep 25, 2010

How to use Stored Procedures with Linq to Entities? I prefer an example with input and output The videos on asp.net only show how to do this with Linq to SQL.

View 5 Replies

Sql To Linq To Entities

May 13, 2010

I have a simple join:

SELECT * FROM MessageAlerts AS A LEFT OUTER JOIN Contacts AS C ON A.ContactId = C.Id LEFT OUTER JOIN
Users AS U ON A.UserId = U.Id INNER JOIN Businesses AS B ON B.Id = C.BusinessId OR B.UserId = U.Id

how to do this : ON B.Id = C.BusinessId OR B.UserId = U.Id with linq in entity framework.

View 2 Replies

ADO.NET :: Practical Technique For Dealing With Null Entities?

Feb 27, 2011

In my new ASP.NET EF4 project, I find myself having to do a lot of maneuvering around null entities. For example, I may have a Project Entity with a related User Entity exposed through an Assignee property. Suppose I need to send an email to someone indicating who the Assignee is, I need to say:string x = "The Assignee is: " + TheProject.Assignee.Name;but I'll get an exception if there is no Assignee as the property is null (I want nulls by design) and I can't fetch the .Name property on that null.

View 4 Replies

MVC :: What E Position Is For Linq To Entities 2 SQL

Jan 27, 2010

WHY are all the examples on this site linq to SQL? Did ms not themselves announce dropping support for l2SQL over a year ago? i really don't get it. Examples are great.. but really not helping me since i've gone ahead and listened to MS. And can someone at MS clarify what the position is for linq 2 SQL.. Is it supported? Recommended? What the hell.

View 7 Replies

ADO.NET :: Structure The BLL Using LINQ To Entities?

Nov 10, 2010

I am trying to learn LINQ to entities, and am working out how to best structure my BLL layer. I have generated the entity model and have created a generic repository in my DAL that returns results as IList<T>. I initially created the BLL to also return

results as IList<T>:

public IList<DAL.Customer> SelectAll()
{ [code]...

Now I am working on the aspx page, and I can create an ObjectDataSource and configure it to use my BLL, but since I am returning IList, I can't sort since I am not using a DataView. I have seen some articles on the web for converting IList to DataView, but that seems like a lot of overhead for every query.My goal is to keep a clean separation between layers without making things overly complicated. I would like to know how others have done this, or maybe a link to a good tutorial that shows how to structure all three layers.

View 8 Replies

ADO.NET :: Contains() Method Not Working In Linq To Entities

Mar 8, 2011

I am building a web application in asp.Net 4.0 and entity framework. I am trying to retrieve a list of products based on a collection of id's. I first gather all the id's in a collection and then pass it to the linq query. I am trying to get a functionality similar to the IN clause in SQL. The problem seems to be with the Contains() method in the Linq to entities query. Here is my Linq code:

[Code]....

I got the above Linq to entities method from here: [URL]

View 2 Replies

Constraint On Linq To Entities Include?

Jun 22, 2010

I have a message table that self joins to itself where Message.ID == Message.Parent. So I have 1 Message with several ChildMessages. This is set up nicely with a Navigation property.

The code is currently:

var message = from m in soe.Messages.Include("ChildMessages")
where m.ID == id
&& m.IsActive
select m;
return message.FirstOrDefault();

What I really want is to only return 1 Message (that is equal to a particular ID and isActive) with all of its Active ChildMessages and I want to do it in one call to the database.

View 2 Replies

C# - Temp Table In LINQ To Entities?

Nov 4, 2010

I have a table of user ids that is huge.

I have an array of user ids that I want.

I have two tables that have a foreign user id key.

What is the best way to get this information performance wise?

Ideally in SQL the final result would be somewhat like this (null values if there is no user ID in one table but not the other):

userid table1value table2value
1 null 12
5 123 null

View 3 Replies

ADO.NET :: Set Aliases In LINQ Entities Framework?

Jul 29, 2010

i have a table with a field name called 'Firstname' and another field name called 'Lastname'. I would want to have a single column in my GridView which show Fullname and then the firstname and lastname are showed here under an alias. Also, i am binding my GridView using LINQ.So is there a way to create aliaswith LINQ and to use these with GridView ? Would love to have an hint about how i can realize this task.

View 5 Replies

MVC :: DropDownListFor And Linq To Entities At Post?

Apr 14, 2010

I use the Entity Framework and Linq to Entities with MVC 2.0. When use the DropDownListFor from Html helpers to populate a dropdown that contains an ID from a foreign object, I post the form data but I canīt set the correct relation. Using the debug, I can see the ID retrieved from dropdown at my returned foreign object ID, but I think that I not use the association correctly.

View 4 Replies

C# - Linq To Entities / Create Database

Dec 15, 2010

In linqtosql you could do something like:

datacontext.CreateDatabase() to generate a database from the model in sql.

I'm wanting to do the same thing in linq to entities.

Say I have a class MyEntities which inherits from ObjectContect is there a similiar method?

View 2 Replies

ADO.NET :: Inserting Data With LINQ To Entities?

Aug 11, 2010

have already used the latest technology in a professional manner. NETBasically I have two tables related 1 to 1:the Users table and the table ProfiloPersonale is the key to the Users table that this table are ProfiloPersonale iduser and type uniqueidentifier and diagram sql server 2008 I can clearly see the report, I also did a test to insert a record in the users table ( fictional) directly from sql server and everything works.With LINQ to Entities does not work:The entities 'LEntities.Users' part of the eport 'ProfiloPersonale'.Found 'ProfiloPersonale' related to 0.Expected 1 'ProfiloPersonale'Of course what I am doing is to first create the user and then create their profile in the db, taking the id of the registered

View 1 Replies

C# - Insert A New Row Using A View With Linq To Entities?

Dec 17, 2010

I have a view on my database and I am trying to add a new record using the AddTo method but it is not working. I noticed that LinqToEntities is creating the insert statement like this

Insert into (select field1, field2 from my_view) (field1, field2) values (value1, value2)

Is it possible to make LinqToEntities create the insert statement like the one below ?

Insert into my_view (field1, field2) values (value1, value2)

View 1 Replies

ADO.NET :: Linq To Entities Update Model?

Dec 8, 2010

I am trying to update an item with entity framework but I am unable to do that;

[Code]....

it didn't give any error. it passed but when I looked at the database, nothing changed. can you provide me the right way.

View 1 Replies

ADO.NET :: LINQ To Entities - Getting The Value Of The Rows By Column?

Nov 17, 2010

All I am trying to do is query the database, then get the returned values, so that I can do some calculations. But, I don't understand how to get the values from the database row that is returned, so that I can assign it for usage.

I would like to do something where the logic goes: for the index of [1] (which is just column 1), multiply it by 2. For the index of [2] (which is just column 2), multiply it by 3.

Example below:

This does NOT work:

[Code]....

View 6 Replies

Linq To Entities Multiple - Clause &&

Feb 22, 2010

In the code bdehind && syntax does not work, any ideas?

Entities ctx3 = new Entities();
var uniqueQuote = from quot in ctx3.Quotes.Include("aspnet_Users").Include("Enquiries")
where quot.Enquiries.EnquiryId == selectedEnquiryId && [code]...

Error 2 Delegate 'System.Func' does not take '1' arguments C:LocalGarageFinderLocalGarageFinderEnquiryDetail.aspx.cs 56 33 LocalGarageFinder

View 1 Replies

JQuery :: Autocomplete With Linq To Entities?

Mar 10, 2011

Iīve been trying to add jquery autocomplete in my website, iīm using asp.net 4 and linq to entities ....

Iīve searched a lot but couldnīt find an answer for this especific case.

View 2 Replies

ADO.NET :: Compare Dates In Linq To Entities?

Feb 28, 2011

I want to compare Dates in my Linq To Entities, and here is my code

var query = from ann in _announcementEntities.Announcements
where ann.CreateDate.Date == dateTime.Date
select ann;

thou this block of code throws an error:The specified type member 'Date' is not supported in LINQ to Entities
how can I make this work?

View 6 Replies

MVC :: 2 And Linq To Entities - Objects Is Not Appears At Dropdown

Mar 26, 2010

I am use the new ASP.NET MVC 2 and Entity Framework, but when I try to create a new view with strongly-typed option selected, the entity objects is not appears at dropdown and I cannot use the view creation wizard. I recompile the solution, but still not appears yet. Have any workaround that I forgot to do to enable the entities to be displayed at dropdownlist ?

View 5 Replies

Mvc Nerddinner Question Linq To Entities Join?

May 13, 2010

I am working on a website similar to nerddinner. Is it possible to perform similar join
using Linq to entities what is done with linq to sql in nerddinner.I am posting the codes below.

public IQueryable<Dinner> FindByLocation(float latitude, float longitude) {
var dinners = from dinner in FindUpcomingDinners()
join i in db.NearestDinners(latitude, longitude)

[code]...

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved