Quick question about DAL's

Rate It (1)

Last post 09-03-2009 12:46 PM by Crayons. 5 replies.

Sort Posts:

  • Quick question about DAL's

    08-23-2009, 4:35 AM
    • Member
      16 point Member
    • Crayons
    • Member since 08-18-2009, 6:15 PM
    • Posts 30

    In http://www.asp.net/learn/data-access/tutorial-01-cs.aspx it says to create a typed data set file which will act as a DAL...If im using LinQ to SQL do I still need to use typed data set's or does a Link to SQL item/app code insertion act as a DAL? I guess what im trying to figure out is: Is LinQ to SQL a DAL, BLL, or both?

  • Re: Quick question about DAL's

    08-23-2009, 8:31 AM
    Answer
    • Contributor
      2,386 point Contributor
    • lohith.bn
    • Member since 08-03-2009, 10:14 AM
    • Bangalore
    • Posts 403

    Its DAL

    lohith B N
    My Blog Link
    Dont forget to click "Mark as answer" on the post that helped you.
  • Re: Quick question about DAL's

    08-23-2009, 4:06 PM
    Answer
    • All-Star
      16,876 point All-Star
    • mendhak
    • Member since 05-28-2004, 6:58 PM
    • 51.507991,-0.127784
    • Posts 2,673

    Your LTS queries are converted, at runtime, into SQL statements that get executed against the database.  You write your statements as though you were using business 'objects', so that makes it... a DAL, sort of.   It's a RAD DAL.  How about that?

    Not interested in your tweets since 1981.
  • Re: Quick question about DAL's

    09-03-2009, 9:24 AM
    • Member
      16 point Member
    • Crayons
    • Member since 08-18-2009, 6:15 PM
    • Posts 30

    Quick question regarding the  LINQ to SQL, when you say SQL statements do you mean the SQL SPROC'S? If the queries that get converted at runtime are the actual sprocs how would I configure a gridview to pull that specific Sproc?

  • Re: Quick question about DAL's

    09-03-2009, 10:29 AM
    Answer
    • All-Star
      16,876 point All-Star
    • mendhak
    • Member since 05-28-2004, 6:58 PM
    • 51.507991,-0.127784
    • Posts 2,673

    By SQL statements, I mean normal, inline SQL statements. 

    In Linq to Sql, to call a stored procedure, you have to import the SP as a function.  Then you call it as part of your LTS queries. 

    Not interested in your tweets since 1981.
  • Re: Quick question about DAL's

    09-03-2009, 12:46 PM
    • Member
      16 point Member
    • Crayons
    • Member since 08-18-2009, 6:15 PM
    • Posts 30

     Awsome!

    thanks for the info and the link! :)

Page 1 of 1 (6 items)