I have a low traffic internal office application which is currently written in classic asp and I have the task of converting the same in .net.
I need inputs on the design as I would be using asp.net and oracle as the backend.
- What oracle classes/ data providers do i need to use. Does MS provides any library which I can use to make calls to my oracle db.
- I have a number of tables in my oracle db, is there any tool which I could use to create business logic. It should automatically create classes containing properties depending on the columns
I have a low traffic internal office application which is currently written in classic asp and I have the task of converting the same in .net.
I need inputs on the design as I would be using asp.net and oracle as the backend.
- What oracle classes/ data providers do i need to use. Does MS provides any library which I can use to make calls to my oracle db.
- I have a number of tables in my oracle db, is there any tool which I could use to create business logic. It should automatically create classes containing properties depending on the columns
Thanks
Dude if you are creating in dotnet than better to go with recommended backend sqlserver. There is nothing like that one is good other is bad. Gives priority to recommended thing. You can better go with ASP.NET mvc , that will be better choice , because you
dont have to much worry about proper design pattern implementation as mvc framework already provided by ASP.NET which you will use. MVC will be fast because it doesnt have much server control , and you can use js libraries which will be much faster like extjs
, knockout and jquery.
Hope you got your answer.
Please if your thread get resolved ,'Mark as Answer' to reflect the right status.
__________________________________________________
ARMY: Reason to PROUD
There are some tools out there for just that kind of thing.
For the DB I would look at DB Convert and possibly ASPFORMGEN for the logic, just a starting point, do a few searches on GOOGLE and you will find everything right there for you.
Hey man use ASP.NET MVC and entity framework , what you need is an ORM tool , right what entity framwork will do is convert you oracle tables to classes with attributes as properties defined it. so now from linq queries you can easily get data from entityframework.
No need to call oracle directly. And the best thing is it can also convert functions and procedures as functions which you can call directly through entityframework created functions. Its awesome and no performace lag kind of issue. That's exacly what you
wanna do. It's icrosoft only so its best with dotnet c# to use. Happy coding. Hope you get the exact answer here.
Please if your thread get resolved ,'Mark as Answer' to reflect the right status.
__________________________________________________
ARMY: Reason to PROUD
Please remember to click “Mark as Answer” on the post that helps you and to unmark it if a marked post does not actually answer your question.
Thank you!
----------------------
"Microsoft Community Contributor Award 2011"
CsharpAsp.ne...
Member
136 Points
465 Posts
Design inputs needed
Jul 18, 2012 01:28 PM|LINK
Hi
I have a low traffic internal office application which is currently written in classic asp and I have the task of converting the same in .net.
I need inputs on the design as I would be using asp.net and oracle as the backend.
- What oracle classes/ data providers do i need to use. Does MS provides any library which I can use to make calls to my oracle db.
- I have a number of tables in my oracle db, is there any tool which I could use to create business logic. It should automatically create classes containing properties depending on the columns
Thanks
softvishu
Member
460 Points
120 Posts
Re: Design inputs needed
Jul 18, 2012 01:48 PM|LINK
Dude if you are creating in dotnet than better to go with recommended backend sqlserver. There is nothing like that one is good other is bad. Gives priority to recommended thing. You can better go with ASP.NET mvc , that will be better choice , because you dont have to much worry about proper design pattern implementation as mvc framework already provided by ASP.NET which you will use. MVC will be fast because it doesnt have much server control , and you can use js libraries which will be much faster like extjs , knockout and jquery.
Hope you got your answer.
__________________________________________________
ARMY: Reason to PROUD
Thanks,
Vishal Sharma
aabruzzese
Contributor
2806 Points
759 Posts
Re: Design inputs needed
Jul 18, 2012 01:55 PM|LINK
There are some tools out there for just that kind of thing.
For the DB I would look at DB Convert and possibly ASPFORMGEN for the logic, just a starting point, do a few searches on GOOGLE and you will find everything right there for you.
Hope this helps you get started.
softvishu
Member
460 Points
120 Posts
Re: Design inputs needed
Jul 18, 2012 02:02 PM|LINK
Hey man use ASP.NET MVC and entity framework , what you need is an ORM tool , right what entity framwork will do is convert you oracle tables to classes with attributes as properties defined it. so now from linq queries you can easily get data from entityframework. No need to call oracle directly. And the best thing is it can also convert functions and procedures as functions which you can call directly through entityframework created functions. Its awesome and no performace lag kind of issue. That's exacly what you wanna do. It's icrosoft only so its best with dotnet c# to use. Happy coding. Hope you get the exact answer here.
__________________________________________________
ARMY: Reason to PROUD
Thanks,
Vishal Sharma
santa_1975
Star
8574 Points
1499 Posts
Re: Design inputs needed
Jul 18, 2012 11:29 PM|LINK
Hi,
Read this thread.
http://forums.asp.net/t/1652601.aspx/1
Hope this helps.
Thank you!
----------------------
"Microsoft Community Contributor Award 2011"