M
mateo
Hello i would like to have advices on an ASP.NET 2 application that i
must develop.
I'm new to ASP.NET, i am more of WinApp developper, so if there is some
experienced folks out there all advices are welcome.
So there it is, i'm developping an asp application that will be
accessed by many workers in a company. The app is basically dealing
with parts and customers (we sell pieces off all kind and we have lot's
of customers). My database will be SQL SERVER 2005 running on a
dedicated server. User's of this application will be devided in 3
groups, which one having some previleges and access to different parts
of the application.
Now all users will have access to parts,customers and some other
tables. So i am wondering if there is a way of sharing my dataset
containing for example(parts, customers and misc tables) with all users
of the application, so that i can cache this dataset and maintain state
(update, insert, delete) of those data in a global way. And if so how
can i achieve this behavior?
My database schema is almost done, i've use the asp_regsql tool to
create my users table in the database, but i've noticed that a user is
identified with a GUID. In my schema customers and users are identified
with a BigInt. What is the best way to link GUID to BigInt? I was
thinking of adding a table which would make the relation between a user
connecting to the app with a GUID and a user or customer represented by
a BigInt. Is this a good way of doing things?
Thanks in advance
Mateo
must develop.
I'm new to ASP.NET, i am more of WinApp developper, so if there is some
experienced folks out there all advices are welcome.
So there it is, i'm developping an asp application that will be
accessed by many workers in a company. The app is basically dealing
with parts and customers (we sell pieces off all kind and we have lot's
of customers). My database will be SQL SERVER 2005 running on a
dedicated server. User's of this application will be devided in 3
groups, which one having some previleges and access to different parts
of the application.
Now all users will have access to parts,customers and some other
tables. So i am wondering if there is a way of sharing my dataset
containing for example(parts, customers and misc tables) with all users
of the application, so that i can cache this dataset and maintain state
(update, insert, delete) of those data in a global way. And if so how
can i achieve this behavior?
My database schema is almost done, i've use the asp_regsql tool to
create my users table in the database, but i've noticed that a user is
identified with a GUID. In my schema customers and users are identified
with a BigInt. What is the best way to link GUID to BigInt? I was
thinking of adding a table which would make the relation between a user
connecting to the app with a GUID and a user or customer represented by
a BigInt. Is this a good way of doing things?
Thanks in advance
Mateo