I've added the Dynamic.cs file to my project and have set it's Build Action = Compile in order to get the System.Linq.Dynamic namespace.
However, when I try to use any of the new code I am getting an ambiguous call error; see below.
[Code]....
I am getting this compilation error"
All my pages are receiving this error - website is down; here's the code:
[Code]....
Except my web config file shows linq is accounted for? [Code]....
I would note that I updated to VWD Express 2010 then had to revert back to 3.5 because my host at Arvixe had not updated my server yet. He then said he updated it and I reverted up to 4.0 again. It turned out he hadn't and I tried to revert back...and then this showed up and numerous other errors.
I have one sproc with Dynamic Temp Table. Sproc returns dynamic temp table rows and when I drag and drop the sporc on to Linq to Sql Designer I am not getting Return Type as "(Auto-generated Type).
how can I get Return Type as Auto-generated Type.
I am trying to use Linq to Entities with the Linq.Dynamic library (via Scott Guthrie) and I'm having some strange issues with querying dates.
[Code]....
This return no results, when it definitely should...
I uploaded my website to the server, and I have there a working with wcf - it should be fw 3.5I saw that fw 3.5 is installed on the server and also we have re fw 3.0 sp1.I run my website : www.qenglishcenter.comand I'm getting an error : The type or namespace name 'Linq' does not exist in the namespace 'System' (are you missing an assembly reference?)shouldn't System.linq be already existed ?
View 2 RepliesWe would like to perform something like this
string strCondition = "FirstName=='abc'"
from p in People.Where(strCondition) select p
In our architecture we are usign both Linq-Sql as well Linq-Entity. So please give some thoughts wehter it is possible or not and is there any way to perform this?
is it possible to have a dynamic order in a stored procedure? I have a report that I am generating, I want the report headers to be clickable...so when a user clicks, that column is ordered ASC, and when the user clicks again, it is ordered DESC. I tried something like this, but it won't let me use ASC or DESC...
[Code]....
How do I translate the following query into LINQ to SQL?
[Code]....
Using System.Linq; namespace does not supportted in VS2005 version 2.00.
View 1 Repliesi am facing a problem in theme and skin.
when i am trying this in skin
<asp:TextBox runat="server" BackColor="#BFDFFF" BorderColor="Black"></asp:TextBox>
<asp:DropDownList runat="server" BackColor="#BFDFFF"> </asp:DropDownList>
<asp:Button runat="server" BackColor="#BFDFFF" BorderColor="Black" />
<asp:GridView runat="server" AllowPaging="True"
AutoGenerateColumns="False" Width="100%">
<RowStyle BackColor="#BFDFFF" ForeColor="Black" />
<SelectedRowStyle BackColor="#FFFF99" />
<HeaderStyle BackColor="#666666" />
<AlternatingRowStyle BackColor="Silver" />
</asp:GridView>
<asp:DataList runat="server" Width="100%" RepeatColumns="3">
<ItemStyle BackColor="#BFDFFF" ForeColor="Black" Width="90%" />
<AlternatingItemStyle BackColor="Silver" />
<HeaderStyle BackColor="#666666" />
</asp:DataList>
and < pages theme="BlueTheme" runat="Server"/>
then this error comes .
Error1 'XElement'is ambiguous in the namespace 'System.Xml.Linq'.InternalXmlHelper.vb
I have the following code:
[Code]....
With this code behind:
[Code]....
Initially, I wrote the GetTeamMember() method to display the FullName in the ItemTemplate.
Then as I wrote the EditTemplate, I needed to populate a DropDownList with a list of names (first and last). It was fairly easy using the LinqDataSource, however it currently only shows the LastName. I could write another method GetTeamMembers() to populate the ddlTeamMember with the data I want, but I thought maybe there's a better "LINQ" way.
So I'm looking for a better way to get FullName (i.e. Firstname + " " + LastName) into both lblTeamMember and ddlTeamMember.
Options I thought of are:
I could write a method GetTeamMembers() I write a StoredProc that returns the extra column Better way?
how to indicate which columns I would like returned at run-time from a LINQ To SQL statement?I am allowing the user to select items in a checkboxlist representing the columns they would like displayed in a gridview that is bound to the results of a L2S query.I am able to dynamically generate the WHERE clause but am unable to do the same with the SELECT piece. Here is a sample:
var query = from log in context.Logs select log;
query = query.Where(Log => Log.Timestamp > CustomReport.ReportDateStart);
query = query.Where(Log => Log.Timestamp < CustomReport.ReportDateEnd);
[code]...
I am using System.Linq.Dynamic to create the following query at runtime:
[Code]....
I can then successfully display vMediaQ in a GridView.But I need to be able to access the individual fields (column headers and data) in vMediaQ, which is of type System.Linq.IQueryable.
I have a table created on the fly. The table structure is dynamic.
This is the table structure generated by the end of year 2010
DealerCode, 201010, 201011, 201012
This is the table structure generated by the end of Jan 2011
DealerCode, 201011, 201012, 201101
What I need to do is selecting all data and then bind it into a gridview
To build a LINQ query, we need to drag the table into dbml file first. As we don't know how the table look like, can we add it in dynamically? Are there any other solutions?
I am writing a function in which i generate autocode in specific format i want to make this function generalize so that i send tablename and columnname parameter and function return the next code. I am using linq to sql with MVC e.g. i want to make table name and column name dyanamic
[Code]....
Linq add wildcard in the where clause dynamically I have a query, i.e.
var query = from r in context.company .....
then have some business logic and based on the validation I want to add dynamically a where clause
if(a == "1")
query = query.Where(r=> r.Name = Fullname); //works!!
else if(a == "2)
query = query.Where SqlMethods.Like(r=> r.Name,"%"+Fullname+"%"); //fails to compile , the r.Name is not found..
I'm trying to do something that on the face of it is very simple.
If I have 5 text boxes, and 1 of them is blank, I want to exclude that textbox from the query, rather than searching for where a field is blank.
I've tried to do a bit of research into dynamic linq queries, but have come up empty handed, or what I've found doesn't seem to quite answer my question.
Loading data into gridview, retieving data using linq,I have a method that accepts two paramters that would sort specific field and return the object to the gridviewi.e.
passing into the method GenerateData(string sortExp, string sortDir)
sortExp = "Name", sortDir = "descending"
linq query://works
[code]...
I have a gridview with several columns, 3 of which I'd like to sort. The source for the data is held in the session.
protected void MyGridHistorySort(object sender, GridViewSortEventArgs e)
{
var TheColumn = (e.SortExpression).ToString();
TheDataHistory = (List<ViewDataHistoryModel>)Session["SessionDataHistory"];
var test = "data.DataDate";
var NewDataSource = from data in TheDataHistory
orderby test
select data;
MyGridHistory.DataSource = NewDataSource;
MyGridHistory.DataBind();
DataDate is a valid column in the list but the orderby statement doesn't work. Ideally, I'd like it to sort with the variable TheColumn by writing something like test = "data."+TheColum; and then add a sort direction based on a boolean. I looked at the OrderBy extension method NewDataSource.OrderBy(test); but that doesn't work either.
Is it possible to generate dynamic LINQ statements? I need to be able to build conditional "WHERE" clauses for some of my LINQ statements. I don't want to write a giant block of code to hand every possible combination of filters, sorts and groups. I found a article online that outlines how to use string based where clauses here. Does LINQ in framework 4.0 no longer support this? Every example I've found has giant walls of virtually unreadable, must likely unmaintainable code.
View 1 RepliesThis error comes up when adding a content page to a website. Is there something that I need to add somewhere?
[Code]....
I have downloaded Visual Web Developer 2010 Express and am trying to use LINQ. In order to do that I have added a LINQ to SQL class to the web site and have dragged tables from the database view into the LINQ designer, which worked fine.But..When I add: using System.Data.Linq;to MainPage.xaml.cs, I receive an error:
Error 3 The type or namespace name 'Data' does not exist in the namespace 'System' (are you missing an assembly reference?)Even although I have references to System.Core, System.Data, System.Data.Linq in the website references.
the same problem wuit hme here I wanna to convert from IQureable<int> to int type?
View 2 RepliesIs there a way to do the following in VB:dim sTableClass as string = <my underlying table class in linq>dim dbTab as system.data.linq.table(<typed class of sTableClass>)I've tried cycling through the table objects of the linq data context and retrieved the following: Dim ddData = pkDB.GetTable(tt.RowType.Type.UnderlyingSystemType)(where tt reflects the row of the table I want to retrieve) But the expression returns and itable and I need the table equivalent but can't get this to work with a stri
View 1 RepliesI am having a lot of the same issue as this poster did with errors on initializing type.
I am trying to learn linq and am about ready to give up - don't get how this is easier...
I'm trying to do a simple update to product names in the product table based on the manufacturer ID
In order to do this I am looping through each record. I was initally successful with changing all names in the column but when I try to query the data, I continually run into multiple problems.
The following poster has had the same issue I have but his solution isn't working for me.
[URL]
I keep getting the same error on the opening bracket on the select statement in the SelectByManufacturerID function...
Error 1 Cannot initialize type 'DataBaseDataManagement.ProductName' with a collection initializer because it does not implement 'System.Collections.IEnumerable'
Button that does the actual updating...
[Code]....
The function that the button calls to get the query... ERROR
[Code]....
The class located in Query.cs...
[Code]....
