Review – 70-516 Exam Accessing Data with Microsoft .NET Framework 4 Preparation Kit from uCertify
Categories: Entity Framework, General Tags: .NET Framework, MCTS, microsoft, uCertify
Reviewing Exam- 70-516 Accessing Data with Microsoft .NET Framework 4 PrepKit from uCertify
I have got a offer from uCertify to review their PrepKit and I have accepted that challenge and now I am reviewing 70-516-CSHARP: TS: Accessing Data with Microsoft .NET Framework 4 PrepKit from uCertify. Initially it looks very simple and easy to use and learn . As soon as I am done with the full review I will post it for you all . In this blog post , i will be sharing some information about uCertify and the MCTS Read More....Categories: Entity Framework, General Tags: 70-516, PrepKit, uCertify
Entity Framework 4.3.0 Beta 1 Released
Microsoft’s ADO.NET Team announces the release of Entity Framework 4.3.0 Beta 1 which includes a number of bug fixes for DbContext API and Code First . The current release is also about integrating migrations in to the Entity Framework Nuget package . Microsoft’s ADO.NET Team also announced the plans that the current release is the last pre-release version of migrations and the next release will be Enti Read More....Categories: Entity Framework Tags: ADO.NET, Entity Framework, microsoft
Using Aggregate Function on Arrays in C#
If you have got an array of integers and you want to multiple the values inside the array and display its value without using for loop , here’s one of the ways to achieve it using the LINQ and Lambda expression . Assuming the array of integer has the following values int[] marks = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }; You can multiply each of the values inside the integer array without using any for loop or fo Read More....Categories: C#, Entity Framework Tags: Aggregate Function, c#, LINQ
How to order by multiple columns using Lambas and LINQ in C# ?
Today , i was required to order a list of records based on a Name and then ID . A simple one but i did spend some time on how to do it with Lambda Expression in C# . C# provides the OrderBy,OrderByDescending,ThenBy,ThenByDescending . You can use them in your lambda expression to order the records as per your requirement . Assuming your list is “Phones” and contains the following data … public clas Read More....Categories: C#, Entity Framework Tags: c#, lambda, LINQ
LINQ Equivalent of SQL’s “IN” keyword
I came across the requirement to use the “IN” equivalent of LINQ when using Entity Framework . I am sure most of the .NET Developers would also have come across a situation to use “IN” in LINQ . Here’s an example . The SQL Query looks like this SELECT * FROM MOVIES WHERE MOVIENAME IN ('Velayutham','Nanban(3 idiots)','Pagalvan','Yohan Adhyayam Ondru','Maalai Neram Mazhaithuli') When Read More....Categories: .NET, Entity Framework Tags: c#, Entity Framework, LINQ, LINQ to SQL, Upcoming movies, Vijay
.First() throws Error in LINQ or Entity Framework Queries
I use .First() method in some of the Entity Framework LINQ queries to return only one record . This works perfectly similar to the select Top 1 statemnent in SQL . Eg : var data = (from m in Employees where m.Name == "Senthil" select m).First() But , there is an issue with this . Assume your LINQ Query does not contain any Records or the SQL Statement ( TOP 1 ) does not return any records . What would Read More....Categories: .NET, C#, Entity Framework, Visual Studio 2010, Windows Application Tags: Entity Framework, Error, First, FirstOrDefault, LastOrDefault, LINQ, Top
Not supported in LINQ to Entities and Entity Framework ..
I was forced to explore something interesting when i was playing around with the Entity Framework and executing the below LINQ query. EmployeeEntities entityContext = new EmployeeEntities(); var Records = (from m in entityContext.Employees Select m).LastOrDefault(); My assumption was that the result would be the last record in the table .. But to my surprise , it threw an Exception LINQ to Entities does not re Read More....Categories: .NET, C#, Entity Framework, Visual Studio 2010 Tags: .NET, c#, Entity Framework, expression, LastOrDefault, LINQ, LINQ to Entities, MSDN, SQL, store, Visual Studio 2010
Caught up with Bugs in My Favourite IDE ( Visual Studio 2010 )
Well , for the last few months i have been facing some serious issues in running Visual Studio 2010 as a result of some error messages / bugs . Here are some of the messages / bugs that i was able to capture .For some of the problems i was able to find the fix/update from the Microsoft Connect website , but for others i am still hunting for one . 1. Catastrophic failure Puzzled , puzzled and Puzzled . Dont Read More....Entity Framework Feature CTP 4 Released
The Microsoft's ADO.NET team has released the latest Entity Framework Feature CTP,which is now available for Download from the Microsoft's Download center . Remember that Entity Framework 4 was released together with Visual Studio 2010 in April 2010 The new CTP is called as Entity Framework Feature CTP 4 that includes the early preview of the Code First features.
Categories: .NET, Entity Framework, Visual Studio 2010 Tags: ADO.NET, c#, Code First Feature, microsoft, Microsoft's Download center, Visual Studio 2010
