Is the DAL dead?

[Jim]

I have (like probably everybody else) literally no time to write something to
see if this is possible, but here is my scenario...

I'm integrating a plug-in into another software solution that somebody else
has written. This plug-in gets data from a database and then displays that
data to the user in a nice manner. Anyway, every once in a while I want
something new from the database, and I have to ask their development team to
write something new in their DAL. This involves some developer upgrading
their DAL, and then they have SQL db guys that will write some fancy sproc
for the new DAL procedure.

Anyway, since I know that their using SQL server 2005 (currently upgrading
to 2008), would it be possible to have 1 DAL function that would accept
something along the lines of a lambda expression that they could use to
retrieve data from the database, and pass me back some type of enumerable
type? This way I wouldn't have to keep on asking for new features.

Thanks,
-- Jim

 

[Mr. Arnold]

I have (like probably everybody else) literally no time to write something
to
see if this is possible, but here is my scenario...

I'm integrating a plug-in into another software solution that somebody
else
has written. This plug-in gets data from a database and then displays
that
data to the user in a nice manner. Anyway, every once in a while I want
something new from the database, and I have to ask their development team
to
write something new in their DAL. This involves some developer upgrading
their DAL, and then they have SQL db guys that will write some fancy sproc
for the new DAL procedure.

Anyway, since I know that their using SQL server 2005 (currently upgrading
to 2008), would it be possible to have 1 DAL function that would accept
something along the lines of a lambda expression that they could use to
retrieve data from the database, and pass me back some type of enumerable
type? This way I wouldn't have to keep on asking for new features.

Yes, it can be done if either Linq-2-SQL or ADO.NET Entity Framework with
Linq-2-Entity is being used as the ORM/Virtual database Model solution used
against SQL server.

Yeah, you can query the Model with the Linq solutions above with lambda
expressions to return an IEnumerable or IQuerable result set back. You can
also use Entity SQL of the ADO.NET Entity Framework which is like T-SQL and
query the Model.

I am just finishing up a project with ADO.NET EF, and I am getting ready to
start another project using ADO.NET EF, which I didn't use a sproc or plan
on using sprocs ever again.

I can do it with Linq solutions.

And no, the DAL is not dead, not in N-tier SOA solutions, far from it.
..
UI
MVP or MVC
BLL
DAL

A loosely coupled solution.

Also, there are Linq Web service provider applications that have a Web
service and database on the backend, and you can use a client application
that uses Linq to query the database through the Web service, a Linq service
provider.







__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4073 (20090513) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




__________ Information from ESET NOD32 Antivirus, version of virus signature database 4073 (20090513) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

 

[Mr. Arnold]

I have (like probably everybody else) literally no time to write something
to
see if this is possible, but here is my scenario...

I'm integrating a plug-in into another software solution that somebody
else
has written. This plug-in gets data from a database and then displays
that
data to the user in a nice manner. Anyway, every once in a while I want
something new from the database, and I have to ask their development team
to
write something new in their DAL. This involves some developer upgrading
their DAL, and then they have SQL db guys that will write some fancy sproc
for the new DAL procedure.

Anyway, since I know that their using SQL server 2005 (currently upgrading
to 2008), would it be possible to have 1 DAL function that would accept
something along the lines of a lambda expression that they could use to
retrieve data from the database, and pass me back some type of enumerable
type? This way I wouldn't have to keep on asking for new features.

Yes, it can be done if either Linq-2-SQL or ADO.NET Entity Framework with
Linq-2-Entity is being used as the ORM/Virtual database Model solution used
against SQL server.

Yeah, you can query the Model with the Linq solutions above with lambda
expressions to return an IEnumerable or IQuerable result set back. You can
also use Entity SQL of the ADO.NET Entity Framework which is like T-SQL and
query the Model.

I am just finishing up a project with ADO.NET EF, and I am getting ready to
start another project using ADO.NET EF, which I didn't use a sproc or plan
on using sprocs ever again.

I can do it with Linq solutions.

And no, the DAL is not dead, not in N-tier SOA solutions, far from it.
..
UI
MVP or MVC
BLL
DAL

A loosely coupled solution.

