Browse by Tags

All Tags » Entity framework (RSS)
30 January 2011 14:12

Entity framework support for table valued functions and thus full text

One of my most popular posts with over 10, 000 hits is how to enable full text when using LINQ to SQL http://sqlblogcasts.com/blogs/simons/archive/2008/12/18/LINQ-to-SQL---Enabling-Fulltext-searching.aspx , core to this is the use of a table valued function...
Posted by simonsabin | 2 comment(s)
Filed under: , , , , ,
12 March 2010 23:27

ORMs - Should DBAs just lighten up?

I did a presentation at DDD8 on the entity framework and how to stop your DBA from having a heart attack. You can find my demos and slide deck here http://sqlblogcasts.com/blogs/simons/archive/2010/01/30/Entity-Framework-how-to-stop-your-DBA-having-a...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
31 January 2010 18:53

DDD 8 Entity framework follow up - Will cast(column as int) allow use of an index

I pointed out yesterday that the EntityFramework doesn't like smallints. Well it does and it doesn't The model handles them fine and the objects have datatypes of int16 which is great. However the queries that are generated do this odd thing with...
Posted by simonsabin | 2 comment(s)
Filed under: ,
30 January 2010 14:30

Entity Framework how to stop your DBA having a heart attack

My code and presentation from my session at Developer Day 8 are now available here DDD_8-Entity_Framework Code Entity framework presentation Any questions let me know. Also for more on the new features in Entity Framework v next go to http://blogs.msdn...
Posted by simonsabin | 9 comment(s)
Filed under: , , , , , ,
02 January 2010 15:52

Entity Framework - MergeOption.NoTracking and CompiledQuery.Compile

Two things that people tell you about Entity framework performance are, use the Compiled Queryies and potentially remove tracking when its not needed. You can achieve this by using the CompiledQuery.Compile function to obtain a function that is your compiled...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
16 November 2008 00:16

Whats the score with LINQ to SQL?

LINQ to SQL (and any ORM for that matter) has the marmite factor. You either love it or hate it. Whats more many of those that hate it haven't tried it. In many cases the hate it crowd are making a decision based on previous experience with systems...
Posted by simonsabin | 7 comment(s)
Filed under: , ,