All Questions
27 questions
0
votes
1
answer
60
views
Creating first degree navigation properties to handle complex relations
We design an asset management system to track the tangible assets circulating in an institution. We use ASP.NET MVC architecture with EF6 as our ORM.
Entities:
Asset is an equipment owned by the ...
- 389
0
votes
1
answer
42
views
Recommendation on How to handle Database attributes inserted later but not nullable
I have a Vehicle class which is used for mapping to the database, some of the attributes or properties of the Vehicle entity will be updated by different departments,
e.g a Vehicle Manager will add ...
- 621
1
vote
2
answers
335
views
How to design ASP.NET Core - SQL application where user should be able to create forms of different input items and store values in database
I've started working on a web application project, where a feature is: the admin user can create/update few custom forms choosing different input types from the database and the end users can update ...
- 2,038
3
votes
1
answer
347
views
Big database project on ASP.NET MVC [closed]
I'm working on really nice project in ASP.NET MVC, where comapnies can generate some pdf documents, save some data etc. I have a piece of project already. [no important]
Programist will add Company ...
- 51
0
votes
1
answer
636
views
Creating different tables using using same base abstract class
I have 2 models which have exactly same fields, but I chose to make different models for them because I needed two different tables, one for each.
Earlier everything was working fine when I had two ...
user6193503
4
votes
2
answers
2k
views
How to store User Uploaded Files using MVC.NET on a IIS webserver?
We are working on a Educational website which allows users(teachers and students) to upload files (.pdf,.docx,.png and ... ). We don't have any experience in this area and wanted to make sure we are ...
- 1,675
-1
votes
2
answers
2k
views
Should static data be stored in a database or in the application [closed]
I'm working on some software at them moment and I'm not sure which route to take with this. I have data that will never change, and has a hierarchical relationship, and will be used to populate the ...
- 255
6
votes
2
answers
1k
views
Search data from dynamic tables using Microsoft SQL Server
I have an organization table like this:
OrgID | OrgInviteCode | OrgName | Status | ProjectTableName | InsertOn
-----------------------------------------------------------------------------------...
0
votes
1
answer
57
views
Smart way to Query data from database based on Language
I'm always developing web applications that support both Arabic and English. Currently I'm doing something like this: [Simplified]
@if (MyProject.Resources.Shared.SiteDirection == "ltr")
{
...
- 525
0
votes
0
answers
54
views
Insert product data although we don't know it belongs to which category using entity framework
I'm developing a eShopping website. I decide that the number of categories (types) of product is limited. As following image:
I have 3 categories: mobile, tablet, memcard. All of them has common ...
0
votes
1
answer
453
views
One database, multiple .NET MVC 5 instances
I have written c# ASP.NET MVC 5 with EF 6 application. I have 2 clients. Fore each of them I need to modify the app slightly.
I wont them to share one database, but with separate table names, which I ...
- 967
1
vote
2
answers
66
views
Should I introduce redundancy into model design
I am trying to design a new system for tracking sales. A simplistic version of my data models are:
public class Sale
{
public int SaleId { get; set; }
public DateTime CompletedDateTime { get;...
- 2,746
2
votes
1
answer
494
views
What is the approach to use user id's throughout my application?
Related content is here: Best practice to maintain a user id (MVC)
The authentication service, provided through IdentityDbContext, is ideal for my web application. I am able to add fields I want each ...
- 9,529
1
vote
2
answers
1k
views
Version History of Database entries in entity framework
I have a project where I want to keep version history of each changes. For instance, in following example if somebody changes information like:
Add a new task to person
Edit a existing task
Add a ...
- 789
1
vote
1
answer
486
views
Asp.net MVC Handling Model Status
IE: A model called Equipment responsible for storing information about equipments, and its status.
My question is, what is the efficient way to store an item's status. My approach is creating ...
- 779