Also, there are Linq Web service provider applications that have a Web
service and database on the backend, and you can use a client application
that uses Linq to query the database through the Web service, a Linq service
provider.







__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4073 (20090513) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




__________ Information from ESET NOD32 Antivirus, version of virus signature database 4073 (20090513) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

 

[Frans Bouma [C# MVP]]

I have (like probably everybody else) literally no time to write something to
see if this is possible, but here is my scenario...

I'm integrating a plug-in into another software solution that somebody else
has written. This plug-in gets data from a database and then displays that
data to the user in a nice manner. Anyway, every once in a while I want
something new from the database, and I have to ask their development team to
write something new in their DAL. This involves some developer upgrading
their DAL, and then they have SQL db guys that will write some fancy sproc
for the new DAL procedure.

Anyway, since I know that their using SQL server 2005 (currently upgrading
to 2008), would it be possible to have 1 DAL function that would accept
something along the lines of a lambda expression that they could use to
retrieve data from the database, and pass me back some type of enumerable
type? This way I wouldn't have to keep on asking for new features.

Sounds like the good old discussion between stored procedures vs.
dynamic sql. What you're after is O/R mapping using dynamically
generated queries. Not sure if they allow you to do that on their DB. If
they do, you can simply write your .NET code and everything else is
taken care of.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

 

[Frans Bouma [C# MVP]]

I have (like probably everybody else) literally no time to write something to
see if this is possible, but here is my scenario...

I'm integrating a plug-in into another software solution that somebody else
has written. This plug-in gets data from a database and then displays that
data to the user in a nice manner. Anyway, every once in a while I want
something new from the database, and I have to ask their development team to
write something new in their DAL. This involves some developer upgrading
their DAL, and then they have SQL db guys that will write some fancy sproc
for the new DAL procedure.

Anyway, since I know that their using SQL server 2005 (currently upgrading
to 2008), would it be possible to have 1 DAL function that would accept
something along the lines of a lambda expression that they could use to
retrieve data from the database, and pass me back some type of enumerable
type? This way I wouldn't have to keep on asking for new features.

Sounds like the good old discussion between stored procedures vs.
dynamic sql. What you're after is O/R mapping using dynamically
generated queries. Not sure if they allow you to do that on their DB. If
they do, you can simply write your .NET code and everything else is
taken care of.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

 

[Jim]

--
Jim

I have (like probably everybody else) literally no time to write something to
see if this is possible, but here is my scenario...

I'm integrating a plug-in into another software solution that somebody else
has written. This plug-in gets data from a database and then displays that
data to the user in a nice manner. Anyway, every once in a while I want
something new from the database, and I have to ask their development team to
write something new in their DAL. This involves some developer upgrading
their DAL, and then they have SQL db guys that will write some fancy sproc
for the new DAL procedure.

Anyway, since I know that their using SQL server 2005 (currently upgrading
to 2008), would it be possible to have 1 DAL function that would accept
something along the lines of a lambda expression that they could use to
retrieve data from the database, and pass me back some type of enumerable
type? This way I wouldn't have to keep on asking for new features.

Thanks,
-- Jim

Hey,

Thanks guys. I'll look into this before my next meeting w/ the other team.

Appreciate the thoughts.
-- Jim

 

[Jim]

--
Jim

I have (like probably everybody else) literally no time to write something to
see if this is possible, but here is my scenario...

I'm integrating a plug-in into another software solution that somebody else
has written. This plug-in gets data from a database and then displays that
data to the user in a nice manner. Anyway, every once in a while I want
something new from the database, and I have to ask their development team to
write something new in their DAL. This involves some developer upgrading
their DAL, and then they have SQL db guys that will write some fancy sproc
for the new DAL procedure.

Anyway, since I know that their using SQL server 2005 (currently upgrading
to 2008), would it be possible to have 1 DAL function that would accept
something along the lines of a lambda expression that they could use to
retrieve data from the database, and pass me back some type of enumerable
type? This way I wouldn't have to keep on asking for new features.

Thanks,
-- Jim

Hey,

Thanks guys. I'll look into this before my next meeting w/ the other team.

Appreciate the thoughts.
-- Jim