Tag | Entity Framework Posts

Had a great time on Tuesday (5th May 2009) at NxtGenUG in Oxford. A very friendly crowd, a fun user group and great to watch the banter between Alex and Barry first hand, rather than over twitter :-) I also won a rubber duck – which justifies working in the evening in my book :-) Useful links: MSDN Flash eBook 13 of the “Best Technical Articles of 2008” (also http://bit.ly/flashebook1) MSDN Flash Podcast Pilot For feedback (also http://bit.ly/flashpod1) http://blogs.msdn.com/efdesign The Entity Framework ...
I’m very pleased to see that DataDirect have a beta of their Connect for ADO.NET Entity Framework provider for Oracle which now adds support for the ADO.NET Entity Framework. Still in Beta (1st may 2009) and available for download. Enjoy (and feedback what you find – tx) P.S. Other companies also provide this capability – but I know a lot of folks use DataDirect for Oracle work ...
Dynamic query building is most often used in the enterprise world for search screens and other operations. I remember writing code very tediously night and day for a very big search screen. Those days where the nightmares, but good experiences we got. Now these things are made very simple by means of Microsoft's Ado.Net entity framework. ADO.Net Entity Framework is an ORM extension from Microsoft. This is something similar to Linq to Sql . But this one is having some good features and we will be ...
Julie Lerman is one of the hippest, smartest people I know. If you haven’t already heard of her, this is your chance to crawl out from under that rock and get a glimpse of an industry legend. Don’t worry about that giant ball of fire in the sky, that’s just the sun. Those of you that HAVE heard of Julie probably already know how awesome she is, but keep reading anyway. My first introduction to Julie was hearing Bill Ryan refer to someone as “Julie Lerman smart.” I figured that was enough of a recommendation ...

A few weeks ago I did a a presentation on LINQ and ADO.NET Entity Framework for the VISUG at Microsoft Belgium. Want the code and presentation ?

Downloads : code and presentation

Hi All,

I am happy that i will be writting some posts on .Net Ria and Silverlight 3. I will also be posting some detailed articles on Entity Framework and ADO.Net Data Services. So keep checking my blogs and articles.

Thanks,
Thani

Anyone that is working frequently with either LINQ to SQL or the Entity Framework needs to go get a copy of the Huagati DBML/EDMX tools. They plug right into Visual Studio (2008) and allow you to perform many of the tasks that you would think VS would do for you. I just recently had a new dev db get corrupted. I had no backups for it. I also had no scripts generated for it. Argh! What to do? With this tool I was able to reverse engineer my EDMX file and spit out all the SQL I needed to generate the ...
Today I presented ‘LINQ to SQL compared to LINQ to Entities’, a session for the VISUG at Microsoft Belgium. Attendees asked me how one can see the T-SQL statement that LINQ to SQL or the Entity Framework is generating out of the LINQ Query. For LINQ to SQL : Use the log property of the context to redirect the generated query to the output window of Visual Studio. using (MyLINQToSQLClassesDataContext ctx = new MyLINQToSQLClassesDataConte... { ctx.Log = Console.Out; var q = from c in ctx.Categories ...
While beginning a new project for myself, I decided to use the Entity Framework by building my entities first then creating the database required to support the entities I need. When I reached the stage where I had to map the relationships to the database, I wasn't exactly sure what to put in. I eventually figure out that I need to set the table mapping to the table with the many multiplicity, then set the tables to their corresponding keys in that table. I originally set them to the same key before ...
Now I know that the Entity Framework has a disconnected data access model i.e. connections to the database and opened and closed only when you retrieve data that has not been retrieved or you explicitly request a call to the database or you call SaveChanges on the ObjectContext. I was really surprised to find that inspite of disposing the ObjectContext, there was still an active connection maintained to the database. The following code fragment shows the typical usage for ObjectContext. Right after ...
If you don’t know what eager loading is, Jump to “What’s eager loading?”. Eager Loading Syntax If you are eager loading Products for example in a typical (Categories 1<->* Products) relation, the standard syntax would like: DbDataContext.Categories.In... What is the problem with that? The “Products” part. The word “Products” is a string. If I rename the Products table to ShopProducts or whatever or even remove it from this data diagram and have it elsewhere, or even something ...
I just had this error where entity framework was complaining about my object already being referenced by the data context that I originally got the object from. In LINQ to SQL I guess this was just taken care of for me. I would get the object in a using statement so that the data context was cleared when I was through with the context. Then I could do what ever I wanted to with the object after that – to include throwing it back to the database. I came across the fix to this issue here: http://social.msdn.microsof... ...
Having been asked 5 times today for recommendations, I figure this post is long overdue: There are several books out there but IMHO these are the two you should purchase. Julia is focused entirely on Entity Framework (all 800+ pages!) and Roger takes a broader look at ADO.NET3.5 but does a great job on Entity Framework. Programming Entity Framework by Julia Lerman (Author) and Professional ADO.NET 3.5 with LINQ and the Entity Framework by Roger Jennings (Author) ...
Today I delivered a session introducing Entity Framework at www.devweek.com. I expanded the session to include a brief overview of the new stuff we should expect (but I don’t guarantee) will ship in .NET Framework 4.0 with Visual Studio 2010. First up, some useful links: Main ADO.NET Entity Framework site including “How To” videos Well written overview article My previous posts on Entity Framework Entity Framework v2 features http://blogs.msdn.com/efdes... ADO.NET team blog including plenty on the ...
Yes, you were not mistaken, having read title. Now we will look how it is possible to work with data from SQL Compact using ADO.NET Data Services. Important remark. Actually, SQL Compact not absolutely correctly to use together with ADO.NET Data Services. SQL Compact initially is not focused on a mode of the multiuser work and it is intended for other purposes – for use as local storage. Using SQL Compact as storage for ADO.NET Data Services can negatively affect productivity of your web service. ...
As a rule, ADO.NET Data Services works over ADO.NET Entity Framework data model. However, work with real projects (and customers:)) sometimes specifies to us other conditions. Frequently there is no necessity to use Entity Framework. And in this case we start to think of use LINQ-to-SQL as data model. In earlier versions of ADO.NET Data Services it is has been simple – create data model, create web-service and it works! When ADO.NET Data Services released, the situation has been changed – at construction ...
Next week (23rd March 2009) I am speaking at DevWeek 2009. DevWeek is a great conference which attracts top notch speakers (plus me – I feel such a fraud whenever I present there!). It is IMHO the best developer focused conference we have in the UK and I can’t wait to get there and soak in the great sessions + catch up with familiar faces + meet plenty of new ones. Be warned. There is a rumour that we are being given some new toys (Flip video cameras) to play with while we are there. However don’t ...
I recently delivered MSDN Day talks on Visual Studio 2010 and .NET 4.0 as well as WPF and Silverlight 2. The presentations for the sessions can be downloaded from MSDN Presentations Drop a comment if you have a question or face issues in getting the PPT. Meanwhile, the PPT is just a flow of slides that helped with my presentation and there were a lot of Demos that I delivered as a part of the sessions and I am giving here below the reference links for the Demos (Some of them are from www.asp.net ...
[Don’t forget to vote on what your experience has been with the Entity Framework in my marmite poll :-)] I get asked a lot about performance of our two ORMs against each other and against standard ADO.NET. The short answer is “Normally it is good enough. When it is not good enough, you need to do something to make it good enough” My slightly longer answer is “In general LINQ to SQL performs better on query, LINQ to Entities performs better on updates” But – people like numbers, tables and comparison ...
Last week I gave a talk at Qcon London entitled ORM, EDM, ESQL, Entity Framework, LINQ to SQL, LINQ to Entities - confused? In the session I wanted to make a few points worth summarising here: ORM usage by Windows Developers is low compared to other platforms I believe this will change significantly now Microsoft has an offering ORM can be very productive but also dangerous I showed a demo which looked at lazy vs eager vs explicit loading vs projection Entity Framework is more than an ORM – the ORM ...
I wanted to thank the many speakers that came out to the Winnipeg Code Camp this past Saturday. Everyone did a great job, and the investment to the community was greatly appreciated. I was able to record a few videos of some of the speakers, and wanted to highlight the others who I didn’t get a chance to interview. Aaron Erickson – Magenic Al Williams – Sunset Hill Solutions Al has been a great supporter of the Winnipeg developer community, presenting at the .NET User Group and at our recent code ...
14 marca 2009 odbyla sie darmowa (a jakze!) konferencja Community 2 Community, jednak z racji faktu, ze na poprzedniej mnie nie bylo, moge opisac jedynie tegoroczna edycje. Najwiekszym problemem byla rejestracja internetowa – konkurencja byla niesamowita, w turze zamknietej dla grup miejsca na sciezke .Net skonczyly sie w kilkadziesiat minut, a w turze otwartej dla wszystkich w okolo 10 minut. Lokalizacja konferencji Sama konferencja zaczela sie od rejestracji – juz podczas niej dal sie we znaki ...
ADO.NET Data Services 1.0 was released with .NET Framework 3.5 SP1 and early adopters were impressed with the combination of power and simplicity for exposing RESTful web services in front of ADO.NET Entity Framework (or pretty much anything with a bit/lot of work). However, those same early adopters soon created a long wish list of features they would like the team to add. The good news is they (and you) won’t have to wait until .NET 4.0 to see them included. The team has announced that there will ...
Recently I've started working more and more with the ADO.NET Entity framework and I must say that I like it a lot. There are folks who absolutely love EDM and folks that think its really evil. It's still a v1.0 product and I treat it as such. The designer does leave a lot to be desired.A lot of bells and whistles will be added to the VS 2010 release to address a lot of the designer "desirables". It's not been an easy buy in at work for adopting EDM, but my team has been among the first to have adopted ...
Chippewa Valley .Net User Group Tuesday, Mar 10, 2009 at 05:00 PM Location: GreenMill Restaurant Directions Generating code for large-scale architectures is a complex topic. This talk will discuss ways to integrate the ADO.NET Entity Framework into your architecture’s code generation process and have it perform the “heavy lifting” in your Data Access Layer. We will cover an introduction to the framework itself and discuss some of the potential pitfalls (and how to avoid them) when using it in large-scale ...
I started looking at the latest the EF team had to offer and while things have progressed immensely over the years it appears that there is still some room for improvement. Given the turmoil over the possible demise of LINQ to SQL I know that the use of Entity Framework is inevitable for me and probably just around the corner. With my newest project I have started to plug in an ADO.NET Entity Data Model (EDMX) where I would normally plug in LINQ to SQL Classes (DBML). I still dropped the file into ...
Last month I wrote about two conferences coming up soon in Poland. Organizers were busy all the time working on providing you with greatest speakers and technical content, and today we know the full agenda of both events. 4Developers, 7th March, Kraków Here is the agenda for .NET track: Ted Neward - Busy .NET Developer’s Guide to F#: Introduction Marcin Celej - Wykresy przy uzyciu biblioteki .NET Charts Szymon Pobiega - Inversion of Control w systemach zbudowanych w oparciu o obiektowy model domeny ...
Today I delivered a session on the ADO.NET Entity Framework as part of a “Battle of the ORMs” session at the Developer Group in Reading, UK. Wasn’t really a battle, more a friendly get together over cake :-) Thanks to all those who attended and to the the other presenters – I learnt a lot! The main links I wanted to share are: Main ADO.NET Entity Framework site including “How To” videos Well written overview article My previous posts on Entity Framework Entity Framework v2 features http://blogs.msdn.com/efdes... ...
So, I’ve just hit a snag. It’s not a big snag, but it’s somewhat fundamental. I was happily going about my business. I’d gotten the Browse module up and running that was going great. I was about to start in on the Add or Voting module. In order to do this one, I’m going to actually need an implementation of the IGameService to exist. I hadn’t forgotten it, but I didn’t want to get mired in it until I had Browse up and running, since Browse didn’t really need it. When I went to implement IGameService, ...
Okay, so the next stage, I’m going to need some data in order to do stuff. I’m going to create three DLLs, all class libraries. They are: OscarsNight.Interfaces – The interfaces for the services and the business objects. OscarsNight – The actual implementation DLL, with some data access stuff. I think I’ll use Entity Framework for that. OscarsNight.Tests – A testing DLL that tests the implementation. Business Objects For the business objects, I’m going to create two sub-namespaces, one each for Game ...
Last year I had the pleasure of receiving a copy of the book Entity Framework Tutorial by Joydip Kanjilal from Packt Publishing and I recently got the time to read it so I thought I'd share my impressions on it. I have to confess to having great expectations from the book: it was from Packt, the publishers of the excellent Programming Windows Workflow Foundation by K Scott Allen and it was on Entity Framework, a topic which I had been meaning to read up on for a while. Like the WF book, EF Tutorial ...
location: At Lamar Advertising Wednesday, January 28, 2009 5:45 PM - 8:00 PM Sponsored by: TBD Presenter(s): Brett James and Steve Schaneville Brett is a Senior Development Consultant at Sparkhound, Inc. with over 10 years of software development experience. The last 6 years have been spent working with .NET technologies for both Web and Windows applications. Steve is a Software Development Manager at Amedisys, Inc. His experience includes 9 years of C++ and C# development in Windows and Web applications. ...
You can find the PowerPoint for the FlaDotNet session that Max, Thom and I held at Citrix on 1/6/2009. http://www.fladotnet.com/Me... It was a fun session, everyone got involved. A number of topics could use more coverage… - Entity Framework and alternatives - Exception handling strategies and practices - Build automation and tool sets See ya next time ...
Ok, so I'm sitting in a session at DevTeach in Montreal right now... and someone mentioned to me that they didn't know of any Entity Framework Providers (outside of SQL) that had actually released yet... and I realized that I never got around to posting the links on my blog! The first Entity Framework providers were released at the beginning of September, by Devart (ADO.NET Blog post) to support Oracle, MySQL and PostgreSQL. More recently we've also seen releases of providers by Npgsql for PostgreSQL ...
If you're in the Kansas City area and you haven't heard about Kansas City Day of .NET (or KCDODN) then you're missing out. KCDODN is Saturday, December 6th at the Centriq Training center. (Go here to register...) Looks like 4 tracks of .NET Developer goodness, including a session by yours truly. GWB'ers Jeff and John will be there as well... so come say hi if you're there. Kansas City Day of Dot Net Development Architecture SharePoint Special Interest 8:00am - 9:00am Registration & Breakfast ...
DevTeach aims offers TechEd like content and high calibre, TechEd speakers to Canadians, without traveling all the way to the US! Check out sessions across 8 different tracks (including a couple of really great sessions by myself and Carl Perry on the Entity Framework and ADO.NET Data Services). This year the conference will take place in Montreal from Dec 2-4th. All TechDays attendees can receive $350 off the conference price and all Canadian user group attendees will receive $100 off the conference ...
I checked out Phil Haack’s MVC presentation this afternoon, and I’ve gotta say that Phil did a phenomenal job communicating the story behind the product. From establishing why the framework was created, how it fits in the ASP.NET strategy going forward, and explaining the how’s and why’s to an audience that more than likely was comprised of webform devs. Phil did a great example app as well, mimicking stackoverflow.com and providing a great real world example. However, as a great follow up, Jeff ...
(Sorry A blog post in Dutch about a software conference in the Netherlands) Vandaag (Maandag 6 okt) waren we met z'n 3 afgereisd naar het pittoreske Noordwijkerhout waar de SDN Conference werd gehouden, oftewel SDC. Op de SDC waren sessies over bijv .NET, Information worker, DotNetNuke, Delphi, Database, Architecture en User eXperience. De sessie waar ik vooral naar toe was gegaan waren de .NET/Architecture sessies. Voor vandaag stonden voor mij de volgende sessies op het programma. Ik zal niet te ...
The news took the community by surprise and the reactions are overwhelmingly positive: Microsoft is going to ship jQuery with the ASP.NET MVC framework (very soon) and with Visual Studio (in a near future). For more details, ScottGu and Scott Hanselman are talking about that in a very complete way. Read the rest of this entry » ...
MSDN Unleashed Session 1: Demystifying WPF Today’s applications need to do more than simply work. They need to draw in the user, and provide a differentiated experience. This means moving beyond battleship gray forms, boxy UIs, and providing a positive user experience. Windows Presentation Foundation (WPF) provides powerful capabilities to develop a compelling user interface, the kind that makes an application stand out. In this session, we’ll examine the core concepts of WPF such as layout panels, ...
I have decided I will be attending DevConnections November 10 - 13th in Las Vegas, NV DevConnections has a number of events running at the same time, with registration, you can attend any of these events - ASP.NET Connections - VS.NET Connections - SharePoint Connections - SQL Connections - DNN Connections - Exchange Connections - Unified Connections - Windows Connections Some of the speakers include Dino Esposito, Rick Strahl, Markus Egger, Robert Howard, Miguel Castro, John Papa, Julie Lerman, ...
Very Quick Note: Visual Studio 2008 Service Pack 1 was released finally (in combination with .NET Framework 3.5 Service Pack 1 of course). To sum up for some people, note that VS 2008 SP1 includes ADO.NET Entity framework (and its designer) as well as ADO.NET Data Services, but NOT ASP.NEt MVC framework (but does include ASP.NET Dynamic Data & ASP.NET AJAX history control and script combining). It also includes some WCF enhancements as well as major VS performance and scalability fixes. ISO Donwload ...
We've waited a good long while, but RTM is finally here for both the ADO.NET Entity Framework as well as ADO.NET Data Services! Both are now available as part of the Visual Studio 2008 SP1 (tools and runtime) and .NET Framework 3.5 SP1 (for just the runtime without tools) releases that were announced this morning. You can check out more information as well as the downloads at http://msdn.microsoft.com/data (keep checking back as I will continue updating content all week to reflect the releases) and ...
In case you have installed the .NET 3.5 SP1 and Visual Studio 2008 SP1 and are unable to find the Dynamic Data Website Template, you can install the latest version of the runtime from http://www.codeplex.com/asp... To explain it further, I had the December 2007 CTP installed which contained the Dynamic Data Runtime and Astoria, Entity Framework etc., All of these gets bundled into the .NET 3.5 SP1 Beta and you dont need the December 2007 ...
Do you know what I love about the .NET community? DRAMA! Not a day goes by that there isn't some blog post or Twitter discussion that occurs that gets everyone all riled up and motivated to speak their mind, debate, rage, and give us all something to talk about over beers. Sometimes its something that ends up being entertaining, but ultimately trivial or non career altering. But sometimes you get what's happening with Microsoft's Entity Framework. For those who haven't read it yet, or don't know ...
I came across the "ADO .NET Entity Framework Vote of No Confidence" at http://efvote.wufoo.com/for... today and thought this was something worth commenting on. Background I happen to find out about this petition in my regular read of "Never In Doubt", Ward Bell from IdeaBlade's blog. Ward Bell is, in my opinion, one of the leading experts in Object Relational Mapping and the Entity Framework. I have summarized some key information from him and the other ...
Taking a page from the Astoria team... We're opening up the EF :) Today really marked the beginning of our work on Entity Framework V2 and as part of that, we were able to extend the very successful transparent design process that we have been using for ADO.NET Data Services (Astoria) to the Entity Framework team. You can check out details of the process and learn more about how you can get involved and provide feedback in Tim Mallalieu's initial post, and of course you can check out all the upcoming ...
Imagine that every project in codeplex had to be decomposed into codeplex hosted unit tested functions which complied to some xunit standard - that would go along way towards code reuse, and move away from reinventing the wheel. worked on 2 Silverlight projects recently - see screenshots: and Last 3 months learned the following: NET Components revise – reread Yuval Loweys book – revised best mechanism for interface usage, delegates (circa .NET Framework 2.0), threading. The Interface stuff leads ...
Microsoft .NET framework 3.5 Service Pack 1 and Visual Studio 2008 Service Pack 1 now have public BETAs. The service pack of Visual Studio 2008 has really interesting stuff. Highlights I'm interested in are performance improvements in HTML editor, collection of JavaScript intellisense hotfixes plus new ones enabling better JavaScript intellisense for libraries like jQuery, JavaScript Code Formatting, ASP.NET Routing engine (the one used in ASP.NET MVC, it is actually developed as separate component), ...
The most recent versions of the ADO.NET Entity Framework Beta and ADO.NET Data Services Beta are now available! Both the Entity Framework and Data Services have now officially become part of the Visual Studio 2008 and .NET Framework 3.5 SP1 releases beginning with the Beta released this morning. These will also be the final Beta prior to the RTM of these two projects. For more information on these releases and on changes that have been since the last public releases, check out the ADO.NET Team and ...