|
If I have a system where the client instantiates a business object and then the business object calls the DAC and then the DAC calls the database then is the business object an example of a facade design pattern?
|
|
|
|
|
Not really. A Facade presents a simplified composite interface to work with, while sitting atop and masking an underlying morass of interfaces that actually makes everything work.
If for example you had data coming from multiple sources (e.g. a sql server db, a web service and an xml file), then your business object would be a facade, or if the DAC returned a single source of data (e.g. DataTable, DbDataReader etc) then it could be considered a facade as it's collated data from multiple sources but exposes only a composite (and in theory would save changes to the correct location).
I'm largely language agnostic
After a while they all bug me 
|
|
|
|
|
It seems like my example of a business object would match the definition of a facade design pattern described in wikipedia because it "provides a simplified interface to a larger body of code" - http://tinyurl.com/3s22hk[^]
Do you agree?
|
|
|
|
|
I am trying to make sure that I use the preferred implementation for returning a DataSet in ADO.NET 2.0. The following code seems to be the best way to me. Please let me know if it can be improved:
using (SqlConnection connection = new SqlConnection(_connectionString))
{
using (SqlCommand command = new SqlCommand("MyTestSP", connection))
{
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
adapter.Fill(ds);
return ds;
}
}
|
|
|
|
|
Looks OK if that's what you want to do. But...
Do you really need a DataSet or will a single DataTable do?
I would do new SqlCommand("MyTestSP", new SqlConnection(_connectionString) ), but that's just me.
Other than that, are you sure you won't need the Connection and Command again? I prefer to create a Connection and Command and use them multiple times throughout a program's run. If you're doing that Web crap it may not matter.
|
|
|
|
|
While I retain the connection I always use a new command object. And yes I find the datatable more satisfactory to manipulate, although the overhead would be identical.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The Current Design:
You click on the shortcut and a window pops up asking you for the source directory and target directory. You provide this information and then the files in one directory get copied to another directory. When I schedule this to run as a automated task, the window always pops up asking for the source dir and target dir.
What I would like:
When you schedule the program to run as an automated task, it doesn't ask the user for the source and target directories. If the user needs to change the source and target, they double click on the shortcut and the interface pops up again asking them for the source and target info.
Question:
How do I do this in C#?
|
|
|
|
|
Hi,
I think your problem is more about design rather than any particular language. If I read you correctly your current design is interactive and prompts the user for source and target directories.
When running unattended what is your source of directory data? One solution would be to provide a command line interface. e.g.
FileCopier srcdir targetdir
Your code could then do the following:
1) If there are any command line arguments assume that this is an unattended run.
2) Validate the arguments to ensure that the directories exist.
3) Perform your actions on the src and dest directories.
4) Write a log file so that you can check what happened when you weren't there.
Hope that helps, ....Alan.
|
|
|
|
|
Check System.Environment.UserInteractive
|
|
|
|
|
Thank you both. I will try your suggestions.
|
|
|
|
|
Hey there,
I'm really stuc and would appreciate anybody's help on this..
I am using visual c# express edition (windows forms app) and need to on Form_load event open a textfile that i specify in the code automatically and display its contents into a textbox on my form. Below is an example:
on form load
open c:\hello.txt
read c:\hello.txt
insert c:\hello.txt into Textbox.Text
-- I know that that above example is nothing like the way you'd code it but i'm am completely stuck on this pls help! i'd really appreciate it, thank you
|
|
|
|
|
Welcome to CodeProject ![Beer | [beer]](https://www.codeproject.com/script/Forums/Images/beer.gif)
I strongly urge you to use beginner based materials to start learning how to program rather than asking questions on internet forums. Things like books or tutorials found on the web. We have a large collection of Articles here at CodeProject some of which are targeting beginners. You can find those articles under the Chapters section of the site menu.
I believe most people will learn beginner level subjects much faster from coordinated material rather than using internet forums.
led mike
|
|
|
|
|
Check out msdn and look at the FileInfo, DirectoryInfo, StreamReader, and StreamWriter classes. MSDN gives some good examples as to how to use these classes.
|
|
|
|
|
jay_t55 wrote: on form load
open c:\hello.txt
read c:\hello.txt
insert c:\hello.txt into Textbox.Text
As its been already said that you should first read the basic of c#(infact programming).
My suggestion is that even ebfroe posting the question try to Google its out. a simple serach would have yield this [^]result for you.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
How can I write the C# code that would allow me to view an image file using a viewer control. I want to be able to say:
On selected index changed
read System.Byte in the Details_dwg field
Load into viewer control.
|
|
|
|
|
technette wrote: How can I write the C# code
I prefer to use a keyboard. 
led mike
|
|
|
|
|
New to C# and am under the gun. Please include keyboard stroke.
|
|
|
|
|
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
Control myControl = FindControl("dwgViewerCtrl");
const string sql = "SELECT Detail_dwg @Detail_dwg FROM Detail_Info WHERE [Detail_ID] = Detail_ID";
using (SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["DetailsDBFConnectionString3"].ConnectionString))
{
myConnection.Open();
myControl = BoundField("@Detail_dwg", imageBytes);
}
Not finding my SQL Connection. WHY? 
|
|
|
|
|
I'm trying to create a report with a crystalReportViewer, who knows if it is possible to make a scroll bar scrolling not only one page but through all pages?
Thank you.
|
|
|
|
|
Hi everyone.
I have wrote a little program which uses mysql server, but now I need to remove mysql server and you some sql database witch do not need to you another install application...
Anyone has any ANYYY kind of tip??
Thanks A LOT in advance.
|
|
|
|
|
You want to replace MySql database with MS Sql database for your application?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi!
I need to replace the mysql for any other database type... Because...
The client doesn´t want to install anything else besides my application and I don´t want to lose my implementation with "insert"s "delete"s and "update"s....
|
|
|
|
|
|
|
Hey guys.
Can we show an object (for example an imageBox) by toolTip ?
Thanks in advance .
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
