Tagged Questions
0
votes
1answer
22 views
Linq DataContext.CreateDatabase() force SQL Server 2005
I'm using Linq DataContext.CreateDatabase() to generate a database. Currently it's generating a SQL Server 2008 database. I would like to know if it's possible to make CreateDatabase() generate a SQL ...
1
vote
0answers
44 views
Local database changes not saved after SubmitChanges()
I'm using local database to store my data. I have file *.sdf which I load from Isolated Storage, because I want my application to work also in offline mode, so if user doesn't want, he doesn't have to ...
1
vote
1answer
44 views
Local file-based SQL Server
I've written a fairly large C# Winforms application for a client which uses SQL Server for its database. This was initially designed and developed for their internal use in-house. They've decided that ...
0
votes
1answer
42 views
database windows phone 7 reading XML records
I need as much help as I can get. I have a website and there is a table named rss with id_rss, id_katigoria, id_upokatigoria, and linkrss fields. In the field linkrss I have xml files. For example ...
0
votes
3answers
59 views
how to select a weeks amount of dates from a database?
What I am trying to do is search my database (ado.net with linq to sql) for all entrys within the last week.
The database has a field called date and I need the entries that are 7 days previous to ...
1
vote
3answers
236 views
Hashing Password Database with LINQ to SQL
I am currently working on a log in form and I've heard the best way to store passwords is to hash them, but do I put the "hashed" passwords to the database(in a column where only byte data types are ...
0
votes
0answers
58 views
Cannot delete relation between tables immediately after addition
I am trying to create a database Windows Phone 8 App. When I was testing the app, I found that, I get an sqlceexception if I try to delete a parent item with a child item.
...
1
vote
1answer
30 views
LINQ to SQL Associations Not Generating
I created a basic database via SQL Server, with the tables generated by the following code:
CREATE TABLE [dbo].[Characters]
(
[ID] INT NOT NULL PRIMARY KEY,
[Name] varchar(MAX) NOT NULL,
...
0
votes
1answer
64 views
Linq to SQL Exception When Record is Updated from Two Different Applications
I am working with two C# Winform applications that use Linq to SQL for database access. All of my database access and queries exist in a DLL project that is referenced and used by both of these ...
1
vote
2answers
350 views
Convert Results of LINQ to SQL Query to XML/JSON
I wish to populate a JavaScript array with the results of a database query. From what I understand, a good approach is to populate a bunch of directories on my server with serialized XML or JSON files ...
1
vote
1answer
114 views
In Linq-to-SQL, does IMultipleResults hit the database more than once?
I have a stored proc as follows :
CREATE PROCEDURE GetMultipleResults
@SomeID int
AS
BEGIN
SELECT * FROM SomeTable1 where SomeColumn1 = @SomeID
SELECT * FROM SomeTable2 where SomeColumn2 = ...
1
vote
0answers
186 views
Adding the specified count to the semaphore would cause it to exceed its maximum count error
I am using the following code to access a local sql express database:
using (MessageBoxDbDataContext db = new MessageBoxDbDataContext())
{
var msg = (from msgs in db.messages
...
0
votes
1answer
116 views
LINQ to Sql DataBase access from background service in Windows Phone
I have a Windows Phone app which uses Linq to Sql to store and retrieve data from the DataBase which resides in Isolated Storage. Now if I create a background service for my app, whether the DataBase ...
0
votes
1answer
122 views
SqlException occures after changing Column properties in asp.net mvc 3
I have the following model: Item contains Product, Shipping, UserId (that created this product). "Item : Product" and "Item : Shipping" is "1:1" relationship). When I want to add new Product to the ...
6
votes
1answer
1k views
Local DB throws Byte array truncation to a length of 8000 exception
I'm trying to take a snapshot from a Map control as a WritableBitmap, convert it to a byte array and save it in the local DB. It works fine (I can convert the byte array back to the image) untill I ...
