Linq to sql truncating string returned by Stored Procedure -

-

I have asked this question before but I have no answers. Maybe I was not very clear, give me some more details.

I have an SP that gives a long string here is the DBML file code 

  [function (name = "dbo.spX")] Public IsingleResult & lt; SpXResult & gt; SpX ([parameter (dbtv = "ver variable (8000)") string straight) {IExecuteResult result = this.ExecuteMethodCall (this, (MethodInfo) (MethodInfo.GetCurrentMethod ()), str); Return ((IslingleSalt & lt; spXResult & gt;) (returning result.)); }

and spXResult class here 

  public partial square spXResult {private string _XML_F52E2B61_18A1_11d1_B105_00805F49916B; PublicSpexResult () {} [column (name = "[XML_F52E2B61-18A1-11d1-B105-00805F49916B]", storage = "_Xml_F52E2B61_18A1_11d1_B105_00805F49916B", dbiped = "newtext", update check = updatecack never)] public string XML_F52E2B61_18A1_11d1_B105_00805F49916B {Return it. _XML_F52E2B61_18A1_11d1_B105_00805F49916B; } Set {if ((this._XML_F52E2B61_18A1_11d1_B105_00805F49916B! = Value)) {this._XML_F52E2B61_18A1_11d1_B105_00805F49916B = value; }}}}

And here is my code 

  ISingleResult & lt; SpXResult & gt; Results = CTX SPX ("1234"); String Returns SRR = Results. First (). XML_F52E2B61_18A1_11d1_B105_00805F49916B;

Everything is fine, when the result is not a long string, but as soon as the SP gives a very long string, this result bites. I do not have any clue why .. anybody please help Can do.

Thank you

I have only one thing that I can see - it announced Hawa: 

  Public Isling result & lt; SpXResult & gt; SPX ([parameter (DbType = "VARCHAR (8000)")] string str)

(DbType = VARCHAR (8000)) - which ANSI (non-Unicode), but in column The announcement in which you use NTEXT - First of all, this is Unicode (2-byte per character), and why NTEXT ?? Do you have a VARCHAR? 

  [Column (name = "[XML_F52E2B61-18A1-11d1-B105-00805F49916B]", storage = "_ XML_F52E2B61_18A1_11d1_B105_00805F49916B", DbType = "ntext", UpdateCheck = UpdateCheck.Never)] < / code>

it seems a little strange .......

you can try to make it similar in both places? Like both the VARCHAR cases ??

Mark

(8000)

Comments

Post a Comment

Popular posts from this blog

How to Create Master-Details view using Asp.Net MVC framework -

-
I am evaluating the Asp.Net MVC framework for my enterprise application for the past few weeks. The one thing I'm trying to achieve is the master-detail view. As it is very clear that there is no vivestate and there is no postback. For example, now I am using the product, customer, order and order details table from the Northwind database and I am using the especial MVC. I want to make master-detail view. Basically I do not have to have separate ideas (pages of other words) for order and order details. View order and order details should be included. How should I design my controller and see how to get this functionality. Thanks & amp; Regards, Burhanuddin Ghee You want to write a domain-specific view-model class Adds an order and details from its order (I'm assuming that order-> order details are 1-> n relation, not familiar with Northwind): public class command view model (Public order order); Set;} public inenemable & lt; Order deletate & gt; ...
Read more

delphi - Mouseover hint for TChart series value -

-
I am using a TChart in Delphi 7, and I want to display charts sometime. I am using the following code to set the chain value to a database query: chart1.FreeAllSeries; Chart1.SeriesList.Clear; Chart1.AddSeries (TBarSeries.Create (self)); TBarSeries (chart1.Series [0]) BarStyle :. = BsRectGradient; Stop starting with Query 1; Executed; While EOF does not start chart1.Series [0]. Add (field 'flags' ('sum_actual_days'), Field Astrstring ('contract_no')); the upcoming; End; End; Each time (value) is now showing both the label below the bar and in a yellow rectangle above the bar. Rather than repeating the amount of label twice, I have some additional information from the query that I would like to show above the bar rather than the label (or, preferably, as a mouseover signal). Can it be done with TChart? And how ...? This can be done with a TChart using the onMouseMeave event of the chart. Something like this should start with you: Process TForm...
Read more

c++ - Linux and clipboard -

-
After selecting the copies of the buffer in Linux, after the text, we can click and paste the button between the mouse. I think there is a special buffer for this, I want to use it. Programming Language: C ++ Your Library: Qt Thanks. There is just one more correct answer than Paul Dixon, which answers your needs: / P > QClipboard * clipboard = QApplication :: clipboard (); CastString Selected Text = Clipboard-> Text (QClipboard :: Selection);
Read more