|
I'm trying to decide what database system to use for my next project which will be using VS.NET 2008 and will likely have a bit of LINQ code in it. No LINQ support may be a dealbreaker for any database system. Is DB_LINQ mature enough to allow other DBMS...
Started by brian on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
If I needed a true OR/M solution using DBLinq....
Well there shouldn't be any problem using Linq to SQL for your OR/M needs.
LINQ to Entities works just fine with many non-SQL-Server DBs.
LINQ != LINQ to SQL.
|
|
Possible Duplicate:
Entity Framework vs LINQ to SQL
What is the difference between linq to entities & linq to sql?
Why linq to entities came into picture?
Started by Miral on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Linq to SQL is for direct queries using SQL Server, regardless of using Entity....
linq to entities is MS's new thing and will be replacing their linq to sql stuff.
linq to sql is being discontinued.
|
|
Is it possible to combine Linq-to-SQL and Linq-to-XML if a column of a table is XML?
Started by Lieven Cardoen on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Blogs.msdn.com/ericwhite/archive/2008/12/03/joining-linq-to-sql-and-linq-to-excel.aspx
Randy
If by "combine" you mean "have Linq to SQL translate the query into an actual SQL Server XML query" then I believe....
|
Ask your Facebook Friends
|
I have been using LINQ to query my POCO objects for some time, but I have not yet tried LINQ to SQL. I assume that LINQ to SQL queries are somehow converted to equivalent SQL queries and, given this, I am wondering if that affects the way LINQ to SQL ...
Started by GraemeF on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Basically....
LINQ to Objects person;
will compile fine, but fail at execution time because LINQ to SQL doesn't know what to do with GetHashCode() .
LINQ to SQL will use the column DB server's collation for Where and OrderBy .
|
|
I find I can do more with NHibernate, and even Castle than with the Linq to Entities, or linq to SQL.
Am I crazy?
Started by mrbradleyt on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
I've used both NHibernate....
One thing to bear.
NHibernate is a full OR Mapper, Linq to SQL and Linq to Entities don't (especially NHibernate.)
Linq to SQL is good for a light-weight, limited use ORM.
No you're not crazy.
|
|
Hi, I am using SQL Server 2005 in a project. I have to decide about datalayer. I would like to use LINQ in my project. I saw SubSonic 3 supporting LINQ and I also have option for LINQ to SQL, because i can have typed lists from LINQ to SQL.
I am wondering...
Started by Jamil on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Http://subsonicproject.com/docs/Comparisons
Outside of specific differences of the technologies....
In case you haven't read this already, the Subsonic site has a pretty lengthy overview of some differences between LinqToSql and Subsonic (and NHibernate) .
|
|
I am new to Linq world and currently exploring it. I am thinking about using it in my next project that involves database interaction.
From whatever I have read, I think there are 2 different ways to interact with databases:
Linq to SQL Linq to DataSet...
Started by Hemant on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
On my current project, we're using Linq to Sql at times in terms of extensibility....
I'd go to extend for more advanced/complex implementations.
You are correct about #1 - Linq to Sql will only work against SQL Server databases.
|
|
Can SQL Server 2000 be used as the database for LINQ to SQL?
Does LINQ to SQL rely on a specific version of Microsoft SQL Server?
Started by Nick on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Yes, LINQ to SQL works with SQL Sever 2000 with one exception: you do need the ROW_NUMBER() function, available only in SQL.
LINQ to SQL adapts the generated queries to work with 2000.
Yes, you can.
|
|
Is it possible to override the SQL generated by LINQ to SQL, for optimisation purposes?
Started by CraigS on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
This is useful if you want to leverage a function that's available in SqlServer but not in Linq (IE.
One way I have used:
Create a stored proc, use the linq to sql designer to drag the proc.
|
|
Is there any plans for Microsoft to support LINQ to SQL beyond MS SQL server?
Started by Ngu Soon Hui on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Microsoft offers Entity Framework as its cross-database....
The majority of code in LINQ to SQL is in the implementation of the SQL Provider.
LINQ to SQL beyond SQL Server and it wouldn't make much sense to do so.
|
