Architecture :: Naming Conventions&meaning Of Tables Is Not Clear On SQL Server?
Feb 2, 2011
I have been using Sql Server since 2003, and still encouter situations that are just hard to solve :)I know it's a an sql server question, but since it's from a methodology and architecture point of vue, I thought it fit in this forum I am facing a sort of conflict with my current customer :An old sql server database, migrated from sql server 2000 to sql server 2008 (2003 project), which serves an asp.net application and cubes.naming of tables are like the following : tbl_ and Vw and yet procedures have no underscores. The database contains no functions.All object names are abbreviated, without any dictionary to understand what they mean. We have to ask every time.We developed a new module, and followed Pascal Casing, with clear words for the tables meaning.The customer makes a code review and says, that object are not correctly named :) and the meaning of tables is not clear. Names like AnalyticsAxis, is simply not clear. We also are asked to follow tbl.
I am creating a sql server database table and when i save the table and give the name to a table "i.e. USER" and then see in the property of that table then the name changes to "[USER]". I have tried lot of time but every time it gets.Plz help mei am also attaching the screen shot of this.
I have a design question about whether to use sql tables or enums or both for a application I am developing for work.
Example - Gallery
Let say you have a database for displaying albums and photos. You want the ability to allow the user to set the display mode for the photos differnently in their albums i.e. LightBox, Scrolling, Single
Do you create an enum for DisplayModes so you can for example:
[Code]....
But then for reporting and admin you need to know the Album DisplayMode, so do you then have a SQL Table that just repeats the values of the enum?
I'm developing Web Desktop like Glide or Icloud. It's gonna be a web application that gives the real world desktop application functions.
The DBMS I'm goin' to use is SQL Server. Now, I'm designing the database schema, but having some problems with it. I've no idea what tables I've to include.
So far I've only Users, Folders, Files, RecycleBin, Contacts, ContactGroups tables, but it seems very few. May be I've missed something.
I will try to explain my doubt and keep the code out, maybe for a second post. The greatest problem i am facing here is the logic :P.
At this point i have two tables: Empregado (Worker) and Cargo (Post). One post have many workers and one worker has only one post. In the database i think i am fine, a simple relationship one - many.
I've mapped the tables into classes with the same fields. As well i've created collections using generic lists. Each collection has a method that acess the bank and recover the data.
My worker class agregates one instance of post. I mainly use this to show the data i need. Basicaly i do a select, join the tables and fill the properties of the worker and the post.
The doubt: Is this a good pattern? Up to this moment i am not worried with blinding light performance, but in how to act in an good OOP pattern.
I am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).
I am using ASP.NET (C# and sql server express 2005) for my web application project. I have three related tables. I want to do an insert using typed datasets,tableadapters and three tier architecture. I wish to know how to do simultaneous inserts in 3 tables. So i wish to insert a row in first table and get its primary key. Same with the second table. I will use the primary keys of those first two tables to do the insert in the third table. How can i accomplish this using formview control and what methods should i use??
I have create user wizard control and i put validation control for all field but when i close user control that validators dint clear in firefox or but clear in IE
How can I manually clear ASP.NET server cache related to a give application/web site like what can be done on IE to clear browser cache for a give domain? BTW, I am using II7.
I've got a couple of questions about the naming convention for the DisplayTemplates and EditorTemplates in MVC 2.
If for example I have a customer object with a child list of account how do I:
Create a display template for the list of accounts, what is the file called?When I'm doing a foreach( var c in Model.Accounts ) how do I call a display temple while in the foreach? When I do Html.DisplayFor( x => x ) x is the model and not in this case "c".
There is a conflict b/w our team members about following the naming conventions. We have downloaded a document that specifies the naming conventions for the ASP.NET controls. But it does not covers all ASP.NET 2.0 controls, so there is basically a fight over the naming conventions of the controls that are not specified in that document. Take for example : GridView Control, the naming convention for this control is not defined in the document, so I suggested 'gvw' for the prefix name but my team mates are suggetsing 'gv' for that purpose. I had somewhere read before that the naming convention should contain either three or four letters of a control like TextBox can have 'txt' and ImageButton can have 'ibtn' as the identifying name as prefix.
I'm working on a project in which the client has required a lot of things to happen on a single page, and this has resulted in a rather large blob of HTML being rendered out to the client browser.
The main issue is with input tags (where runat="server" attribute is set), these tend to cause a drastic increase in markup size due to validation, updatepanel triggers, viewstate, and the control markup itself. I've done what I can to reduce the amount of triggers I'm using, I'm compressing the viewstate (to something like 8% of the original viewstate size), I've gotten rid of a lot of ASP.NET Validators and rolled my own, and and I've been using ClientIdMode to reduce the length of the ID attributes of many asp.net elements. All of these combined significantly reduces the amount of HTML being sent to the client, (for example going from 2 megabytes for a request down to 500-600 kb - these are HUGE pages, mind you).
how to connect the two tables of the sql server 2008 databse in C#.
in this there are two tables
1) Tour header(id, name, city, destination)
2) Tour Detail(id, tour id, day no, title,description,images)in this id of tour header and tour id of tour header will be same.now i want to retrieve the data on the basis of when id==tour id.how can we can run the query of two tables.
I have done my searching and haven't found anything related to my issue. I have an aspx page that contains a regular drop down control. When the selectedIndex is changed, it fires off a post back and also rebinds a datalist based on its value. Inside the datalist I have an ascx control which has a gridview and an object datasource:
ASPX page:
[Code]....
My problem is that after my drop down posts back, when the process gets to DataList1.databind (in the selected index changed) i get a "The ObjectDataSource control 'ObjectDataSource1b' does not have a naming container. Ensure that the control is added to the page before calling DataBind." error.
During the post back, the pageload on my control runs and all my properties seem to have its values.
Strong Named Their Assembly. I've read on-line and in the help files for 6 hours straight and I am no where closer to getting this. It seems that every 6 months I run up against one of these types of things with VB.net and the .Net Framework. I read on line and find dozens of people who get the same exact error. Most of the threads are never resolved and the ones that seem to resolve the issue do it in a way that doesn't work for ever one else. It is really absurd.
My web site runs fine in debug mode on my computer (local host). It loads in FireFox and runs fine. When I post it to my web site I get the error below. I try to "Strong Name The Assembly" with the command line command "aspnet_compiler -v default.aspx X:NetProjectsHumMPI -keyfile X:NetProjectsHumMPIkeypair.snk -aptca"
Default.aspx is what fails. This should be the virtual folder of my web app. Obviously "Default.aspx" is not right. I have tried 42 variations on what I think the virtual path to my web app might be. Every single time the compiler fails telling me that it is not a valid path.
I'm moving in to week two of trying to get a simple "Hello world" web app to load on my web site. It runs perfect on my development machine but generates constant errors on the web site. Each time I fix a problem that only happens on the web site another one crops up with even the slightest change - or sometimes even NO change to the code.
I have ten textboxes (txtCO1, txtCO2... txtCO10).I need to set them all to the same text (blank). How can I use a for loop that just changes the number after txtCO, isntead of explicitly setting each text box's text property to ""?
I'm struggling a bit with how to properly name the controllers in MVC. Should they be singular or plural? For example, lets say I have the tables Customer and Product in my database. Should the controllers be CustomerController and ProductController, or CustomersController and ProductsController?
Put a different way, does it make more since for the URL to be:
somedomain.com/Product somedomain.com/Product/Edit/1 or somedomain.com/Products somedomain.com/Products/Edit/1
Is there a recommended naming convention for files and folders in ASP.NET? So far, I've found this thread on the native ASP.NET forum. But it doesn't sound very useful. Some people say "meh, naming convention is not that important", others reply "no, naming conventions are important" but don't say what the recommended convention for ASP.NET actually is.I can use standard VB notation for variables and method names inside the files.
So this interface allows one server to request data from another server. The catch is that all xml for the interface is transmitted entirely over http posts followed by an empty status code 200 response. No data is sent in a response. So if my application wants to requests data, we send an http post with the xml request and receive a blank 200. Then, shortly after our request, we'll receive an http post to a predetermined URL with the xml data which we then send a blank 200. This data will then be stored in a SQL database. This interface cannot be altered.
The reason this is problematic is because our server is handling requests from clients that need that data in the response. If a user requests for data that isn't available in our database, it needs to be requested from the interface and then returned in the response. I'm just not sure how to get this to work out. I've thought about polling the database, but I'm worried about thread pool issues. I've also looked into using ManualResetEvent.WaitOne to halt the processing of the client request and then calling Set when the interface sends the data (as a request). I've read that wait threads are shared, but just don't know if this will scale well. Does anyone have any insight or I'm pretty much stumped on this one...