int complexQuery = (from e in mycontext.CreateQuery()

                                        where e.new\_QW1 != null
                                        select e.new\_QW1).Count();

                    

                    
                   if (complexQuery < 1)
                    {
                        var newQuery = "HasData";
                        entity.Attributes.Add("new\_testcomplexquery", newQuery);
                    }
                    else
                    {
                        var newQueryToo = "Blank";
                        entity.Attributes.Add("new\_testcomplexquery", newQueryToo);
                        

                    }

I want to use the results of complexQuery in an If statement but the value of complexQuery doesnt appear to be getting picked up. Anyone know why?

This is the code that I am looking to get a Count of complexQuery.

string refName = entity.GetAttributeValue<string>("contractorname");

var complexQuery = (from c in orgContext.CreateQuery<contractorframe>()
join e in orgContext.CreateQuery<dcc_eval>()
on c.ContractorName equals e.RegardingObjectId.ToString()
where e.RegardingObjectId.ToString() == refName
and e.QW Is Not Null)

I should have said I am trying to do this using LINQ: I have a 20 records in a database table. Each record has and ID. I want to read a field in each record fieldA. I only want to read the records that have an ID '1'. For each record that has an ID '1' and fieldA Is Not Null I want to return a count of those records. So if 10 records have data in fieldA and have ID '1' then my count for fieldA will be 10. Anyone know how to do this in Linq?

I have a 20 records in a database table. Each record has and ID. I want to read a field in each record fieldA. I only want to read the records that have an ID '1'. For each record that has an ID '1' and fieldA Is Not Null I want to return a count of those records. So if 10 records have data in fieldA and have ID '1' then my count for fieldA will be 10. Anyone know how to do this in Linq?

I have a 20 records in a database table and I want to read a field in each record fieldA. For each record that fieldA contains data I want to do a count of that field. So if 10 records have data in fieldA then my count for fieldA will be 10. Anyone know how to do this in C# ?

Thanks for your reply jkirkerk it was very helpful

I am building a system in asp.net C# with an Sql Server DB. I have split the work into separate tasks. I have put a timeline of around 41 days. The requirements are as below. Can anyone say how long it would take and if my timeline is too long? 1. Requirements Gathering and Associated Documentation - Requirements Specification/Functional Specification and Agreement with Stakeholder(s)/Users - 4 days 2 Create DB and Tables and 4 tables - 4 days 3 Create Login Form - 2 days 4 Create Menu - 2 days 5 Create Initial Input Form - containing all the fields that need to be recorded inititally and the 2 calculated fields - 5 days 6 Create “Update Single File” form - Allow user to update this file and write it back to the table in the DB - 3 days 7 Create “Update Multiple Files” form - Display multiple files maybe based criteria selected from dropdown and allow user to possibly do a bulk update of the records - 4 days 8 Create “Add Staff” form and have it writing to the Staff table - 2 days 9 Create “LogOut” form - 1 day 10 Create “Reports”. This would involve creating reports that would have the Grouping of the data in the various different scenarios e.g. Total for Invoice, Total for Trans Number. A report for Audit trail may be needed also. These reports may need to be created in SSRS reporting. - 5 days 11 Audit Trail - Create a record in the audit table each time a record has been updated. Maybe display this audit trail in the “Update Single File” form - 3 days 12 Create Stored Procedures in DB to carry out the above functions - 3 days 13 Carry out functional reviews with Stakeholder(s)/Users - 1 day 14 Carry out Unit testing - 1 day 15 UAT with Stakeholder(s)/Users and Sign Off of System - 1 day

I am building a system in asp.net C# with an Sql Server DB. I have split the work into separate tasks. I have put a timeline of around 41 days. The requirements are as below. Can anyone say how long it would take and if my timeline is too long? 1. Requirements Gathering and Associated Documentation - Requirements Specification/Functional Specification and Agreement with Stakeholder(s)/Users - 4 days 2 Create DB and Tables and 4 tables - 4 days 3 Create Login Form - 2 days 4 Create Menu - 2 days 5 Create Initial Input Form - containing all the fields that need to be recorded inititally and the 2 calculated fields - 5 days 6 Create “Update Single File” form - Allow user to update this file and write it back to the table in the DB - 3 days 7 Create “Update Multiple Files” form - Display multiple files maybe based criteria selected from dropdown and allow user to possibly do a bulk update of the records - 4 days 8 Create “Add Staff” form and have it writing to the Staff table - 2 days 9 Create “LogOut” form - 1 day 10 Create “Reports”. This would involve creating reports that would have the Grouping of the data in the various different scenarios e.g. Total for Invoice, Total for Trans Number. A report for Audit trail may be needed also. These reports may need to be created in SSRS reporting. - 5 days 11 Audit Trail - Create a record in the audit table each time a record has been updated. Maybe display this audit trail in the “Update Single File” form - 3 days 12 Create Stored Procedures in DB to carry out the above functions - 3 days 13 Carry out functional reviews with Stakeholder(s)/Users - 1 day 14 Carry out Unit testing - 1 day 15 UAT with Stakeholder(s)/Users and Sign Off of System - 1 day

Does anyone know of any Rapid Development tool for Asp.net to build a database front-end with reporting in a few days. Is Visual Studio LightSwitch any good?

I have data in a Sql Server DB. I want to put a basic front-end on this. The front-end would include a form for adding and updating records and having some reports generated from it also. Would Asp.net or Access be the best and quickest to develop front-end in this scenario?

I have a number of records displayed in a Gridview. Each record contains a blank field called Code. I want to have a field on my form, field A, which I can add a number to and there will be a button called updateCode. When I click the button updateCode I want the number in field A to be updated to the field called Code in each record displayed in the GridView. Anyone know if this can be achieved?

I have a asp.net web application created in VS 2012 and I want to create reports and letters in it. Anyone know how to create reports and letters in VS 2012?

I have four fields, A, B, C, D Fields A, B, and C will have numerics added to them. I want that when I have added data to all three fields then field D will automatically be updated with the SUM of the 3 fields A, B and C. Anyone know how to do this?

Thanks Peter.

I have data in a SqlServer table and I want to Select the data into a gridview or something like that and perform a calculation on the data. I want to have a button that will carry out a calulation on all the records displayed and save the total for each record after the calculation to a field in the DB table containing the records. Anyone any ideas on best way to do this?

I have a system which has an asp.net front end and a SQL Server DB. I get a file in the form of an excel spreadsheet every few weeks that contains a number of fields. I want to load it into the DB and the appropriate fields in the excel spreadsheet would go into the corresponding field in the DB tables. Anyone know how to do this?

It is only for a very small number of records around 50-100.

Thanks for your help Ill try this.

Im trying to do something like this: var complexQuery = from e in orgContext.CreateQuery("Eval") join c in orgContext.CreateQuery("Contract") on e["contractid"] equals c["contractnameid"] I want to do a Count of the complexQuery and whatever the count is I want to add this to a variable so I can write this out to a field.

Linq Method Would probably be the best as I have to write it out to a field. I'll put together some code and see what you think?