CODEWITHSUNDEEP
asp.netsqlvb.netobject
Stanton
Stanton

Reputation: 1374

ASP.NET - Is there an object that I can execute sql queries against?

I'm developing an application in asp.Net using VB and an Access database. My client has specified these, and I can't use more robust tools.

My application has to perform a sizable number of logical operations, and SQL is perfect for this. However, because of some of the limitations of Access SQL, I can't really write large SQL statements that do the whole job. Lacking logic testing like IF-ELSE, I'm stuck writing literally dozens of SQL statements. That would be OK, but I'm leery of all that activity against an Access database. Access isn't very stable when you work it that hard.

I've fooled around with funky solutions using things like the SWITCH function, but they look more like spaghetti than actual code. Wouldn't be maintainable at all.

I can upload all of the data into objects in memory and loop back and forth through them using VB logic, but SQL would sure be more efficient.

My question is: is there some object I can create in memory that I can run SQL against? Some recordset-kind of thing? Came up snake-eyes when I searched for this, but I thought I'd ask.

Thanks for any suggestions.

Upvotes: 0

Views: 123

Answers (1)

Craig Moore
Craig Moore

Reputation: 1089

So if I understand your question correctly you currently have to use an Access database as the backend storage but you do not like doing this and would rather pull all data into the application (ASP.Net) and perform your queries against this as if the database was an SQL database in the application. I expect then that you would push the data back.

AFAIK no this cannot be done. While you could put most of the data into objects and do the manipulation there you will not have the relationships etc. but you could try using LINQ or entity framework.

This link below explains that you can do LINQ with MSAccess and that may give you the query power you want.

Query Microsoft Access MDB Database using LINQ and C#

Upvotes: 1

Related Questions