Check Constrain in Data Generation Plan in Two Columns

Question

I have a Table with two columns say Col1 & Col2. Col1 is type is int and Col2 type is long. I have a check constrain : any one of the column must have a valid value and the other column should be null. That is both columns cannot be null in a row. Both cannot be filled up with valid value in a row. Both columns are foreign key.

How can i accomplish that. I have wrote custom data generator. But i was unable to use nullable int as Output of generator.

Answer 1

Hello Jahirhstu,

I am trying to involve someone familiar with this topic to further look at this issue.

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi,

Can you post a sample of your code and more details of the error(s), if any?

Thanks!

Cathy Miller

Answer 3

Following shows my custom data generator code. It works fine and shows in Generator Column's Dropdownlist in data generation plan when i make ID property and _id field as int. But i required nullable int as output. So when i am converting _id field and ID property as nullable int then it doesn't show in Generator Column's Dropdownlist in data generation plan. How can i resolve that.

[Output(Description = "", Name = "ID")]
        public int? ID
        {
            get
            {
                return _id;
            }
        }

        protected override void OnGenerateNextValues()
        {
            if (_rowNo % 2 == 0)
            {
                this._id = GetRandomDigit();
            }
            else
            {
                this._id = null;//_id is nullable int
            }

            _rowNo++;
        }

---

jahirhstu

Answer 4

Can Anyone help me about my issues. I am getting late. Please help.

---

jahirhstu

Answer 5

Hi,

Perhaps you would get a better response with a more in-depth level of support.  Please visit the below link to see the various paid support options that are available to better meet your needs. http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

Thanks,

Cathy Miller