How To Add One Extra Temporary Entity In Collection Returned By LINQ
Nov 23, 2010
here my code-
List<ReservationSlotLimitDetailEntity> sorted = (from p in slotLimitCollection.OfType<ReservationSlotLimitDetailEntity>()
where p.DayOfTheWeek == dayOfTheWeek
select p).ToList<ReservationSlotLimitDetailEntity>();
I want to sort in such a way so that it will add on more temp column "DayName" based on condition such that if dayOfTheWeek==1 DayName=Monday and if dayOfTheWeek==2 DayName=Tuesday and so on.
View 1 Replies
Similar Messages:
Jul 21, 2010
Exsits any way to modify the temporary folder path returned by System.IO.Path.GetTempPath() method?
My asp.net application run under iis 7.
View 2 Replies
Mar 18, 2010
For a web application developed on ASP.NET, we are finding that for user control files (ascx) we are returning long strings as a result of method calls. These are embedded in the ascx pages using the special tags <% %>When performing memory dump analysis for the application, we find that many of those strings are not being garbage collected. Also, the ascx pages are compiled to temporary DLLs and they are held in memory. Is this responsible for causing the long strings to remain in memory and not be garbage collected ?
View 2 Replies
Apr 8, 2010
How to make this method return boolean value, depending on query return. False - nothing, True - data exists. Before i just returned int from uniqueQuote.Count() but does not look like great method.
private bool CheckEnquiryUser(int enquiryId, Guid userId)
{
int selectedEnquiryId = enquiryId;
[code]...
View 3 Replies
Aug 10, 2010
I'm having a trouble figuring out how I am going to map my business objects. I found this little mapper using reflection with a little modification :http://www.simple-talk.com/dotnet/.net-framework/a-defense-of-reflection-in-.net/Above works fine and fill out my Business objects properly. But what if I have relationship on the Business objects class like for example :
[Code]....
then a User Class will have a relationship with Roles like :
[Code]....
Assuming there are columns on the database that have the RoleID, RoleName, UserID, UserName by Joining the 2 tables. The problem here is that the Mapper doesn't map the Roles properly since the Mapper will expect a Column Name "Role". I tried also inheriting the roles instead of instantiating it but it doesn't work either.I'm using a 3-tier Architecture (including a sublayer "Business Objects") and List<T> combo.
View 10 Replies
Mar 28, 2011
I've got a GridView on a ASP.Net page. I would like to set the DataSource of the Gridview to a trackable collection of Entity Framework objects. I though the code should look like this:
this.gvMyGridView.DataSource = entity.MyDetailedItems;
this.gvMyGridView.DataBind();
But this doesn't display any data.
I am using self tracking entities and the MyDetailedItems is a navigation property to rows from another table.
View 2 Replies
Feb 28, 2011
I'm trying to have a View where the user can add items in a collection without having to go to a new View (the scenario is a sort of CV site where the user adds info about work experience, skills, etc, and it would seem absurd to go to a new View to add each little thing).
So I have an edit View that shows a number of text boxes for the already added items, and there's an ajax call to go to a method to fetch the collection fresh if the user adds an item.
Here are the methods in question:
[code]....
View 1 Replies
Aug 6, 2010
I'm new to LINQ and EF and I seem to be having trouble working this out.
I have a many-to-many relationship between my Location and Region tables. When adding or editing a Location, my interface allows the user to check any number of related Regions. If they click OK, I need to add any new relationships that were checked, and delete any existing relationships that have been unchecked. My basic code is shown below.
However, this code doesn't work. Lower down, the line location.Regions.Contains(region) returns false even when the location already is related to the region. The issue appears to be because the region is from my populated listbox that was initialized earlier and is no longer part of the current EF context. But if I try and add it, I get an error that there is already a Region with that ID.
It seems like what I want to do is change this line to something like location.Regions.Contains((r) => r.RgnID == region.RgnID) so I'm only testing for a particular ID. But this gives me the error "Cannot convert lambda expression to type 'TrailCalendar.Region' because it is not a delegate type."
I don't understand this error but, either way, I'm not sure how I can test if the relationship already exists without reloading a bunch of data, which I'd like to avoid.
View 1 Replies
May 29, 2010
I need to check if any rows are returned in a QueryString here's what I have so far.not sure what code to put to see if the row count is greater than 1
private void BindDataToGrid()
{
//MessageBoardEntities3 is ThemeableAttribute connection string name
int TID = Convert.ToInt32(Request.QueryString["ThreadID"].ToString()); // if Post ID is int
var context = new MessageBoardEntities3();
gvPosts.DataSource = from p in context.Posts
where p.ThreadID == TID
select new { p.Post1, p.PostID };
gvPosts.DataBind();
lblNoPosts.Text = "No posts found for this thread.";
}
View 1 Replies
Apr 26, 2010
I am having an issue when trying to update a ModifiedDateColumn in the database via LINQ. I am setting the ModifiedDate property (which is a DateTime in both SQL Server and my code) using DateTime.Now. I am getting an error where LINQ is generating too many precisions when generating the SQL to execute. Here is what the LINQ is generating (see @p3 & @p5)
[Code]....
How do I get LINQ to only generate to only 3 decimal places?
View 1 Replies
May 27, 2010
Is there built in methods into .net framework to do the following:
Get role GUID from user name/user GUID
Get role name from role GUID
So far I have been sending queries to the asp_roles and asp_users tables to obtain that information and I'm wondering if there is a nicer way of doing this?
I have the following methods that I store in the ASPUtilities class:
getRoleGUID(guid userGuid) { LINQ joins }
getRoleGuid(string userName) { LINQ joins }
getRoleName(guid roleGuid) { LINQ joins }
EDIT:
I have just looked into extending SQLMembershipProvider examples.
Few examples completely override the SQLMembershipProvider, but I think what I'm interested is just adding few extra methods to deal with the roles by using LINQ. Is this feasible?
View 1 Replies
Dec 24, 2010
We 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?
View 2 Replies
Feb 20, 2011
I want to be able to update a model and all its collections of child objects in the same view. I have been referred to these examples: http://haacked.com/archive/2008/10/23/model-binding-to-a-list.aspx and http://blog.stevensanderson.com/2010/01/28/editing-a-variable-length-list-aspnet-mvc-2-style/ .
For example, I have an object Consultant, that has a collection of "WorkExperiences". All this is in an Entity Framework model. In the view, the simple properties of the Consultant object is no problem, but the collection I cannot get a textbox to show up for. I tried following the examples in the links above, but it doesn't work. The problem is, in those examples the model is just a list (not an object with a child list property). And also, the model again is an EF model. And for some reason that doesn't seem to work as in those examples.
[Code]....
This stuff with the EditorTemplate works fine in Phil Haack's sample project, which I downloaded to try, but here, with the EF model or whatever the problem is, I don't get any textbox at all. The table in the view is just there as a test, because in the table I do get the rows for WorkExperiences, whether I add an empty WorkExperience object or fill out its properties doesn't matter, the rows show up for each object. But again, no textbox...
View 2 Replies
Sep 28, 2010
In an MVC view, I'm looking for a way to determine if a parent entity's collection of child entities is empty, so I can decide if I need to call a RenderPartial() or not.
For a one-to-one I've been using the following:
<% if (Model.Book.GenreReference.EntityKey != null) %>
{.....}
but I'm unsure how to do it in a one-to-many scenario, or if it can even be done without the use of Include() or Load().
View 2 Replies
Aug 12, 2010
Imagine I have 3 classes (student has Marks which has subjects)
[Code]....
I got a List<Student> populated with all the student and nested collection of corresponding Marks and subjects.How do I, before binding this list to any grid, filter records to display only those students, who surely have appeared in subjects with name "X" and "Y"?I tried something like:
[Code]....
View 2 Replies
Aug 8, 2010
I've got a linq to sql query that pulls data from 2 different tables and contains an or statement:
[Code]....
The problem I've got is that some queries match both sides of the or statement so it returns the same record twice.
How can I eliminate these duplicates quickly and easily?
View 3 Replies
Feb 8, 2010
I'm attempting to further reduce a dataset/table by various user input. Part of this process is grouping the data by a timestamp prior to a summation. I'm trying to use LINQ and cannot get the data returned that I need.
[Code]....
View 7 Replies
Sep 4, 2010
I have the code below could to rewrite from LINq to SQL to Linq to Entity.
[code].....
View 1 Replies
Mar 13, 2011
I'm constructing a query using linq, but I'm having trouble using a collection, i.e. where field in database = anything in the collection.
Below is an example of what I mean:
dim keywords as string ="test,test2,test3,cats,dogs,frogs"
Dim getKeywords = (From cp In myDataContext.pages
Where cp.pageKeywords = currentPageKeywords.Split(",")
The aim of the above code is to return all records where the "pageKeywords" field contains 1st keyword, or 2nd keyword, or 3rd keyword etc.
View 5 Replies
Jul 28, 2010
is there a way to update a column for all rows in a collection using linq like sql does it
eg. UPDATE myTable SET myColumn='newValue'
Also weighing options as to whether there is better performance using linq to sql for this or straight sql to DB via table adapters etc.
View 2 Replies
Aug 18, 2010
I have a bunch of news articles and I want to select the most recent one using Linq to Sql. I have an MVC action method like so
[ChildActionOnly]
public ActionResult LatestNews()
{
var article = mhndb.NewsArticles.Single();
return PartialView("LatestNews", article);
}
I would like to know the syntax for selecting the most recent item in the NewsArticles collection using Linq.
View 2 Replies
Aug 13, 2010
I'm new to LINQ and have a problem with my query not showing me the Table Collection. I manually created my Cart class and specified the table attributes on each property (works fine for inserting records via LINQ see below). DataContext dc = new DataContext(Conn);
var q = (from c in dc.NOTABLES?? where ((c.UserID == userID)) orderby c.CreateDateTime Based on examples I would expect to see dc.Cart But I don't, so I tried to access it via dc.GetTable<Cart>() which at least gets me data but doesn't seem to convert the rows to my Cart object since this:
foreach (var cart in q) Log.Info("UserID: " + cart.UserID + " CartID: " + cart.ID.ToString());
blows up with a "Specified Cast is Not Valid" exception.
No Problem Inserting Also, I had no problem inserting data into the database:
DataContext dc = new DataContext(Conn);
Table<Cart> Carts = dc.GetTable<Cart>();
Cart aCart = new Cart();
aCart.UserID = userId;
aCart.Description = description;
aCart.CreateDateTime = System.DateTime.Now;
aCart.UpdateDateTime = System.DateTime.Now;
Carts.InsertOnSubmit(aCart);
Carts.Context.SubmitChanges();
View 1 Replies
Apr 5, 2010
I have a partial class extending my Entity Model. I'd like to write a method that returns a collection of types from my entity framework model. For example, I'd like to get all the states to populate a drop down list. So I've written a method called getallstates(), similar to the example below:
[Code]....
I tried returning a list of Objects, and a list of states to my calling method to be used to bind to a drop down list. However I get an error that:
Server Error in Application. Unable to cast object of type 'System.Data.Objects.ObjectQuery to type 'System.Collections.Generic.List`1[System.Object]'.
What should my return type be for this function?
View 2 Replies
Dec 16, 2010
I'm new to linq. here is the scenario i need to write query for.I have a "Candidate" table with a varchar property "Skill"I have the table OR-mapped with LINQ to SQL on dbml file. Now I want to write linq query that:Selects all Candidates that have skill containing any of the keywords from ("asp.net","php","java")
View 1 Replies
Mar 21, 2011
Whats the best method to use with MVC? Entity Framework or LINQ to SQL?
View 4 Replies
