It seem to me that this was hard...
[code].....
I get this run time error "no supported translation to SQL".
What i want is to get lists of the posts, and do a small quick calculations of the rating and then sort those from highest to low and take 5 posts only.
I am facing problem while executing followinf linq query ..
[Code]....
Here i feel that problem is due to
[Code]....
method , this method is private method return for fetching age of the user based on the birthdate of the user..
I am creating an Asp.net web site which will support dynamic data. When I am creating a dynamic web site from Scratch (from template in VS) all is working fine. But when I am trying to add dynamic entity (.edmx) file and running the application I am getting following error
"The method 'Skip' is only supported for sorted input in LINQ to Entities. The method 'OrderBy' must be called before the method 'Skip'. "
There's an issue I'm having in several areas of my ASP.NET site, but am using the following as an example. If I can get it solved, then I'm reasonably sure it has applications elsewhere.Let's say I have a gridview based on the aspnet_membership table. Its LINQ datasource is aspnet_membership, which exists in my datacontext.By itself, it works GREAT in the grid.However, showing UserId in and of itself doesn't have much meaning; I wanted to include UserName.So, in my Public Partial Class, I created a read-only property UserName:
[Code]....
This retrieves and displays the correct data, no problem there.However, I'm not able to sort on that new column. When I attempt to do so, I get the following error: The member 'aspnet_Membership.UserName' has no supported translation to SQL.A workaround is, of course, to use a Sql datasource. But as I'm learning more about LINQ and the partial classes, I want to learn how to do it the correct way.
the best way to do the following (I'm using a simplified example of my actual problem?Say I have a customer ordered items table with fields: oItemId, OrderId, ProductId, ItemPriceI want to query where OrderId >oMin && OrderId <oMaxand for each value of OrderId I want to find the record with the highest ItemPriceso for a single OrderId the query would be:(from o in context.orderItems where OrderId==x orderby o.ItemPrice select o).first()but OrderId isn't a single value. If I modify the where clause then this query would still produce a single record whereas I want a single record per OrderId.oh and as an additional question: does anyone have a compact test for whether a record exists. I am using the querystring to specify an Id and there are numerous things that I want to protect against. If I do:
var myRecord = from o in context.orders where o.orderId == request.querystring["Order"] select othen this fails if the querystring isn't specified. So first I test that the querystring != nul . Then I need to do:bool recordExists = (myRecord != null)because even if the querystring is specified it may be an invalid orderId and thus the query returns no results. Is there a shorter/simpler way to calculate the result. I have not yet got to grips with lambda expressions and I'm not sure whether there is a better approach with lambda expressions.
I have a SQL query in a SQL Data Source that retruns the first photo in a photo group for multiple groups I'm puttting them in a ListView
whem a user selects a photo all the photos in that group come up in another ListView and they can viev the complete album
I'm using Linq query in the ListView1_SelectedIndexChanged event handler to load the secound List view I want to use a LINQ
query in the page load for the first ListView I need to translate this query to Linq
SELECT MIN(PlantId) AS PlantId, MIN(ImageUrl) AS ImageUrl, MIN(Description) AS Description, MIN(ThumbUrl) AS ThumbUrl, MIN(Country) AS Country, MIN(State) AS State, MIN(City) AS City, MIN(Region) AS Region, GroupId AS GroupId, MIN(ImageIpAddress) AS ImageIpAddress[code]....
Bellow is my .aspx aspxGridview syntax
<dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False"
KeyFieldName="intProductCode" onrowinserted="ASPxGridView1_RowInserted">
<Columns> [code]....
When i want to insert ,show me error message Specified method is not supported.
Why the following code produces the error? The query operator 'ElementAtOrDefault' is not supported
Dim Im = (From view In Db.Views Where _
view.Pass = txtCode.Text _
Select New With {.Id = view.UniqueID.ToString}_
[code]...
I have a few tables, Listings, ListingImages and a few others related to Listings. ListingImages is related to Listings so that you can have many ListingImages per Listing.
When I query this table I do;
[code].....
Now this is fine. However, I now want to sort the ListingImages independently within each Listing (by an ImageOrder column I have in that table).
How can I do this and pass all my Includes(...). Would it be bad form to sort the ListingImages within the View as this solution seems to work?
ASP.NET 4.0 comes up with a bulk of noticable improvements , including freshment of LINQ to Entities model. Other than this , I still remember another .net built-in ORM framework "LinqToSQL" which provides a lighter and more direct way to interact with SQL-server based db system. However, it seems no term concerns "Linq to sql" in .net 4.0 pulication announcement. So I think it might be deprecated in the furture due to .Net team's plan. I wonder if .NET team decide to just choose entity framework to fully serve as the .NET official ORM implement and no longer develop 'LinqToSQL' . Is LinqToSQL really an attemptive speck and not worth holding in the furture?
View 1 RepliesI am struggling to create a webservice method using LINQ technology and to populate a dropdown in a form. Here is the Webservice code.
[WebMethod]
public
string[] GetAllCountries()
{
LinqClassesDataContext db =
new
LinqClassesDataContext();
var q =
from c
in db.ListContinents()select
c;
return q.ToList() ;
}
And here is the form code behind
protectedvoid
Page_Load(object sender,
EventArgs e)
{
WSClass WS =
new
WSClass();//bool
ds = WS.GetAllCountries();
var v = WS.GetAllCountries();
ddlContinent.DataSource = v;
ddlContinent.DataBind();
}
get the below error. My application was working fine until I probably modified something, but don't know what.
Server Error in '/' Application.
Method is only supported if the user name parameter matches the user name in the current Windows Identity.
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Configuration.Provider.ProviderException: Method is only supported if the user name parameter matches the user name in the current Windows Identity.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ProviderException: Method is only supported if the user name parameter matches the user name in the current Windows Identity.]
System.Web.Security.WindowsTokenRoleProvider.GetCurrentWindowsIdentityAndCheckName(String userName) +2195661
System.Web.Security.WindowsTokenRoleProvider.GetCurrentTokenAndCheckName(String userName) +36
System.Web.Security.WindowsTokenRoleProvider.GetRolesForUser(String username) +61
System.Web.Security.RolePrincipal.IsInRole(String role) +182....
I have an Asp.Net TextBox control whose enabled property I need to evaluate using a separate (from the code-behind of the containing page) class. The way I want to do this is:
<asp:TextBox ID="myTB" runat="server" Enabled="<% ToggleControl(this, "someBusinessValue") %>" ... />
The reason I need to pass a reference to the calling control is to see if there are other properties I may need to consider before disabling it. The 'this' keyword, however, refers to the page as a whole. And since my TextBox can be within a FormView, or GridView, I can't easily just get the control byexamining 'page.myTB'. I don't want to have to start ploughing through GridViews on the receiving class file just to retrieve a reference to the TextBox.Does anyone know how to refer to the control inline in this way?EDIT 1: This will need to be done to several different types of server control, such as ListBox, CheckBox, RadioButtonList, etc.EDIT 2: The best I've come up with so far is:
<asp:TextBox ID="myTB" runat="server" Enabled="<% ToggleControl(myGridView.FindControl("myTB") as WebControl, "someBusinessValue") %>"
I have a web user control. That I load dynamicaly inside a modalpopup window using dynamic populate extender. User control has a external javascript file linked to it. Problem: I cannot make call to webservice method from this external javascript file. When I make a call -- servicename.methodname() I get servicename not defined error.
View 2 RepliesI am reading in a file into a string. Then I am writing this string to a stream. I know this code works fine.
The only problem that I have is with the line that write the data in chunks where the parameters is not supported for the Write method.
The line that has the problem is this line. What do I need to change here?
OutPut.Write(buffer, 0, Math.Min(to_write, WRITE_CHUNK));
[Code]....
I am tring to learn linq to sql (and programing in general). I have created my CRUD stored procedures and dragged and dropped them from my db to dbml. Now how do I use the methods that were created?
View 3 RepliesI 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]
have following method which returns "List"
public List<DistributionGroup> GetDistributionGroupsByUserId(Guid userId)
{
return (from dgu in db.DistributionGroup_Users where dgu.UserId == userId select
[code]...
I'm really new to ASP.Net and for a school project we have to create a login form. Now I have managed to create a login with LINQ doing the following:
[Code]....
And in my html page:
protected void Test_Click(object sender, EventArgs e)
{
if (Class1.Controle(Convert.ToInt32(txt1.Text), txt2.Text))
[Code]....
I was thinking something amongst those lines, but I can't call p.GebruikerWachtwoord. So I'm guessing this is completely wrong.I hope somebody can help me figure this out, and I apologise for the poor explanation, English isn't my native language.
my code will explain what the problem is in the WHAT DO I PUT HERE section how can get the list ordered by a-z?
View 3 Repliesi want to oredering My Data In DataTable by DateTime as Desc how???
i know i can do that in sql :
select MyDate from Dates order By Dates.MyDate desc
but i want to order it in DataTable
I have a dataset generated from xml from a web service.Data needs to be sorted by date order descending, I cannot get the web service changed so thought I'd try:
Code:
repeater1.DataSource = dsCombinedBlock.Tables(2).Select("Status < 3 and status <> 99", "DateReceived desc")
However the dates are treated as a string so the results look like
28/06/2011
27/06/2011
27/06/2011
02/06/2011
01/07/2011
How do I get the proper ordering applied.
I have a test web service called: MySimpleService.svc with a method called:GetUserNamesByInitials. below is the Linq to SQL code:
[OperationContract]
public static string GetUserNamesByInitials(string initials)
{
string result = ""; [code]...
what I do is to type the user id in one textbox (TextBox3) and when I press the Tab key the result is shown in another textbox(TextBox4).
The jQuery call works well with other methods that do not call the database, for example using this other web service method it works:
[OperationContract] public string ParameterizedConnectionTest(string word)
{
return string.Format("You entered the word: {0}", word);
}
However with the Linq method it just does not work.
I've been scratching my head for what seems like ages. I'm sure its really simple to fix but I can't see it.
I have a class in App_Code that uses a bit of Linq.
var siteMap = SiteMapWrapper.BuildSiteMap(true);
var currentTopLevelParent = siteMap.Single(s => s.IsActive);
if (currentTopLevelParent != null)
I've developed this locally and all works fine. When I transfer to IIS hosting the same class fails to compile. I receive:
does not contain a definition for 'Single' and no extension method 'Single' accepting a first argument of type 'SiteMapWrapper' could be found (are you missing a using directive or an assembly reference?)
I confirmed that the virtual dir is running .NET 2.0 as it should. I also confirmed that the correct assemblies are being loaded in the web.config.
<compilation debug="true">
<assemblies>
<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
</assemblies>
</compilation>
I want to access the data from datatable object. When i trying to get the fieldslist usng "Field" method. But I could not find the method with my table object. Eventhoguh i forcibly write a method and trying to access the fields, It is giving the below error for the first join in query. Rest of the lines are fine.
What is the reason behind it.
The errro: "Error 2 'LINQ2DB.SP_VS_OP' does not contain a definition for 'Field' and the best extension method overload 'System.Data.DataRowExtensions.Field<T>(System.Data.DataRow, string)' has some invalid arguments"
What is the meaningof the error. Shall i do any other changes in the query line?
var QueryChnl = from oSPOP in SPOP.AsEnumerable()
join oDiscChannel in DiscChannel.AsEnumerable() on oSPOP.Field<int>("spid") equals oDiscChannel.Field<int>("SPID")
join oChannel in Channel.AsEnumerable() on oDiscChannel.Field<int>("channel") equals oChannel.Field<int>("channelID")
where oSPOP.Mappingkey == 3200004
select new { oSPOP.Mappingkey, oChannel.channel, oDiscChannel.STATUS };