You searched for the word(s): userid:534356

More Search Options

RSS Available

• Viewing Entity Framework Generated SQL

  Please read the whole question, people seem to keep making false assumptions when they answer this question... I need to know if it is possible to output ALL of the SQL generated by the Entity Framework in the same manner that can be done via LINQ to SQL's Context.Log. I know that I can inspect a query and I know that I can use LINQ Pad, but those only help me to see the SQL selects. Ultimately, I'd like to just buffer all of the generated SQL out to a single location, be it the console or

  Posted to Data Access and ObjectDataSource Control (Forum) by mmarksbury on 8/11/2009
  Filed under: SQL, Entity Framework

• SQL Functions from Entity Framework

  I am currently in the process of modifying my ASP.NET application's Data Access Layer to utilize the Entity Framework for all major CRUD data operations. So far this has worked great and I've been able to throw away most of my stored procedures and custom DAL methods to communicate with those stored procedures. The problem I have is that a few of my user related stored procedures utilize MS SQL's PWDENCRYPT AND PWDCOMPARE functions, and I can't find any way to reference those functions

  Posted to Data Access and ObjectDataSource Control (Forum) by mmarksbury on 2/4/2009
  Filed under: PwdCompare, PwdEncrypt, SQL Server 2005, Linq, entity framework

• CSS Layout and ASP.NET 2.0

  Using CSS for layout on web pages consists of many DIV elements. I want the layout flexibility of CSS with the programatic access to DIV elements of ASP.NET My initial instinct was to use the PANEL tag as it outputs DIV to IE. However, in ASP.NET 1.1, I belive the PANEL tag actually outputted a Table>Tr>Td as opposed to a DIV. What is the ideal approach for this?

  Posted to Web Forms (Forum) by mmarksbury on 11/8/2005

• Multi-Part Messages in Whidbey

  I've noticed that WHIDBEY has a System.Net.Mime class, and the System.Web.Mail class has been extended. Without much more research other than that, I would like to know if WHIDBEY will allow for Multi-Part email support, out of the box. If so, can anyone give me a good starting point or overview on how I can accompolish this in my own projects. Thanks!

  Posted to Getting Started (Forum) by mmarksbury on 8/2/2005

• Nice Architecture

  Thanks for the Starter Kit. I was a fan of the Architecture on the Issue Tracker for the 1.x framework. This architecture is very similar, except, is making great use of Generics, something I had been waiting to see some good examples on. Looking forward to seeing how this unfolds.

  Posted to Time Tracker Starter Kit (Forum) by mmarksbury on 4/20/2005

• Re: Data Access

  Awesome. I've been using Generics in some coding in ASP.NET 2.0. Again, Awesome! But I am having some trouble understanding another aspect, related to the Data Access Layer. I am attempting to re-create the Data Provider model that Issue Tracker uses, in my ASP.NET 2.0 application. I am using the abstract pass-through methods in the Data Access Layer class, and using a delegate from that class to generate collections from within the individual data classes (i.e. SqlDataAccessLayer, AccessDataAccessLayer

  Posted to Issue Tracker Starter Kit (Forum) by mmarksbury on 4/2/2005

• Re: Data Access

  Okay, so I did some digging, and believe I found a good way to replace the collection classes for the current Issue Tracker with minimal code, for ASP.NET 2.0 using generics. Please tell me if my solution will work, and if it is a good or bad implementation. First, I would Create a new class file called "GenericCollections.cs" or variation. This is the code it would contain . . . --------------------- using System; using System.Collections.Generic; namespace SPNET.StarterKit.IssueTracker

  Posted to Issue Tracker Starter Kit (Forum) by mmarksbury on 3/20/2005

• Re: Why the delegate?

  Please tell me if I have this understood correctly . . . In the Issue Tracker The delegate "GenerateCollectionFromReader" is declared. In the SQLDataAccessLayer class, that Delegate is used as an interface to methods such as "GenerateCategoryCollectionFromReader". If the delegate was not used, would all the code in those methods need to be written in the SQLDataAccessLayer class? Is that the only major benefit? If so, does it make sense that if you were 100% certain you would

  Posted to Issue Tracker Starter Kit (Forum) by mmarksbury on 3/20/2005

• Re: Data Access

  Am I correct in my understanding that if this were written using Generics in ASP.NET 2.0, all of the collection classes would be eliminated? AND If so, how would the following Issue Tracker code be changed using Generics instead of string typed Collections? public static IssueCollection GetIssuesByProjectId (int projectId) { if (projectId <= DefaultValues.GetProjectIdMinValue()) throw (new ArgumentOutOfRangeException("projectId")); DataAccessLayerBaseClass DBLayer = DataAccessLayerBaseClassHelper

  Posted to Issue Tracker Starter Kit (Forum) by mmarksbury on 3/20/2005

• Re: Data Access Overview of Issue Tracker

  This has all worked quite well for me, now I have another question if you don't mind . . . The DataAccessLayer.cs contains the use of C# delegate. I've never used function pointers in a practical sense, and all the tutorials on delgates seem to reference function pointers. Can you give me an idea of the purpose of the delgate in this context and help me get an understanding for it? Thanks!

  Posted to Issue Tracker Starter Kit (Forum) by mmarksbury on 1/17/2005