Using Stored Procedures That Return Non Entity Type

In  the previous post I explained how to use a Stored Procedure in Entity Framework that returns an Entity Type.  However, if you try to map a stored procedure that is of a scalar type or returns an Array or List type then this won’t work automatically with the current release of Entity Framework. In…

1

Using Stored Procedures in Entity Framework

Entity framework supports stored procedure. In this post I will explore how we can use stored procedures in entity framework. I have created a Windows based application with Northwind database model(EDMX) . And have the Customer and Orders table selected.   In order to add a stored procedure open up the Model Browser and right…

5

Getting Started With EntityClient in EntityFramework

In this post I am going to illustrate how to use EdmGen and EntityClient to program with Entity Framework. EdmGen is utility shipped with Entity Framework for creation of the artifacts required for Entity Model Mapping viz the CSDL(Conceptual Schema Definition Language), SSDL(Storage Model) and MSL(Mapping Model). Though you can use the EDM wizard in…

1

Retrieving Identity or AutoGenerated Column in ADO.NET

I recently handled an issue where customer was facing difficulty in picking up the Auto Generated primary key column in DataAdapter.Update() call. Looking around on the internet I saw many posts on the forums regarding how to get this value. So thought of posting it here There are 2 ways to go about this Using…

1

Web Client Software Factory-The Web Patterns

This post is in continuance with the last post  I had on WCSF. In this post I will briefly elaborate on various patterns in web development  and the general terms used to help you understand WCSF in a comprehensive way.   The View Presenter Pattern Asp.Net is a great web development platform that enables you…

1

Web Client Software Factory-The Concept

  In this series, I will help you get started with WCSF developed by Patterns and Practices team at Microsoft. If you are a web developer then this Software Factory will be of great help for you in your upcoming web projects. Let me start of with the basics in order to speed you up…

1

File IO System in .NET

I am preparing for MCTS Exam 70-536: Microsoft .NET Framework 2.0 – Application Development Foundation and came across the File IO System. So taking this opportunity here to post few details on the I/O streams to help understand the workings, specially for someone who is just getting started. The following diagram below describes the I/O…

5

Demystifying SQL-Oracle Distributed Query Issues

While running the following query distributed query select * from openrowset (‘OraOLEDB.Oracle’,’oradb’;’scott’;’pwd1234$’, ‘select * from emp’) I got the following error message : Msg 15281, Level 16, State 1, Line 1SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries’ because this component is turned off as part of the security configuration…

2

C# 3.0 Features Basics For LINQ PART II

Continuing from part 1, here I will go one more step further and explain the language constructs basics in C# 3.0 which will help us in writing a LINQ query. Lambda Expression Explained In C# 2.0 you can write anonymous delegate methods that helps in reducing the amount of code written. To explain this, first…

1

C# 3.0 Features Basics For LINQ – PART 1

The ‘var’ Keyword Type inferred at compile time Can only be defined within method scope Mostly used when you need a variable for anonymous types which can only be resolved at compile time e.g. LINQ queries Auto Implemented properties This feature eases the creation of properties for a field inside the C# class  e.g. 1:…

1