Please help me solve my big problem.
in my on-line shopping project i created a dynamic Category List (with Infinite Level Depth) Implemented in a Single Table in DB with Self join.
the schema is like below:
(source: aspalliance.com)
I am setting the Address of a class generated by Linq 2 Sql and when I try to SubmitChanges(), the sql query it generates is:
Normally when you update an object in linq2sql you get the object from a datacontext and use the same datacontext to save the object, right?
Is there a way to search all properties (without pulling all objects into memory – which I assume means building a list of each object’s properties with reflection, stringifying them, and then checking is out)? If not, this seems incredibly cumbersome as I’d have to build new logic for every new property I might add. Something like s.Contains(textFilter) in the above would be ideal.
public static void MyFunction(MyErrorClass err) { var query = from filter in DataContext.ErrorFilters select filter; query = query.Where(f => err.ErrorMessage.Contains(f.ErrorMessage)); List<ErrorFilter> filters = query.ToList(); //…more code } So I’m having some issues with the above code, and I’m getting the error from the subject line at the line with query.ToList(). Here’s what I’m trying to … Read more
I am very new to linq to sql and I am not sure how to actually delete a record.
I am trying to insert a new entity using LINQ-to-SQL, and entity is associated with a User entity. The insert of the new entity is successful, but my existing User entity gets inserted as if it were a new User. The code looks something like the following:
I’m currently building a .net web application that uses WCF web services to allow a Flex front end to access the database.
I have a database and I’ve created a DBML Linq-to-SQL file to represent this database. I’ve created a new aspx page and dropped a linqdatasource and a formview control onto it. When I configure the linqdatasource it gives me the choice only to select * from one table…but I want to pull from multiple tables. e.g. I have tables like simple_person, simple_address, simple_phone, and I want to pull from all of them. How can I accomplish this?
I am trying to make an Inner Join on 2 columns with Linq to SQL as a Lambda expression. The normal query would look like this.
