Tagged Questions
3
votes
1answer
45 views
Storing computed values in database when reads are far higher than writes
I find myself faced with a conundrum of which the answer probably falls outside of my expertise. I'm hoping someone can help.
I have an optimised and efficient query for fetching table (and linked) ...
5
votes
1answer
128 views
Robust billing system design. Am I going completely in the wrong direction?
I am developing a hotel registration/billing application in ASP.Net, using the entity framework. When it comes to generating the bill for the registrant, my client has a lot of wacky criteria. ...
0
votes
0answers
22 views
Is there a better way of handling access control logic instead of it being in the UI? [migrated]
Through most of my dev experience, I've never had to deal with much variety of access control architectures.
They've all been pretty straight forward:
Group [Create, Update, Delete]
- User 1
...
0
votes
2answers
68 views
Schedule Table Design
I am working on doctor scheduler page requirement. The below is the screen for showing a usual weekdays schedule for a doctor.
The doctor may visit only few days on a week and only between a ...
0
votes
1answer
79 views
Role-based accesses control in a system using c#
I'm creating a restaurant management system, I want to enable or disable some buttons according to the user type.
For example, if the user have admin type account then Edit salary button is enabled; ...
0
votes
1answer
33 views
conjunction table and C# class?
I have ResorceTopices & Resources tables m to m relationship and conjunction between the 2 table. Just wondering if should I write class for conjunction or not and if I write one should be like ...
1
vote
2answers
40 views
How do I add a fixed value property to my model?
Suppose I have a Task model:
public class Task()
{
public int Id {get; set;}
public int Title {get;set;}
}
Now I want to add a 'repeat' property.
The property can only hold one of 3 values:
...
2
votes
0answers
66 views
How to handle this hierarchy in Entity Framework
I have a particular sort of data model that has to use a closure table due to the fact that nearly every material_composite is the root of its own tree, but can also be in the hierarchy of any other ...
2
votes
1answer
387 views
Mega Drop-Down Menu for asp.net website
I want to implement Mega Menu structure for my asp.net webform based website.
I want to implement Mega Menus using following CSS based Mega Menus
...
0
votes
0answers
49 views
Get Entity composed of child entities in Entity Framework
I have some 'complex' entities formed by other entities. For Example the 'Order' Entity:
Order
OrderDetail (child)
OrderDetailsDiscount (child of the child)
OrderPayment
OrderState
The code for ...
0
votes
1answer
65 views
database design for song voting system [closed]
I have to make a simple song voting website with asp.net .
Here is the sample of my database tables and fields .
Album User Voting
------ --------- ---------
...
3
votes
3answers
184 views
Proper Searching with Linq, Entity Framework and Database Indexes
I need to search products through products in a database and I'm looking to set this up in the right way so that I can have solid performance when there are a lot of rows (1,000,000). I'm somewhat ...
0
votes
0answers
57 views
How to better design this note sharing app?
I am developing a metro app in which user can follow other users, can share note with their followers.
For that i have created three Table named User, Follower, SharedNote
User : Id, FirstName, ...
0
votes
3answers
661 views
Insert data in two Different tables on InsertOnSubmit() Using Linq asp.net c#
i am working on a project on online shopping with asp.net c# and Mysql. I am using Devart Linqconnect (LinqtoMysql). I have two tables in mysql customers and customer addreesses:
Customer Table
...
0
votes
1answer
59 views
Store a limited number of items in database(agnostic) C# for code
I am working on an asset management application for a data center where I am employed. I am still in planning but one issue that has been weighing heavily is: A server rack is 42U(1U per ...
