We have been using Microsoft Syncronization Framework for syncing up disconnnected laptops with a master SqlServer. Unluckily it has been an issue to correctly get all the dependecies installed and we also get weird errors sometimes. Are there any other commercial or open source alternatives that people have used that are easier and mor...
Given a set of entity ids, how can you efficiently delete the entities to which to ids represent, without first selecting the entity? Here is some code, I am using now, but EF profiler is complaining at me for running N+1 queries: var ids = GetSelectedIds(); foreach (var id in ids) db.Workshops.DeleteObject(db.Workshop...
In my application, I allow users to create a form containing any HTML form field they want (e.g. text input, textarea, select, etc.). I want to give the users the ability to define 0 or more cumulative validation rules for each field (there might be up to 25 different validation rules). How should I model this? Here's a potential soluti...
Hello: I have a WPF application that runs on a small database. Using clickonce or any one-click solution the users want to install the application locally and also set up the database at the same time. All users run SQL Server locally, so that is doable. Can someone tell me how I can do that using a single mouse click? Thanks PN ...
Is there an easy way to find identical tables, i.e. same structure and data, using MySQL and PHP? I doubt there is a MySQL command for it, but how would you recommend doing this? ...
So I'm looking at http://ohiostate.bncollege.com/webapp/wcs/stores/servlet/BNCBHomePage?storeId=33552&catalogId=10001 and was wondering if there was a way I could get all of the possible classes/options for the courses in a semester. There's a class locator on the top left of the page, and it has a dynamic drop down menu. Is there an...
We recently had some trouble with our production SQL 2008 R2 databases and had to failover to log-shipped warm spares for most of our databases. This morning I found some very odd GUID values scattered throughout our set of databases. For background, we have a main clients database, that holds various information about installed clients,...
I've got a wordpress multisite installation that's hosting enough blogs I need to shard the database. I see there are three plugins available to spread wordpress across multiple databases: http://wordpress.org/extend/plugins/hyperdb/ http://premium.wpmudev.org/project/multi-db http://wordpress.org/extend/plugins/shardb/ I'm trying t...
can we store binary data to apache cassandra? i'm thinking about storing image to apache cassandra ...
I need to represent Binary Search Tree as a DB schema? How do I do it? Its kind of problem. I dont have any code. I need direction how to show BST as a DB schema. ...
I am developing a facebook type application for my institute. and I am stuck at the friends module. i.e. How to know if the particular users are one's friends. I googled a lot but didn't get any satisfactory answers. What I got is : there will be many friends of a person and implementing users and their friends in seperate table will ...
Hi, I'm using the findDependentRowset() of the Zend-Framework. Here, I want to define some selection settings like ORDER or LIMIT. The examplecode I've found doesn't work at all for me :-( $table = new MyTable(); // extends Zend_Db_Table $row = $table->fetchAll()->current(); $rowset = $row->findDependentRowset( 'table', $table-...
I have some pretty complex reports to write. Some of them... I'm not sure how I could write an sql query for just one of the values, let alone stuff them in a single query. Is it common to just pull a crap load of data and figure it all via code instead? Or should I try and find a way to make all the reports rely on sql? I have a very ...
Hello to all, AFAIK, we all must programming to database through database wrapper/manager such as sqliteman or CppSQLite. But the database wrapper is specific to one type of database and this is not convenient for programmer cause require a lot of modification in case the database was cahnged. Therefore, i would like to write a gener...
Is there any way to insert java-script function between the query ?? For example :: In an query, i have stored date of birth like this 10101990 in the database, it means 10/10/1990, but I have display it in-front of page but in certain format like 10.10.1990 by using one java-script function. Please suggest me any way ?? ...
I created 2 models and ran the migrations, attempted some work on each of them and now I would like to start over and approach them differently. I'm new to Rails and have never attempted to delete/remove database tables (apart from rolling them back right after I migrated them). Thanks! ...
I'm writing a program that displays products and the stores at which they can be located. So far, I've been able to write an SQL query that displays data as follows: Product Availability Milk Store1 Candy Store1 Eggs Store1 Milk Store2 Eggs Store2 Candy Store3 Eggs Store3 Is there any SQL qu...
I've got a database under source control using a VS2010 database project. I'm trying to move some stored procs from the [dbo] schema to another schema. When I change the schema name in the project (moved in folder structure plus edited the CREATE to indicate the new schema) and deploy, I end up with a CREATE for the proc in the new sch...
Hi, I have a complicated system that is pushing data into an MDB file. The mdb filesize is currently at 40MB. Did anyone had any experience with larger mdb files and could tell me what is the maximum capacity that it will be still operational? (if it's dead slow at 150mb i don't call that operational). Thanks! ...
does anybody see database of hotels in popular cities of russia in russian language? ...