ADO.NET :: LINQ To SQL Is Better Or Enitity Framework?
Nov 2, 2010i want to know that which one is better and why? i am using LINQ to SQL. Ado.net Entity framweork (edml) is also using for the same purpose.
View 1 Repliesi want to know that which one is better and why? i am using LINQ to SQL. Ado.net Entity framweork (edml) is also using for the same purpose.
View 1 RepliesWhats the best method to use with MVC? Entity Framework or LINQ to SQL?
View 4 RepliesIm working on a greenfield project and have to make a decision on the technology we'll use for the data access layer. Ive used LINQ to SQL for a few years and am happy and comfortable with this, but now with entity framework available this is another method to consider. Are there any pitfalls using entity framework as opposed to LINQ to SQL ? Ive read that there are performance issues with entity framework, is this true? Id really like to get an overall feel for using one method over the other, anyone have any thoughts/comments/recomendations?
View 1 RepliesI'm trying to learn MVC. Now I wonder whats the different between entity framework and LINQ TO SQL? Wich is the best to use and why?
View 19 RepliesIm new to development for the windows server platform. Can someone tell me the difference between Linq to SQL and EF4?
View 2 Replieswhat 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
View 3 RepliesCould any one explain me which ORM is best?
View 3 RepliesI have a new project where I want to use MVC (I will be learning as I code), and I have never used linq or entity (or mvc). Which should I use? Does it matter? I will be having a lot of different databases, from Oracle to FoxPro.
View 6 Repliesi have a table with a field name called 'Firstname' and another field name called 'Lastname'. I would want to have a single column in my GridView which show Fullname and then the firstname and lastname are showed here under an alias. Also, i am binding my GridView using LINQ.So is there a way to create aliaswith LINQ and to use these with GridView ? Would love to have an hint about how i can realize this task.
View 5 RepliesWhen do I need (/ best practice) to use views and stored procedures in my database when using linq with the entity framework?
View 8 RepliesI am tasked to build a web 2.0 style mashup application which consumes a lot of 3rd party webservices like youtube and twitter. There are also lots custom features which are going to be built using ASP.NET 3.5 and SQL Server 2008. Now I am looking for the right ORM for my needs. From a performance and ease of use standpoint can anyone suggest me the right ORM for this kind of web application?
View 1 Repliesi have 2 table missions and missiondays with a relationship 1..n
I want select all missions that has all missiondays with an attribute called "visible" = true
I've tried with:
db.TDP_Missioni.Include("TDP_MissioniDestinazioni").where(p => p.TDP_MissioniDestinazioni.visible == true)
But there is an error. Indeed from p.TDP_MissioniDestinazioni i don't see the table's attributes. I think it's because the relationship is 1..n.
know if the followin is supported in .net framework 4.0?I have a sql stored procedure with one of its parameter as Hierarchy data type( i suppose its a table valued parameter).. trying to drag this stored procedure onto my linq design studio is not being allowed?
View 1 RepliesBest way to show the SQL trace of a LINQ query to Entity Framework 3.5? I am using ASP.net and EF 3.5.
Dim dbo As Web.Portal.RBMEntities = New Web.Portal.RBMEntities
Dim Query = From RoleAllocations In dbo.RoleAllocations Where RoleAllocations.user_id = _ID And RoleAllocations.expire_date > Today Select RoleAllocations
Console write the SQL trace?
I have a question about Entity Framework. answer if you know answer on this. I have such query :
[Code]....
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 : [URL]
The question is can I use something like this instead of using objects?
[Code]....
The purpose is to use Join method of ObjectQuery with syntax as in Where method :[URL]
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 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?
I have a stored procedure that receives 2 parameters and returns 3 columns.
Here is how I added the SP:
1. Added SP to entity model (.edmx) via update model from DB.
2. Did a Function Import -- selected my SP, clicked "Get Column Information" and then created a new complex type (myStoredProcedureName_Result) which I assigned.
3. My LINQ is the following:
[Code]....
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?
I have a web app for our golf club. When I compute handicap index for each golfer, I have to select the most recent scores and then a subset of those scores depending on how many rounds of golf the golfer has played. All the scores are entered into a single SQL Express table called "Rounds". Verbally, this is what I'm trying to do:
1) select the twenty most recent golf scores (sort on date descending, "take(20)") [if less than 20 records, then select all available];
2) for this set of records, select the 10 lowest scores (or smaller number if golfer has less than 20 rounds);
3) compute the average round differential for the subset of records, etc. to calculate handicap index (this step is working ok...)
My current VB code has this LINQ query (which is flawed -- it selects the lowest handicap differential scores of ALL records for the filtered user):
[Code]....
How do I modify this query to accomplish items 1) & 2) above? It seems this should be simple, but my experience with queries is still limited.
I host a website that has recently been upgraded from .NET Framework 2.0 to .NET Framework 4.0. Within the website, I have an instance of BlogEngine which still requires .NET Framework 2.0. Each website is in it's own application pool. My issue is that when I browse to the blog portion of my website, I receive a 500.19 error with the following information...
The configuration section 'system.web.extensions' cannot be read because it is missing a section declaration The web.conf file that is listed in the error message is the config file that belongs to my root website which is running .NET Framework 4.0. How do I get the two websites to run together in the same website using different versions of the .NET Framework?
I have this cenario:One server (machine) that have framework 3.5. And one site (website) developed for framework 3.5.This site can not be modified (rebuild in other FW version, or others changes).
I'll developer a new webapplication (WAP) in framework 4.0 (using microsoft visual web developer 2010).
As I know, the new webaplication work in the server, if I install framework 4.0 in the server.
My question is: Can I install the framework 4.0 on the machine that already have framework 3.5. And continue have sites working with other frameworks version?Or, should I develop my new webapplication in framawork 3.5 ?If I can install the framework 4.0, do I need make some specify configuration during the installation?
what is Features added in Framework 2.0 over the framework 1.1? i want in Details?
View 2 RepliesDifference between .net framework 2.0 and .net framework 2.0 with service pack 2
View 4 RepliesWe are developping with .net framework 2.0 on our dev station and we deploy on web server and client desktop a 3 tiers smart client app. what is the impact of ugrading to .net framework 2.0 sp2 on our web servers WITHOUT upgrading on dev station and compilation servers?
View 2 Replies