|
The problem was solve
thats;
we can change this rows
Assembly asm = Assembly.GetAssembly(typeof(DataClasses1DataContext));
var query = db.GetTable(asm.GetType("Customer"));
new row
Table<customer> _customer = this.Context.GetTable( typeof(Customer) ) as Table<customer>;
thank you, leppie
|
|
|
|
|
How to Identify Smart card reader on PC?
Which API should be used to pick data from these readers.Can you give me small example or link?
Thanks in Advance.
|
|
|
|
|
I have two factory classes that both return a generic list of a data object class. Currently the code is using a switch statement to call a particular factory depending on some input. Code below the switch statement below depends on getting the list of data objects from different sources, but processing them the same.
List<Product> products = null;
switch (i)
{
case 1:
products = ProductFactory.GetProducts();
break;
case 2:
products = ItemFactory.GetItems();
break;
default:
break;
}
The problem is that if I want to add more factories from different sources... I would have to rewrite the code for the current builder class, i.e. add more statements to the switch. Since an unknown number of factory calls could be made to get the data objects from different sources (one factory returns from Oracle, one from SQL one from SAP, etc) the code needs to accommodate any new factory sources without having to recode.
Is there an easy way to accomplish this, please show me some sample code if there's a way to do so.
Thanks
-----------------------------
If you don't go after what you want, you'll never have it.
If you don't ask, the answer is always no. If you don't step
forward, you're always in the same place. -Nora Roberts
|
|
|
|
|
I guess you need a FactoryFactory. 
Like you 'lookup' them by index now, just place it in a list (array), and lookup the index.
|
|
|
|
|
Hi there, I'm not sure if I followed what you meant here? Could you perhaps show me some sample code? I'd really appreciate it!
-----------------------------
If you don't go after what you want, you'll never have it.
If you don't ask, the answer is always no. If you don't step
forward, you're always in the same place. -Nora Roberts
|
|
|
|
|
sam L wrote: Hi there, I'm not sure if I followed what you meant here? Could you perhaps show me some sample code? I'd really appreciate it!
Something like:
Factory[] factories = { new AFactory(), new BFactory(), etc };
int index = ??;
Factory f = factories[index];
List l = f.GetList();
|
|
|
|
|
Thanks a lot for the sample code...I guess the indexer here would be numbered based, so I can initialize the int index = 0??? But how is it going to get incremented for the subsequent factory values (AFactory, Bfactory, etc)????? Should there be a loop???
Can you please clarify?
-----------------------------
If you don't go after what you want, you'll never have it.
If you don't ask, the answer is always no. If you don't step
forward, you're always in the same place. -Nora Roberts
|
|
|
|
|
It's your code, you should know what it does. If you are not familiar with the pattern you are using, please read up on it.
Your 'indexer' (key really) can be based on anything if you use hashtables instead.
Lastly, why do you want to loop? Do you want to combine the data maybe? Then do that after you got the data. Solve one problem at a time.
|
|
|
|
|
You can add your object into hash table.
Then you can use has code value in the switch statement.
|
|
|
|
|
dibya_2003 wrote: Then you can use has code value in the switch statement.
That is exactly what you should not do! You simply look it up by the key, without the need for a switch.
|
|
|
|
|
I am not sure I got your question. How about something like this ?
class Program
{
static void Main(string[] args) {
List<Product> sapProducts = ProductFactory.GetProducts(new SAPFactory());
List<Product> oracleProducts = ProductFactory.GetProducts(new OracleFactory());
}
}
abstract class BaseFactory
{
public abstract List<Product> GetProduct();
}
class SAPFactory : BaseFactory
{
public override List<Product> GetProduct() {
return new List<Product>();
}
}
class OracleFactory : BaseFactory
{
public override List<Product> GetProduct() {
return new List<Product>();
}
}
static class ProductFactory
{
public static List<Product> GetProducts(BaseFactory factory) {
return factory.GetProduct();
}
}
This allows you to add new factories easily without modifying any code. You can keep the factory names in a XML file and load it at runtime using reflection which gives you full flexibility on adding new factories.
Is this what you are looking for ? Correct me if I got you wrong.
|
|
|
|
|
hi all,
actually we developed windows application using (Visual Studio 2008 C# & LINQ and sqlserever 2005 express edition).and i have to create setup and deployment for this project. i was added new project as "setup and Deployment" for my windows project .And i also included all the prerequisites to my project.exe layer.but main problem is "How can i deploy the database in Client machine ".
i tried this in client Machine :
it was installing All the Prerequisites in Client machine ,it was runnig succcesfully ,but it was showing "user is not trusted user" ,How can i solve this ,could u please help me,and i was strucking from last 3 weeks.
i got the below error:
============================
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
<configuration>
<system.windows.forms jitDebugging="true"/>
</configuration>
When JIT debugging is enabled any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.
=============================
i tried this, but it is not working ,it was showing bellow error message
" Login Failed for user .The user is not associated with a trusted Sql Server Connection ",main thing is i want to deploy the database in client Sql server . And how can i do this ,could u please help me .
Thanks in advance
|
|
|
|
|
this is only required if you have installed Express Edition.
Open "SQL Server Management Studio Express
Connect to your Database
Right Click on the Database in Object Explorer
go to Properties
select "Security"
Now in Server Authentication Mode
select "SQL Server And Windows Authentication Mode"
Restart the SQL Server Service (if you dont know how then restart the computer)
if still have the problem then
go to
Start
SQL Server 2005
Configuration Tools
SQL Server Surface Area Configuration
Then select "SQL Server Surface Area Configuration for Service & Connection"
now select "Remote Connection"
tick on "Remote and Local Connection"
again tick on "Use Both TCP/IP and Named Pipe"
Now go to Service "Stop" it and then "Start" it.
also its not advisable to use "sa" user at deplyoment (client side).
create one database user and give it specific rights
there are 2 ways
either you specify the sql script at the deployment project, or you can run set of sql commands from the application, if the application cannot connect to specific database in sql server (for this you have to connect to the sql server using Windows Authentication mode).
|
|
|
|
|
Hello all,
I've been assigned a bug in a multi-threaded windows application method that serves lookup data. The method fills a static list object full of simple data objects. When only one thread hits the method the method executes rapidly. The SQL stored procedure that is returning the results is optimized and runs quickly. You can test it using a T-SQL call and it runs in less than a millisecond. When one thread accesses the method the code returns just as quickly. But when more than one thread hits the method at the same time load up of the static list object becomes slower in an exponential fashion, driving system resource usage up and taking much longer than expected. After the list runs then the usage drops again, since the method is no longer called until the application is recycled.
private static List<DataObject> _list = null;
public static List<DataObject> GetList()
{
if (_list == null)
{
_list = new List<DataObject>();
SqlDataReader reader = null;
SqlConnection connection =
new SqlConnection(ConnectionString);
SqlCommand command = null;
// Set up a new command
command = new SqlCommand("GetList", connection);
command.CommandType = CommandType.StoredProcedure;
reader =
command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
DataObject instance = new DataObject();
instance.ID = reader["ID"] != DBNull.Value &&
reader["ID"] != null ? (int)reader["ID"] : 0;
instance.Name = reader["Name"] != DBNull.Value &&
reader["Name"] != null ? (string)reader["Name"] :
string.Empty;
_list.Add(instance);
}
}
}
Please help me out here, I'm not sure what is causing this behaviour??? Is there something in the code that needs to be fixed???
I'd really appreciate it!
Thanks
Tina
|
|
|
|
|
Tina P wrote: But when more than one thread hits the method at the same time
Are multiple threads trying to populate the list at the same time? Try locking
MSDN Locking
hope this helps
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hello Bob,
I think that is precisely what's happening...i looked into locking a little bit, but I can't quite figure out where to put the lock statements and where to unlock? Would you be able to point me in the rite direction and perhaps show me some code? I'd really appreciate it!
Tina
|
|
|
|
|
i think that the list being static is the bottle neck...
static means "only a single copy of that member can exist at any given time, regardless of how many copies of a class are instantiated".
what i think is happening is thread A, B and C start the method 1ms after each other for arguments sake. let say the method takes 1000ms to complete.
thread A will get access to that static object but B and C will have to wait for A to finish its work with it before B and C may access it. so you expect 1000ms for the three threads to complete the task but now that they have to wait for each other its taking 3000ms.
im not sure if im right but its what makes sense to me, hope it helps
BTW, please use PRE tags when posting code... no one wants to read non-indented code
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.passion != Programming)
|
|
|
|
|
Interesting observation Harvey...I didn't even think about the list being static, but now that you mentioned, its a valid point. However as Bob suggested, I was trying to play with locks on this. I have never done anything multithreaded so I'm not sure how to accomplish that? Any ideas.
On the flip side, if I make the list not static (instance driven) then the whole method needs to be re-writen....see I;m trying to fix this bug with minumum effort so I won't break anything else?
Any thoughts???
Thanks
|
|
|
|
|
i dont think locks will solve the problem because a "lock" might be causing it.
while thread A is using the static object its "locked" from the other threads that also wants to use it, causing them to have to wait for it to be "unlocked".
once again im not sure if this is in fact how the threads are responding to the static object, its just an assumption.
what id do to make sure my assumptions are correct is write a small test app with a static method and multiple threads trying to access it. Then use multimedia timers(these are alot more accurate than System.Windows.Forms.Timer) to see what is happening when and then draw up your own conclusion based on the results.
Then from there you can decide if rewriting the method is necessary
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.passion != Programming)
|
|
|
|
|
It could be as Harvey says, but I suspect a conflict. Using statics for 'static' data is the usual way to do it. I always put a lock on and have yet to experience the problem described (but that doesn't mean it won't happen next time!).
I would code it more or less as per the msdn link
Object thisLock = new Object();
public static List<dataobject> GetList()
{
lock (thisLock)
{
if (_list == null)
{
_list = new List<dataobject>();
etc etc
}</dataobject></dataobject>
The best bet is to try it - its a minimal code change to add the locking.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi!
You'll also have to make the thisLock static since instance members cannot be accessed from a static function.
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
Very true - copy and paste from MSDN article error 
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Take a look at this question:
If a class does not implements IEnumerable interface,which of the following is cannot be used?
a. GetEnumerator()
b. ForEach
I had to choose one option and I think both are true. Am I correct?
(It was an online test on a widely used website)
modified on Tuesday, July 8, 2008 1:19 AM
|
|
|
|
|
I can create a method on any class called GetEnumerator(), it doesn't have to have anything to do with IEnumerable. Eg
public class DumbClass {
public string GetEnumerator() { return "Good morning";}
}
Not very useful but now I can say
DumbClass x = new DumbClass();
Console.WriteLine(x.GetEnumerator());
ForEach needs an implementation of IEnumerable.
|
|
|
|
|
PaulLinton wrote: I can create a method on any class called GetEnumerator(), it doesn't have to have anything to do with IEnumerable
I meant the one that comes with the interface.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
