Click here to Skip to main content
       

C#

 
GeneralRe: How to convert string to Datetime including milliseconds PinmemberVijay Kanda11-Nov-12 20:15 
GeneralRe: How to convert string to Datetime including milliseconds PinmemberBobJanova11-Nov-12 23:10 
Questionhow to sort Datalist using Dropdown which is not in the datalist control Pinmembersreerajsn1237-Nov-12 22:19 
Questiondatagridview child rows Pinmembermynamearan7-Nov-12 21:18 
AnswerRe: datagridview child rows PinmentorWayne Gaylard7-Nov-12 22:14 
GeneralRe: datagridview child rows PinmemberMycroft Holmes7-Nov-12 23:08 
GeneralRe: datagridview child rows PinmentorWayne Gaylard7-Nov-12 23:32 
QuestionC# linq to sql default problem Pinmembersc steinhayse7-Nov-12 13:57 
In a C# 2010 application, I used linq to sql to setup my database connections.
Now when I move the application to a different database, the original database is still being used. Basically the connection string is hard coded into theapplication.
 
I tried to follow the linq listed below, but everything did not work.
http://goneale.com/2009/03/26/untie-linq-to-sql-connection-string-from-application-settings/
 
The part that says, "1.Open up the LINQ to SQL designer, and open the Properties tab of the designer (the schema itself),
expand Connection and set Application Settings to False. ", I did not see this option.
The closest thing I found was connection and I set that value.
 
Here is the way the code looks now in the *designer.cs file.
 
namespace e_ClScripts
{
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Data;
using System.Collections.Generic;
using System.Reflection;
using System.Linq;
using System.Linq.Expressions;
using System.ComponentModel;
using System;
 

[global::System.Data.Linq.Mapping.DatabaseAttribute(Name="DEV")]
public partial class eDataContext : System.Data.Linq.DataContext
{
 
private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
 
    #region Extensibility Method Definitions
    partial void OnCreated();
    partial void Inserte_Detail(e_Detail instance);
    partial void Updatee_Detail(e_Detail instance);
    partial void Deletee_Detail(e_Detail instance);
    partial void InsertIBook(IBook instance);
    partial void UpdateIBook(IBook instance);
    partial void DeleteIBook(IBook instance);
    partial void InsertIPackage(IPackage instance);
    partial void UpdateIPackage(IPackage instance);
    partial void DeleteIPackage(IPackage instance);
    partial void InsertIError_Tran(instance);
    partial void UpdateIError_Tran(IError_Tran instance);
    partial void DeleteIError_Tran(IError_Tran instance);
    partial void InsertTransaction_Type(Transaction_Type instance);
    partial void UpdateTransaction_Type(Transaction_Type instance);
    partial void DeleteTransaction_Type(Transaction_Type instance);
    partial void Inserte_Tracking(e_Tracking instance);
    partial void Updatee_Tracking(e_Tracking instance);
    partial void Deletee_Tracking(e_Tracking instance);
    #endregion
 
public eDataContext() : 
base(global::e_ClScripts.Properties.Settings.Default.DEVConnectionString, mappingSource)
{
OnCreated();
}
 
public eDataContext(string connection) : 
base(connection, mappingSource)
{
OnCreated();
}
 
public eDataContext(System.Data.IDbConnection connection) : 
base(connection, mappingSource)
{
OnCreated();
}
 
public eDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
base(connection, mappingSource)
{
OnCreated();
}
 
public eDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
base(connection, mappingSource)
{
OnCreated();
}
 

Here is what the app.config file looks like right now:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="e_ClScripts.Properties.Settings.DEVConnectionString"
            connectionString="Data Source=instance1\DEV;Initial Catalog=dev3;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>
Can you tell me or show me in code how to fix my problem so the application does not
use the hard-coded values that were setup by linq to sql?
AnswerRe: C# linq to sql default problem PinmemberMycroft Holmes7-Nov-12 14:12 
GeneralRe: C# linq to sql default problem Pinmembersc steinhayse7-Nov-12 19:14 
GeneralRe: C# linq to sql default problem PinmemberMycroft Holmes7-Nov-12 19:26 
AnswerRe: C# linq to sql default problem Pinmemberjschell8-Nov-12 9:49 
QuestionReplicate a class from an assempli and add a new constructor PinmemberTheGermoz7-Nov-12 12:45 
AnswerRe: Replicate a class from an assempli and add a new constructor PinmemberMycroft Holmes7-Nov-12 14:07 
AnswerRe: Replicate a class from an assempli and add a new constructor PinmentorDaveyM697-Nov-12 19:42 
GeneralRe: Replicate a class from an assempli and add a new constructor PinmemberTheGermoz7-Nov-12 23:41 
GeneralRe: Replicate a class from an assempli and add a new constructor PinmentorDaveyM698-Nov-12 19:39 
GeneralRe: Replicate a class from an assempli and add a new constructor PinmemberAndy4118-Nov-12 21:53 
QuestionHow to structure my application PinmemberASOSEA7-Nov-12 2:11 
AnswerRe: How to structure my application PinprotectorPete O'Hanlon7-Nov-12 2:34 
GeneralRe: How to structure my application PinmemberASOSEA7-Nov-12 3:53 
AnswerRe: How to structure my application PinmemberMycroft Holmes7-Nov-12 12:34 
QuestionConvert PPT to image Pinmemberer.neelkamal7-Nov-12 1:54 
Questionhow to report the single record into crystal report Pinmembersri apple6-Nov-12 21:02 
AnswerRe: how to report the single record into crystal report PinmemberMycroft Holmes6-Nov-12 23:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 18 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid