Tagged Questions
1
vote
0answers
24 views
LoaderLock Error
I'm facing a problem for connecting to my database .I wanna connect to one of my sqlserver's DB and I use SqlConnection but when I open my database connection there's an error with this title ...
1
vote
0answers
72 views
C# SQL Generator to execute the new T-SQL Window Functions in SQL Server 2012?
I'm looking for a SQL Generator that can execute the new window aggregate functions that were released in SQL Server 2012. I've already looked at Subsonic and LINQ, but haven't yet taken a look at ...
1
vote
0answers
33 views
How i can map a selected field into domain properties with LINQ To Entity
I use C# And EF5 CodeFirst. Sql Server 2012 And VS2012
I have multiple domains in the form below in Entity Framework.
public class Subscribe : BaseEntity
{
public Subscribe()
{
...
1
vote
0answers
178 views
SSIS Programmatic generation of an ODBC Connection
I'm trying to create an ODBC destination source in an SSIS package using methods like the ones described at http://msdn.microsoft.com/en-us/library/ms345167.aspx I can't seem to initialize the ODBC ...
0
votes
0answers
18 views
Custom Solution similar to Microsoft's Master Data Services
We are in the process of deciding whether to use Microsoft's Master Data Services (MDS) or building a custom solution which works similarly (editing, inserting hierarchies and dimensions).
We would ...
0
votes
0answers
39 views
Reading fixed length text file
I have a .dat file with format like this
00393 20121 2131 abd asdasd
990909 7887 09090jkj lk
so, the first column starts from 1-8, second from 9-15, ...
0
votes
0answers
25 views
Issue in Mapping between DbType and Type System.Data.Linq.Binary
I am developing a windows phone 8 app. I have created WCF application for executing stored procedure, sql statement etc. In that used Linq to Sql and added the tables and stored procedure.
I have ...
0
votes
0answers
43 views
SqlConnection and nested transactions
There's (still) no way to create nested transactions via ADO.NET / SQL Server 2012, correct? This ...
using (var sqlConnection = new SqlConnection(connStr))
{
sqlConnection.Open();
var ...
0
votes
0answers
25 views
How to infer relationships and cardinality from a database when generating code from the tables?
I'm working on generating code (models) from my database. I'm not sure how to, if possible, setup my database to create a relationship including cardinality. Is this something that can be done, or am ...
0
votes
0answers
52 views
Execute Store Procedure from Linq to Sql WCF
I have a stored procedure for getting user details. In that there is one input parameter i.e. @UserName. Here is my stored procedure
USE [Test]
GO
/****** Object: StoredProcedure ...
0
votes
0answers
22 views
The server may be running out of resources in aggregate functiond
I try to copy this code and to deploy this function to my server. When I try to create the function I get the message below. It's very strange to me because I don't use any unsafe resource.
I tried ...
0
votes
0answers
41 views
how to create tabcontrol from sql database data in C#
this is a continue from
how to get database (sql) table names and colums in C# to combo and list box
my program now:
1. connects to the database (microsoft SQL 2008/2012)
2. shows the tables via ...
0
votes
0answers
30 views
SQLServer Convert a Lambert 93 based Polygon to WSG84
I have a list of polygons based on Lambert93 coordinates that i've converted to WSG84 using C#, but the polygons now don't present correctly on the spatial tab of sql server 2012.
Is there a way to ...
0
votes
0answers
58 views
Connection managers with expressions in a script component in SSIS
Difficult question to describe, but here it goes. I have a Data Flow Task containing a couple script components and an xml-destination component (among a bunch of others, but these are the important ...
0
votes
0answers
240 views
c# .net 2.0 updating connection to database from oracle to sql server 2012 - upgrade from database links
I have a c# .net 2.0 application which connects to two separate Oracle databases.
Database1
Database2
It connects to Database2 through an Oracle database link in Database1.
In terms of the code ...
