AFAIK

Step1- Open the . edmx file Step2- Right click in . edmx file and select Update Model from Database Step3- Select Add tab, select Stored Procedures and select the procedure you want to add and click finish as shown in below figure a Step4- Build the Entity Project to make sure nothing is broke Step5- Right click on . edmx file and  select Model Browser Step6- Model Browser Popup will appear as  below figure. Click on the Strored Procedures in PricingToolModel . Stroe and click the newly added SP (it will appear here) Step7- The Add Function Import screen will appear Based on the return we can set up. If you are returning a multiple column Click on the Get Column Information First, then click the new Complex Type. After that you can  see the Return of Collection will select the Complex and a complex type is generated by EF If its returning scalar you can select which return type like int , string etc... If its return  entitty ...

This question is dedicated to every one who is searching for job. What kind of job you applying, you will meet this question some where in the selection journey. There are lots of techniques available to answer this question. Try to create an answer from  your own experience or from field. Some examples are  First example I am definitely interested in making long term commitment to my next position. What you have told me and from the job description, it is exactly what i am looking for and what i am very grateful to do. In terms of future career plan i am confident that if i do my work with excellence, the opportunities will definitely knock my doors. It is always been that way in my career and i am confident i will surely have the similar opportunity here. I will do the job to best of my ability and keep my eye open for the opportunities in the organisation. I am prepared to learn new things and ready to contribute to the overall success of the organisation in a num...

How to Improve Linq Query Performance by using Parallel/ PLinq I want to highlight the disadvantage first, because if you know the disadvantage you can make a choice if required in your project or not. Don't use if you have a Single core or dual core CPU's. I found that depending on the complexity of For loop  the CPU performance reaches more than 70-80%  (Not talking about the simple For loop). So if you want to use the parallelism for complex loop make sure you have more than  2 CPU's Parallelization sometimes cause a  PLinq query to run slower than Linq to object equivalent. Basically it said like queries with few data source elements and fast user delegates are reluctant to speed up much. Parallel Linq is the parallel implementation of Linq. Parallel Linq implementation on loops provide better performance compared to sequential  loop. Parallel Linq also works like Linq queries operate on any in-memory IEnumerale ( of T) ...

Recently   i read an article from Yun   Siang Long At  Careerealism So Thought To Share With My Readers With Some Modification. 1. Take Accountability Take the accountability for   anything   that has your iconic belief in it. That means, as long as you   participate   in the project, you have a hand in the failure of   the   project. Learning accountability means not just the good/ successful  things, but even the   bad/failed   ones. Always find the best way to admit mistakes - it’s all right   to   be wrong, but need to identify and sort out. You cannot become a master, if   you   have not made any mistakes. One of the examples coming to my mind is Dr APJ Abdul Kalams Press Conference after a failed PSLV launch. He took the whole events in his  shoulder  and  briefed  the media with out exposing h...

I attended a couple of interviews during my 5+ year career and    and  the experience of my friends circle,  especially for getting the first opportunity in the UK and came across various types of interviews. Based on that limited knowledge I can categorize the interviewers into 4 categories 1-     Technically well sounded interviewer 2-     Interviewer who has taken a list of questions and asking only those questions 3-   Interviewer have no idea about technology they are recruiting for but know about the kind of business the company is doing 4-     An interviewer who speaks more about the problems they faced with during the ex- colleagues Category-1 technically well sounded interviewer I came across 25-30%of technically sounded interviewers. They had clear idea about what they are recruiting for. Manipulating such an interviewer is a big issue. For all intervi...

There are lots ways available to write the secure Mvc application. In my experience I came across lots of secure application in public facing. I want to tell about some of the mechanism I followed. 1- encrypting the URL Parameters and preserving id's encrypted on the client side 1- I always make sure if I pass Id or any sensitive data into the view always make sure it's encrypted. By doing so make sure if we forced to use HTML.hidden or HTML.hidden for have the encrypted values, in action link if I pass any parameters from the client side (eg:- edit or create or navigating between different actions we can make sure that all the values are encrypted) During the design of the actions results if it's http get I usually encrypt the sensitive data [httpget] Public actionresult display() { TestModel testModel=new TestModel(); testModel.id= encrypt(id); Return View(testModel); } [httppost] Public ActionResult Display(string id) { Guid d_id= new Guid(decrypt(id)); ...

Last 2 months I was not updating my blog because I was busy with some interesting opportunities in my career. Today I am writing this blog on the eve of a project release. Even though I have been involved in a lot of projects for more than 4 years, this is the project that went through all the process estimation, planning, design, implementation, uat and release happened as perfectly as planned. So I thought of sharing my wonderful experience with all my readers. This is the project my organization decided to outsource. But I am showing in my interest to manage this project to our commercial director. Finally lots of management level meeting finally it came to me, but with strict deadlines. On August first week commercial director given green signal for this project and given a business analyst to discuss the business needs. Myself will manage the project in terms of the technical side and the product side business analyst will help to get the requirement. I already worked with th...