.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Serialize the linq to sql entity

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :ASP.Net
 

Hello,

Please help in following error


Type 'System.Data.Linq.ChangeTracker+StandardChangeTracker' in Assembly 'System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' is not marked as serializable


have read all threads but still cant solve the error.

I can do insert update and delete but dont know where exactly the error occurs and how??






View Complete Post


More Related Resource Links

SOA Data Access: Flexible Data Access With LINQ To SQL And The Entity Framework

  

Building a data access layer using LINQ to SQL and the ADO.NET Entity Framework allows you to decouple your application from the persistence technology you're using.

Anthony Sneed

MSDN Magazine December 2008


VS 2010: no Entity Framework or LINQ support for SQL Server 2000 SQLOLEDB connection?

  
Hello, I'm working with Visual Studio 2010 and for Data Connections am connecting to a SQL Server 2000 production database. When I try to drag a table to a .dbml file, the Object Relational Designer says, "The selected object(s) use an unsupported data provider."If I try to create an .edmx file via Generate from database, then the alert is, "This server version is not supported. You must have Microsoft SQL Server 2005 or later."So VS 2010 has no support for the Data Entity Framework or LINQ when connecting to a SQL Server 2000 database? If that is the case, what is the best data access strategy for this scenario?  

How to setup Query Result Shaping for LinQ to SQL instead of Entity Framework?

  
Hi, I am new to this, and I am trying to implement a linq query similar to db.Genres.Include("Albums") command from mvc music store using my current DB setup. I realize that the tutorial mentions Checlking the "Include foreign key columns in the method" when creating the tables in ADO.NET, but if I am using LINQ to SQL classes, then how can I obtain the same effect. And how do I use db.Genres.Include("Albums") to simplify my life? Thanks

When to use views and sp with linq entity framework?

  
Hi, When do I need (/ best practice) to use views and stored procedures in my database when using linq with the entity framework?Can you give me example scenario's? Thanks!

LINQ to Entity - using join for multiple table

  

I have my SQL query which needs to be conerted to Linq to Entity,

select pfr_sa.SID,pfr_sa.SourceGroupID,tx.txroll_cadaccountnumber,tx.txroll_StreetNumb

Entity Framework - how to join tables without LINQ and with only string?

  

Hi all,

I have a question about Entity Framework. Please answer if you know answer on this. I have such query :

    String queryRaw =
        "SELECT " +
        "p.ProductName AS ProductName " +
        "FROM ProductEntities.Products AS p " +
        "INNER JOIN CategoryEntities.Categories AS c " +
        "ON p.CategoryID = c.CategoryID ";
   
    ObjectQuery<DbDataRecord> query = new ObjectQuery<DbDataRecord>(queryRaw, entityContext);
   
    GridView1.DataSource = query;
    GridView1.DataBind();



Particularly I want to join few tables in one query, but I can NOT use LINQ and can NOT use ObjectQuery with objects mapped to DB fields inside my query. Because each entity creates dynamically. So this is what i can NOT use :

http://msdn.microsoft.com/en-us/library/bb425822.aspx#linqtosql_topic12

http://msdn.microsoft.com/en-us/library/bb896339%28v=VS.90%29.aspx

The question is can I use something like this instead of using objects?

query.Join ("INNER JOIN CategoryEntities.Category ON p.CategoryID = c.CategoryID ");

Is there a way to query entity based on multiple filter criteria? WCF Data Services, Linq to Entiti

  

Instead of:

DW_CMSOPEN dwc = new DW_CMSOPEN(new Uri("http://acctdev02/WCFDataService/EmployeeService.svc"));

dwc.Credentials = System.Net.CredentialCache.DefaultCredentials;

var employees = from emp in dwc.Employees 
             where emp.DEPT == "123"
             select emp;

I'd like the linq query to resemble:

var employees = from emp in dwc.Employees
              where emp.DEPT // in {"123", "456", etc}
              select emp;

Entity Framework vs LINQ to SQL

  

what is diffrence between

Entity Framework and LINQ to SQL

i cant yet find a good  blog on this

i have read that in LINQ to SQL only one to one mapping is possible

but Entity Framework allowes many , is it right? if so i dont understand this





How use sum in Entity Data Model with linq?

  

hi

i have a database with 4 table aspnet_Users, Forum, Topic, Post thay are related:

aspnet_Users with Topic by UserId

Forum with Topic by ForumId

Topic with Post by TopicId

i created a linq to get data from Database like:

Dim db As New MelorinEntities()
        Dim Topics = From t In db.Topic _
                     Join u In db.aspnet_Users _
                     On t.UserId Equals u.UserId _
                     Where t.ForumId = _ForumId _
                     Select t.UserId, t.TopicId, t.Name, t.IsLock, t.NumberOfView, _
                     u.UserName


 

 now i need to get also how meny post are in a topic but i don't know how to write the querry

can you please help me?

thanks

 


Performance with Linq-To-Entity and Linq-To-SQL Classes.

  
As Entity framework gives us more flexibility than Linq-to Sql but its more complex to implement. so in any Scenario of Project Development Who will be the Good Performer Other than its Complexity issue. why should Entity Framework is Used than LinQ-To-SQL Classes. just because of it provides flexibility to deal with Multiple Databases. We can also implement it on Database side, even up till Now Application was Develop on the Same Model.

can any one help me how to use asynchronous call from linq Entity to sql in WPF.

  
can any one help me how to use asynchronous call from linq Entity to sql.
 when i click search i am calling background worker, on the back ground worker
 i want to call asynchronous method with database(because in my database i have too much value)
i am using linq entity frame work.when i click cancel button asynchronous will should stop .
can any one help me

joby James

can any one help me how to use asynchronous call from linq Entity to sql.

  
can any one help me how to use asynchronous call from linq Entity to sql.
 when i click search i am calling background worker, on the back ground worker
 i want to call asynchronous method with database(because in my database i have too much value)
i am using linq entity frame work.when i click cancel button asynchronous will should stop .
can any one help me

joby James

An Entity Relationship Diagram Example

  
An Entity Relationship Diagram conveys a lot of information with a very concise notation. The important part to keep in mind is to limit what you're reading using the following technique:


Choose two entities (e.g. Company and Employee)
Pick one that you're interested in (e.g. how a single Company relates to employees)
Read the notation on the second entity (e.g. the crow's feet with the O above it next to the Employee entity).

Multiple database support with Entity Framework

  
One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Binding WPF Controls to an Entity Data Model

  
In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Playing with Linq grouping: GroupByMany?

  
One of its features is grouping. Many people understand grouping like it is defined in Sql. Linq is implementing grouping quite the same way. Let's discover this syntax and how to make consecutive groups easier.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend