|
Apart from not knowing exactly how a lower layer does something, "removing dependency" could also be considered as "not knowing WHO is doing what I need to do", and that is acomplished using Interfaces.
So you go from not only not knowing how, but neither knowing which class is the one that implemented the interface and is executing whatever you need from the lower layer.
Why would you do something like this for a DAL? Two main reasons, first not to depend 100% on an implementation for a specific database engine (ie SQL Server), but to have an interface that could be implemented for different storage mechanisms; and second for testing purpose! Imagine you could automate your tests by implementing a piece of your DAL (interface) from a dummy class (either mock or stub) just to test your upper layers (probably business).
|
|
|
|
|
Guys, I felt this was very appropriate for us in here. We used to have less than flattering terms for this guy (i.e. squatter) but Joel Spolsky calls him the "Duct Tape Programmer".
http://www.joelonsoftware.com/items/2009/09/23.html[^]
Fear not my insanity, fear the mind it protects.
|
|
|
|
|
Discussed at some length here[^].
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
you have no friggin’ idea what this frigtard is talking about, but he just won’t go away
Well said by Joel. I've worked with these types of individuals in the past and can relate.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I need to design a system which will process hundreds of source files (different format) and convert to one target files.
There should be two interfaces
1. Command line
2. web user interface
Command line interface is to run the transform job though batch and web user interface is to define the format of source file and mapping details of source file to target file i.e. one time job for each source file.
All the source files are fixed width or delimited files.
What is the correct approach?
Should I create one stage table for each source file to the stage data?
Should I create one stage table on runtime when user will define of layout (Most are fixed width mainframe files) of source file?
Should I create only one generic table, containing around 100 columns all varchar type?
I am looking for the best approach to design the system. Performance is very critical for this app. There are hundreds of files and we need to transform all the files daily within certain time.
Thanks in Advance
Akshay
Lucky akky
keep smiling
|
|
|
|
|
I've built many of these and not once have I used a command line interface. I use a service to do timed and repeated processing.
Generally I use a separate staging file/database for each source file/set. I find you can usually group the files into sets which have the same data structure. I also use stored procs to do the processing from the staging tables to the final data table, this may be frowned upon as it is less flexible than a full ETL tool but I find it suits my style.
I ended up with a winforms app that allows the user to configure a file for loading, defining the title and data rows, the delimiter or column widths and create a staging table with varchar fields so I can either BCP or bulk copy into the staging table. I then assign 1 of about 8 procedures to process to the final data table.
BCP in 2005/8 is more fragile than 2000 so I use bulk copy a lot, slower but more robust.
|
|
|
|
|
Create run time stage table depending upon the format of targetting file.....
|
|
|
|
|
Hello Good people,am not so sure if this should go here,i am student who is interested in developing a search engine that indexes pages from my country.I have been doing my research on Algorithm to use for sometime now and i have found HITS and PageRank as the best out there.I have choosing to go with PageRank since it is more stable than the HITS Algorithm(so i read).
I have found countless articles and university researches about PageRank but my problem is that i do not understand most of the mathematical symbols that form the algorithm in this papers.Currently,i cannot understand how the Google Matrix(the irreducible,stochastic matrix) was calculated with the algorithm,i do not seem to understand the Algorithm used.
I did my reading from the articles below:
PDF 1
PDF 2
Please i need you to help me go through it,i need a basic explanation(examples will be nice) with less mathematical symbols.
Thanks in advance.
|
|
|
|
|
the CP rules state you choose one appropriate forum and ask your question there; don't post the same stuff in multiple forums, it will not help you.
Luc Pattyn
Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Hi,
I am working on shared add-in in c# for Excel. Let us consider 3 components A,B,C. Where A is a Shim,B is Shared an add-in(used IDTExtensibility interface) which creates all tool bars, menu items for Excel and C is an automation add-in which contains UDFs.
I have static property in Automaion add-in(C) which set/gets Excel Application object. Whenever OnConnection(..) of shared add-in is called from the framework, I am setting the Excel application object using this property. So When I type some UDF in Excel, it uses this Excel application object for further work on Excel.
Recently I tried to remove the Shim and put the VSTO on it. When I use VSTo, it doesn't use shared add-in.Here also I set the Excel application object by using static property. Now I have I enabled this Auotomation add-in(add-in->Options->Automation Tab).But when I type some UDF in Excel cell, excel object is not available that is set from VSTO.How do I pass reference to Excel object to Automation add-in so that the same Excel Object is available in Automation add-in when we type some UDFs.
What I observed here is VSTO and Automation add-ins are working in different AppDomains.
Please help me.
Thanks.
|
|
|
|
|
I would post this in the C# section if I was you. It is not a design and architecture question so you are unlikely to get an answer here.
|
|
|
|
|
Hi,
I am working on a project where i need to get some data from data base and then perform some conditional operation on them , and then I need to display that information at UI, in a list box.
Please suggest a good design patten for this.
|
|
|
|
|
Choose, you must;
- MVP
- MVC
- MVVM
Check this link[^] if you're having trouble choosing the appropriate pattern
I are Troll
|
|
|
|
|
Thnx buddy
|
|
|
|
|
Hi ,
Let me make myself clear something first before proceeding with this post
I don't want to create any new architecture or framework or design pattern.
I want to make use of the existing tools and come up with a poc.
Now let me explain the problem statement
Requirement:- to build a windows app
Technologies and database used:-
Visual studio express edition 2008/
C#/
winforms or WPF/
sql server compact edition/if it is a multi use application SQL server Express edition will be used
The application will be very simple with not more than 20screens.
The underlying database will contain not more that 25tables.
Even if it is a multiuser application the number of user will not be more than 5 at a time.
The application will be used by a large number of people so bug fixing and introducing new features should be a breeze.
The app will be having basic CRUD screens and the Business logic involved will not be too complex.
To achieve this even if a Learning curve is involved it is acceptable.
The time to market of the resultant should be very less.
I want to develop the app for the above scenario. My goal is to develop a application with minimum number of lines of code. I Binged and found a lot of results like to use N-hibernate for ORMapping/or use Microsoft Enterprise library/Prism framework etc.,
I would like to know which framework or design pattern should I use to achieve the above functionality with least coding. I don't want to go with any third party tools. Pointers would be welcome.
I want to develop and give it to the open source community as a POC for fast and effective programming for small scale applications.
|
|
|
|
|
Try some of the articles here on Code Project on the subject of MVP/MVVM patterns. See also the answers to the question below.
jarajeshwaran wrote: My goal is to develop a application with minimum number of lines of code.
I'm not sure how you would achieve this unless you are a super-coder.
|
|
|
|
|
jarajeshwaran wrote: The application will be very simple with not more than 20screens.
The underlying database will contain not more that 25tables.
That doesn't add up; I'd expect a "list"-form and a "details"-form for every entity, allowing you to browse the entire collection or edit a single entity.
jarajeshwaran wrote: Even if it is a multiuser application the number of user will not be more than 5 at a time.
The application will be used by a large number of people so bug fixing and introducing new features should be a breeze
New features could be introduced with a plugin-system, you could opt to load an assembly dynamic. There are some articles on CP explaining how to do such a thing
jarajeshwaran wrote: The app will be having basic CRUD screens and the Business logic involved will not be too complex.
So a generic CRUD-form would suffice?
jarajeshwaran wrote: The time to market of the resultant should be very less.
I'd walk away as soon as this sentence drops, without any hesitation. The TTM should [b]never[/b] be confined by the manager. Imagine you selling a house with a limited TTM: would you sell it without a roof?
--edit--
As I've been told, the houses are sometimes already sold before the drawings are even agreed upon. There seem to be special constructions to ensure that you get a roof. And that construction won't grind to a halt midterm.
jarajeshwaran wrote: I would like to know which framework or design pattern should I use to achieve the above functionality with least coding. I don't want to go with any third party tools.
The .NET framework, and databinding
I are Troll
modified on Friday, September 18, 2009 4:09 PM
|
|
|
|
|
Hi everyone,
m trying to understand design patterns .. which one to use when .. most popular ones .. most used in normal projects .. and some good examples ... im tired of vegetables and doctor examples ..
any help would be appreciated
and preferably with code 
I am also in need of a big project where I can see all the things working together .. that will help a lot in understanding .. if any one can share .. that would be a great help
Thanks
Vishwjeet
|
|
|
|
|
Hi,
have a look at these[^], I trust the vegetable ones are only a minority.
|
|
|
|
|
|
Currently I have something like this. Each table in the database has a class, a select and update (includes insert) procedure and usually a bunch of GetFor##### procs (CustomerGetForRegion, CustomerGetForBranch etc).
Many table also have a view (vwCustomer) that gets all the related labels, where the customer table stores the CustomerTypeID the view gets both the CustomerTypeID and the CustomerType. So typically a view has 2-6 joins. The GetFor#### use the view.
My dilema comes when creating the classes in C#. I natirally have a Customer class with all the ID fields and possibly a couple of list<> of child objects (Addresses, Contacts etc) but what about the labels CustomerType etc.
My customer class has 2 methods, GetRecord and GetObject, fairly obvious that one gets the table and the other gets the view. Both then populate the Customer class (it has properties for the view columns that are not in the table).
I experimented with inheriting the ICustomerType but that got very ugly very quickly as all my classes have the data fields and the methods for CRUD and query in them. This left me with multiple methods and properties hiding each other.
I am now looking to split my classes into Customer and CustomerDB. One hold the data and services properties and List<> requirements and the other gets does all the DB IO.
The floor is now open for discussion, criticism and ideas.
|
|
|
|
|
I used to take the approach that an object should know how to persist itself, but now I always split the database access out into a separate object from the domain class as it seems to me to be a reasonable separation of concerns. One object knows about business logic, runtime behaviour, validation rules, etc. but does not know anything about persistence. Another object knows how to save and load to and from the persistence store, but does not know (or care) what the target classes are used for. I find this easier to work with, and it makes it easier to separate business logic and persistence logic for unit testing (if you are into that sort of thing).
Martin Fowler covered this in his Patterns of Enterprise Architecture book, where he calls it the Table Gateway pattern. Java people call it the DAO pattern, although that term has different connotations for .NET.
|
|
|
|
|
I have a DAL and then a single entity object, problem seems to be that a collection of the entity objects has one hell a lot of baggage in it.
I'm currently working through Josh Smith's[^] article on MVVM and wondering if the level of complexity is valid for LOB apps. I look at it from a down stream support aspect.
I am slowly coming around to the opinion that WPF/Silverlight is probably going to be the future UI to work with and the MVVM pattern seems to have a vote of confidence from some well respected people.
|
|
|
|
|
Hello experts,
I'm trying to design a framework for generating reports by storing the meta data in an XML.
The following are the sources (in both SQL / Oracle providers).
1) Tables/Views
2) Stored Procedures
3) OLAP Cubes
I'll write a wrapper to sync changes to these Tables/Views/SPs/Cubes so that the XML is up to date.
Tables/Views
============
The user will be able to store subset of the columns and filter criteria (1 or many) and should be able to run the same report at a later stage.
Stored Procedures
=================
Whenever the user wants to run the stored procedure, he/she will supply the parameters and get the output.
OLAP Cubes
==========
Predetermined cubes and/or cubes with specific members as parameters.
I'm thinking the following way using strategy pattern for retrieving data.
1) IReportData: Gets the report data in a dataset/cellset
2) IReportParameters: Gets report parameters (For SPs?)
3) IReportFilters: Report filters / criteria /criteria set
3) IReportSQL: The final executable SQL
4) IReportFormat: Rendering format
4) IReportRender: Final renderer
What do you guys think about this? Do you have any design pattern (s) that you would like to recommend?
Thanks,
RK.
You can never try. You either do it or you don't.
|
|
|
|
|
Hi
I have to do a project nemed "Recruitment Management System". I am in difficulty to make Different UML Diagrams. Is anyone can provide me the following diagrams for the system?
DFD Diagram (Context and Level-1)
Use Case Diagrams.
ER diagrams.
Activity Diagrams.
Sequence Diagrams.
Architectural design diagram.
Class Diagrams.
Database Design.
Deploymnet Diagram.
Test Cases for Use Cases.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Badger | [badger,badger,badger,badger...]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/badger.gif)
![Jig | [Dance]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/jig.gif)