Architecture :: Website That Work A Lot With The DB - The Best Way?
May 22, 2010
I'm in the middle-end of written a big website that work a lot with the db.
In every call a page runs 5-12 different queries.What I did was build an execute class that uses MySqlConnector API, which get string that represent the sql and the parameters and then just execute the query and return DataTable. In addition to that I have a class that hold all the function that call the execute class functions. For example in the class I have getAllProducts, getOldestProducts etc... and in each and every one of them theres sql statements.
Recently I watch the LINQ video series(How Do I with LINQ - on this site) and it looked good.As I sees it my way is very good because it just open connection execute the sql get the result and close the connection.The question is what is the best performance wise way to build this site? Is it my way that I use all along? Is it using LINQ? Or working with DataSet/TypedDataSet is the preferred way?
View 4 Replies
Similar Messages:
Jan 7, 2011
I want to put my website project and admin website under same project as I want to use session and authentication of the main site. Also I want to show the admin, the page, where he has made changes. But the problem is whenever I will change anything in admin pages, I've to build the entire website. I don't want to do that. Can I build that separately?
I don't want to choose the option of building all pages separately as well.
Is there any alternatives of doing that. Separate projects for admin and website will come up with many other challenges. So I would like to avoid that.
View 2 Replies
Mar 20, 2010
Please share resources to see, how MVC + WCF + EF work together.
View 3 Replies
Feb 16, 2010
I have to create a application to let user input data and then sync with company server.
Deponding on location, user may be on line (using wireless) or off line.
Can I create a asp.net app working on or off line? Or, have to create a windows application?
View 3 Replies
Jan 28, 2011
I'm currently developing a web application where everything works fine in the visual studio web server. It authenticates the user, access the database, writes to it, etc.
After I wrestled yesterday to publish it to my local iis, a subject I admit I have little to no experience of doing, suddenly the membership of the website started to not authenticate the users.
At first I suspected maybe the app wasn't accessing SQLServer, or that the data with the users I had in the asp.net membership database was erased when I uploaded the website.
So I stopped iis, i attached the db file to my local sql server, and I can see that all the users are there just like I uploaded them. I also can see the website can access another database with micellaneous contents just fine.
The loging controls don't tell me there's any problem either, they just show a message telling the user that the login attempt wasn't successful.
So, here's what I remember I did to make the app work as it wasn't even doing that when I first uploaded it.
I used the asp.net_regiis tool to copy website scripts to the website.
aspnet_regiis -sn <path>
then I deleted the website, uploaded again from VS. this time it shows in the browser but it doesn't authenticate the users.
The application isn't precompiled, I just uploaded it.
View 6 Replies
Sep 26, 2010
I've been reading recently about EF4, and how to build an architecture for asp.net web forms application using it.
I explored using POCOs (self tracking entities), with WCF, but found out that my application will be deployed on a single box (i.e. one tier), so I started reading about logical separation of layers, and came up with the following solution:
DAL layer that contains EDMX model and EF APIs, and also generated context object.Entities DLL that holds all generated POCO entities using ADO.NET POCO entity generator. (for persistence ignorance, and decoupling entities from DAL).Business layer that contains a façade for each related group of business functions, the façade will be aware of and using DAL layer. And in each function, it will initiate context and uses different entities to carry out specific job (i.e. function).UI layer that only calls the business layer façade classes. With no awareness of DAL, but it will be aware of entities (i.e. using entities DLL), as the business layer will return results basically as entity collections.
I want to know what you think about this architecture.
I also read about an architecture that uses repository and unit of work patterns, but what I understand that context object is already implementing a UOF pattern, and also object sets are implementing repository pattern (correct me if I'm wrong), so the only advantage of using additional abstraction over them is to make the business layer communicates to my classes, not EF classes, and this is good only if the DAL strategy might change (i.e. by using another tool other than EF, which is not my plan).
View 8 Replies
Jun 17, 2010
Can you give me an scenario example how you have used polymorphism in your project. With new and override keyword.
give me an example from a finance domain/ecommerce domain. I am looking from a UML Model Perspective.
View 1 Replies
Mar 20, 2010
I have a requirement below;Step 1: I must insert and update record with "xx" Running Number into Tables in Database.Step 2: I must send "xx" Running Number from Step 1 go with Web Service and wait the response.Step 3: If Step 2 has a error. I must roll back Step 1 data that I do in Step 1. But If Step 2 is success, everything is Ok.How can I solve this requirement? and How can I write asp.net code?
View 3 Replies
Nov 9, 2010
I am planning to create HR Management System using asp.net & sql server 2005. In this application we need to manage different kinds of Employee Documents like Offer letter,Salary certificate etc.. Now,What we need is we will store templates for these documents(ms word,excel) in the application and needs to genereate these documets corresponding to the selected employee like mail merge.
View 3 Replies
Mar 30, 2010
How to build a web application using ASP.NET , this web app isa portal and i can edit in the interface of each web page at runtime ,[URL]How can i do that ???? , is that require sharepoint WSS , sharepoint designer , PathInfo , Forms server ????And if that web app require these apps , how can i use them to build web app like , i looking for a tutorial
View 1 Replies
Nov 15, 2010
We are using a .net web application and my environment is as follows:-
SERVER : Server: Windows 2003
.NET FRAMEWORK : 3.5
ASP.NET FRAMEWORK : ASP.NET 2.0
Template used : ASP.NET Web application project ( not a web site)
I have code in global.asax.cs which is like below. This code dynamically loading the web.config. Is this right? Since the deployment accidentally the web.config been copied mutlitple times (in past) which was bringin uat web.config to prod and causing the prod to point to uat databae, we did this way, i.e dynamically reading the param values from a file and loading them to web.config dynamically.
Is this right? The web site is loosing connection string once a while and making the site to go down. One thing i noticed is in DEV / QA / UAT we have the ASP.NET version tab in iis set to 2.0, but in prod it's been set to 1.1. I told them to change, but somebody arguing how it worked for a while and suddenly stopped. I don't know the answer. Could somebody tell me or point me to a direction to fix this.
private void LoadConfig()
{
string xml = null;
FileStream fs = null;
StreamReader str = null;
System.Xml.XmlDocument xmlDoc = null;
System.Xml.XmlNode xmlNode = null;
EventLog _eventLog = null;
try
{
// Get the Config path from registry, parse and set the static properties of the class.
string configFile = CompName.CoreLib.SystemUtilities.RegistryUtility.ReadValue("ConfigPath") + @"ApplSettingsConfig.xml";
//string configFile = @"C:" + @"Common.Config";
// Read the XML Config File
fs = File.OpenRead(configFile);
str = new StreamReader(fs);
xml = str.ReadToEnd();
str.Close();
fs.Close();..............................
View 2 Replies
Mar 18, 2011
I'm conducting a project in which a website should have multi-language support.Now, this website is supposed to serve about 500K+ visitors a day, so it must be super-efficient.
I've created a table of parameters {[ID],[Name]} AND a linkage-table {[objectID],[parameterID],[languageID],[value]}. I think it's the best way to deploy multi-language support while having the privilege to translate different parameters for each language.
As far as I know, server's memory is much faster than a physical HDD. Therefore, I'm planning to store ASP.NET Application State objects for my translation architecture.[URL]
View 3 Replies
Dec 21, 2010
I've been all around the net for weeks now trying to figure out the best way to set up a Multi-tenant website (building a web app that multiple companies and their employees will use). As far as a database goes, I am interested in using one database with a copied set of tables for each company. As far as managing the login and security in MVC2 I am lost with the myriad of examples (mostly old and not MVC) that I have seen. So ideally my app would allow a company rep to register their company and then be able to add their own employees to the site. Then all employees could login and be securely associated with their own company's tables (table names would be appended with their AccountID).
I'm not sure if this would be handled using routing or session variables or what the more ideal and up to date methods might be. Like others who have discussed this issue, it seems like this should be a much more fleshed out solution as it is becoming a more common use on the internet. I'm even willing to simplify the database down to one set of tables that stores an AccountID in each row if needed.
View 1 Replies
Jul 28, 2010
I have a ASP.net website, i have a page, based on the query string, i grab certain information from database and display the image.
I need create a javascript to put in the javascript in otherwebsite, and then this image will display in that website.
The functionality is same as good ads something like below.
<script type="text/javascript"><!--
google_ad_client = "......";
/* Ad for AdSelector */
google_ad_slot = "....";
google_ad_width = 1;
google_ad_height = 2;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
View 4 Replies
Oct 11, 2010
I need to create a search engine for my website that searches my entire content and files stored in a database.What is the best way and easy to accomplish this?If can, please provide a few samples or links.
View 4 Replies
Mar 26, 2011
I reffer users from my website to another website (not my own website, I dont have any access to code).How can I detect a user registered in this website I have reffered to....
View 2 Replies
Jul 23, 2010
There are various website speed test online tools available. Few of them are listed on: [URL] I tested my website using iweb and selfseo. My website is showing 0.03KB Average speed per KB everywhere. Even google also is giving same kind of results.I tested the site using Page Speed and YSlow. I have already followed most of the recommendations suggested by these tools like efficient use CSS, contents across the domains, caching, compression and all. But still I am getting the same average speed per kb. Page speed is showing around 85/100 as my page speed score, so I guess I have optimized my site a lot. My questions here are:
1. What are the other factors affecting the avg speed per kb of a website?
2. How to improve the Avg speed per kb?
3. Is there anything related with the Server Software and Hardware that I have to check?
Note: I tested by uploading a plain html page with simple text "Hello World", but the avg speed per kb is the same for this page as well. Same is the case with the rest of the pages.
Application Platform : ASP.Net 3.5, C#3.0, LINQ as Data Access, SQL Server 2008
Server Platform : Windows Server 2003.
View 2 Replies
Aug 5, 2010
I want to create a suite of three products. One is a website, so that is set in stone. Another is a mobile application, so that will be written as an application (for whatever devices). The third product is something that the user can use locally on their machine. However, I'm not sure if I want to make it a desktop application or a local website. With a desktop application, if I make a significant change to my business rules, I have to make it in three places (assuming the dll change needs a GUI change). However, if I make it a local website, then almost everything would be the same as the regular website. Desktop applications seem to provide more controls that are easier to use though. And since I'm taking this project on alone (right now) easy sounds best. But I don't want to sacrifice easy now for easy later.
The website I want to write will be using MVC architecture. I'm not even sure how to deploy a website yet either to a server or to a local machine. The only thing I've done was set up a local website before for a website that was already created in house by my co-workers. And that was solely ASP.Net, no MVC architecture.
My questions are:What do you guys think would be best in the long run; a local website that mimics the regular website or a desktop application?
Is there a way to create an install package to install a website so the user doesn't have to tinker with their computer at all?
View 4 Replies
Feb 25, 2010
A classic scenario for you to ponder over and feedback to me.I have been requsted to create a website. So far so good.But the site will have a total of 1 (ONE) page only.The page itself will only contain a form that users will submit.it will:1 - Register the details in the form into a single database table.2 - Send an email out to the customer and form admin to processI am thinking 2 ways of doing this:Plan A - Create the usual asp.net website with only one page saving directly onto database table.Plan B - Create a HTML page only,use javascript to send the data to a WCF service, which processes and saves the data.
View 3 Replies
Oct 11, 2010
Where to store file locations in 3-Tier Architecture Website?
View 4 Replies
Dec 11, 2010
I have almost 100 website that will update in a condition, I have a winzip archive that contains the files that replaces those websites. I want to know that
I can extract that files in a folder and then copy them to all 100 websites folders
I can extract the archive directly to 100 websites folders
which one is better in performance and less prone to errors
View 1 Replies
Nov 22, 2010
Does anyone has a idea how to write code for a search box to look for keywords,etc inside the website or sitemap?
View 11 Replies
Nov 17, 2010
I want to undertand and change an existing website which was written long time back. It cntains a lot of code and I dont know where to start as there is no dicumentation.Is there any way by which i can create a class diagram and sequence diagram of the existing one as I want to incorporate all the existing functionalities in the new one and dont miss out anyone. Only way I know is to debug the current application and go through whole of the code individually. Is there any way out by which I can undertand the current application quickly?
View 1 Replies
Jul 10, 2010
how to integrate the option to pay with credit cards on the website:
* Visa
* MasterCard
* AmericanExpress
* Diners
* Discover
* Cirrus
* Maestro
View 5 Replies
Apr 22, 2010
I'm quite newbie and i need to give access to the website at a very low cost, but just few people, how did you guys manage it, to hide the connection link to the public. I mean is there a better way or not to manage this. I don't know if I'm clear. What would be the cheapest way to manage this user account?
View 4 Replies